WAMP 64bit
安裝好后登夫,連接數(shù)據(jù)庫,提示
#1130 Host 'localhost' is not allowed to connect to this MySQL server
1.首先停止mysql服務(wù)允趟,如果不會可以直接停止所有wampserver恼策。
2.然后打開一個命令行窗口,切換到mysql的安裝目錄潮剪,例如我的路徑是:
cd C:\wamp\bin\mysql\mysql5.1.36\bin
回車
mysqld --skip-grant-tables
回車
不要關(guān)閉CMD涣楷,隨它放著
然后第一次可能會彈出對話框,允許訪問
3.再打開一個命令行窗口
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'; ?(注1)
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;
注1:
會提示:ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot exe
解決辦法抗碰,在命令行輸入:mysql> flush privileges;