解决MySQL【1130】错误
- 首先停止mysql服务.
- 然后打开一个命令行窗口,切换到mysql的安装目录,例如我的路径是:cd C:\wamp\bin\mysql\mysql5.1.36\bin 回车
- mysqld --skip-grant-tables 回车
- 不要关闭CMD,随它放着,然后第一次可能会弹出对话框,允许访问
- 再打开一个命令行窗口cd C:\wamp\bin\mysql\mysql5.1.36\bin
- mysql -u root -p 输入密码
- use mysql;
delete from user where user=‘root’;mysql> CREATE USER ‘root’@‘localhost’ IDENTIFIED BY ‘123456’;
这里可能会提示:ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot exe
解决办法:mysql> flush privileges; - mysql> GRANT ALL PRIVILEGES ON . TO ‘root’@‘localhost’ WITH GRANT OPTION;
- mysql> CREATE USER ‘root’@’%’ IDENTIFIED BY ‘123456’;mysql> GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ WITH GRANT OPTION;