一看便知linux下mysql報錯ERROR 1044: Access denied for user: '@localhost' to database 'mysql'

標籤：

錯誤資訊：ERROR 1044: Access denied for user: ‘@localhost‘ to database ‘mysql‘

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 &

一看便知linux下mysql報錯ERROR 1044: Access denied for user: '@localhost' to database 'mysql'