WAMP 64bit

安裝好后，連接數(shù)據(jù)庫(kù)，提示

#1130 Host 'localhost' is not allowed to connect to this MySQL server

1.首先停止mysql服務(wù)，如果不會(huì)可以直接停止所有wampserver。

2.然后打開(kāi)一個(gè)命令行窗口，切換到mysql的安裝目錄，例如我的路徑是：

cd C:\wamp\bin\mysql\mysql5.1.36\bin

回車

mysqld --skip-grant-tables

回車

不要關(guān)閉CMD，隨它放著

然后第一次可能會(huì)彈出對(duì)話框，允許訪問(wèn)

3.再打開(kāi)一個(gè)命令行窗口

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：

會(huì)提示：ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot exe

解決辦法，在命令行輸入：mysql> flush privileges;