ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'mysql'

mysql> use mysql
ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'mysql'
mysql> exit
Bye
[root@testtest ~]# service mysqld stop
Stopping mysqld:                                           [  OK  ]
[root@testtest ~]# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

 

(base) [root@VM-0-2-centos ~]# 240219 16:51:35 mysqld_safe Logging to '/var/log/mysqld.log'.
240219 16:51:35 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/bin/mysqld_safe: line 183: 22715 Killed                  nohup /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --skip-grant-tables --skip-networking --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock < /dev/null > /dev/null 2>&1
240219 16:51:37 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

按回车键

[1]+  Done                    mysqld_safe --user=mysql --skip-grant-tables --skip-networking

[root@testtest ~]# mysql -u root -p -hlocalhost
Enter password:

mysql> use mysql

mysql> SELECT host,user,password,Grant_priv,Super_priv FROM mysql.user;

mysql> UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';

mysql> FLUSH PRIVILEGES;

mysql> GRANT ALL ON *.* TO 'root'@'localhost';

mysql> GRANT ALL ON *.* TO 'root'@'cn.cn.cn.cn';

mysql> GRANT ALL ON *.* TO 'root'@'245.245.245.245';

mysql> GRANT ALL ON *.* TO 'root'@'127.0.0.1';

mysql> FLUSH PRIVILEGES;


mysql> quit
Bye
[root@testtest ~]# service mysqld start

restart Linux/OS