ubuntu 20.04 Access denied for user 'root'@'localhost'

/ 默认分类 / 0 条评论 / 2867浏览

mysqlubuntu

ERROR 1698 (28000): Access denied for user 'root'@'localhost'

同时解决：ERROR 1698 (28000): Access denied for user 'root'@'localhost' sudo cat /etc/mysql/debian.cnf 记住password 项的值 是初始密码

mysql -u debian-sys-maint -p

输入初始密码

use mysql;

update mysql.user set authentication_string=password('') where user='root' and Host ='localhost';

update user set plugin="mysql_native_password" where user ='root';

flush privileges;

quit;

sudo service mysql restart

此时mysql初始化密码为空 后期自己修改即可

mysql -u root -p 回车即可

与ubuntu18一样

本站文章除注明转载/出处外，均为本站原创或翻译，转载前请务必署名,转载请标明出处
最后编辑时间为: 2020/11/03 15:50