前言:
一:配置
ubuntu 18.04
mysql 5.7.30
二:問題
ubuntu18.04下mysql安裝時沒有出現密碼提示,安裝後自己有一個預設的使用者名以及密碼
解決方案:
1. 在終端輸入:
sudo vi /etc/mysql/debian.cnf
可以檢視到:
user = debian-sys-maint
password = WU2UbLLd4totyAs8
![](https://img.laitimes.com/img/__Qf2AjLwojIjJCLyojI0JCLiETPwJWZ3ZCMwcTP39zZuBnLuVzRjVXTq10dVRUTyklaNJDMp5UMBpmTwUkaNBTRU90dVRUT3lERNlHMD10MFpWT41EVNZXVE10dJRUT5hzQNNTRq1EeNRVT2NmMiNnSywEd5ITW110MaZHetlVdO1GT3lERNl3YXJGc5kHT20ESjBjUIF2Lc12bj5SYphXa5VWen5WY35iclN3Ztl2Lc9CX6MHc0RHaiojIsJye.png)
2. 用該賬戶登陸mysql:
注意:這裡的密碼是上面的{随機密碼}
mysql -u debian-sys-maint -p
3. 設定root的使用者密碼:
update mysql.user set authentication_string=password('123456') where user ='root' and Host='localhost';
update mysql.user set plugin = 'mysql_native_password';
flush privileges;
quit
4. 重新開機mysql服務:
sudo /etc/init.d/mysql stop
sudo /etc/init.d/mysql start
5. 用root登陸:
mysql -u root -p
————————————————
參考連結:https://blog.csdn.net/Kwoky/article/details/89492074