ubuntu mysql安裝和修改密碼
sudo apt-get install mysql-server sudo apt-get install mysql-client sudo apt-get install libmysqlclient-dev
文件:/etc/mysql/debian.cnf 記錄創建數據庫時初始賬戶,可用此登錄
error: 'Access denied for user 'root'@'localhost' (using password: YES)'解決辦法:
/etc/init.d/mysql stop #停止mysql or service mysql stop su root mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
#此步驟報錯:mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists
mkdir -p /var/run/mysqld chown mysql:mysql /var/run/mysqld mysqld_safe --user=mysql --skip-grant-tables --skip-networking & mysql -u root mysql #進入mysql交互模式 update user set authentication_string=PASSWORD("your_psswrd") where user='root'; #mysql的密碼都存儲在mysql庫的user表里,直接更新用戶表 update user set plugin="mysql_native_password"; flush privileges; #更新權限 quit; mysql -u root -p #重新登錄
在apt安裝軟件時,出現了hash校驗和不符的問題,熱點網換成學校網好了,貌似是運營商問題?
https://forum.ubuntu.com.cn/viewtopic.php?f=77&t=465499&hilit=Hash
啟動mysql又遇到問題:
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
浙公網安備 33010602011771號