mysql> use MySQL
ERROR 1044 (42000): Access denied for user ' root ' @ ' localhost ' to database ' MySQL '
Mysql> exit
Bye
[[Email protected] ~]# service mysqld stop
Stopping mysqld: [OK]
[Email protected] ~]# mysqld_safe--user=mysql--skip-grant-tables--skip-networking &
[Email protected] ~]# 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
[[Email protected] ~]# service mysqld start
Restart Linux/os
ERROR 1044 (42000): Access denied for user ' root ' @ ' localhost ' to database ' MySQL '