mysql ERROR 1044 (42000): Access denied for user ''@'localho

按以上方法修改好密码后,关闭命令行运行mysql的那个窗口，此时即关闭了mysql，如果发现mysql仍在运行的话可以结束掉对应进程来关闭。
启动mysql服务。

linux下的处理方法：

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 & [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

您可能感兴趣的文章:

MySQL错误ERROR 2002 (HY000): Can''t connect to local MySQL server through socketmysql error:#1062 Duplicate entry ‘***′ for key 1问题解决方法MYSQL ERROR 1045 (28000): Access denied for user (using password: YES)问题的解决MySQLdb ImportError: libmysqlclient.so.18解决方法mysql登录报错提示：ERROR 1045 (28000)的解决方法UCenter info: MySQL Query Error SQL:SELECT value FROM [Table]vars WHERE noteexistsmysql不能启动报error2013错误的多种解决方案mysql错误处理之ERROR 1786 (HY000)winxp 安装MYSQL 出现Error 1045 access denied 的解决方法mysql启动时出现ERROR 2003 (HY000)问题的解决方法