Ubuntu MySQL第一次登陆
初次登陆如果输入mysql -u root -p 可能会出现以下问题:
ERROR 1045 (28000): Access denied for user’root’@‘localhost’ (using password: YES) *或者NO
解决方法:
- [ ] sudo cat /etc/mysql/ debian.cnf
然后可以看到
[client]
host = localhost
user = debian-sys-maint
password = xqoWA1z679AfgsWU
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host = localhost
user = debian-sys-maint
password = xqoWA1z679AfgsWU
socket = /var/run/mysqld/mysqld.sock
直接找到user和password重新登陆就行了
输入密码处直接复制黏贴就行,手敲容易出错
本博客链接为https://blog.csdn.net/weixin_44794718/article/details/103719932