ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO)

2019/01/30

在deepin下安装完mysql后登陆时没有密码,出现如下提示:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

使用sudo可以不要密码进入

sudo mysql -u root -p

进入mysql命令行,输入

update mysql.user set plugin = 'mysql_native_password' where user = 'root';
flush privileges;

退出后再登陆不用sudo也可成功,此时也不用输入密码

要设置密码,进入mysql命令行,输入

set password for 'root'@'localhost' = password('ht1234');

退出再登陆时就需要密码了。

服务操作命令

/etc/init.d/mysql restart
sudo service mysql status
sudo service mysql stop
sudo service mysql start