A look at the Linux MySQL error error 1044:access denied for the user: ' @localhost ' to database ' MySQL '

Error message: 1044:access denied for User: ' @localhost ' to database ' MySQL '

Solutions under Linux: mysql> use mysql ERROR 1044 (42000): Access denied  for user ‘root‘ @ ‘localhost‘ to database ‘mysql‘ mysql> exit Bye [[email protected] ~]# service mysqld stop如果该命令不能执行可以用如下命令            #  mysql5.0.45/bin/mysqladmin-u Root shutdown 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 或者mysql目录下 ./bin/mysqld_safe--user=mysql &

A look at the Linux MySQL error error 1044:access denied for the user: ' @localhost ' to database ' MySQL '