外贸公司访问国外网站,wordpress去掉版本号,wordpress 标签库,家乡网站怎么做WAMP 64bit安装好后#xff0c;连接数据库#xff0c;提示#1130 Host ‘localhost’ is not allowed to connect to this MySQL server1.首先停止mysql服务#xff0c;如果不会可以直接停止所有wampserver。2.然后打开一个命令行窗口#xff0c;切换到mysql的安装目录…WAMP 64bit安装好后连接数据库提示#1130 Host ‘localhost’ is not allowed to connect to this MySQL server1.首先停止mysql服务如果不会可以直接停止所有wampserver。2.然后打开一个命令行窗口切换到mysql的安装目录例如我的路径是cd C:\wamp\bin\mysql\mysql5.1.36\bin回车mysqld –skip-grant-tables回车不要关闭CMD随它放着然后第一次可能会弹出对话框允许访问3.再打开一个命令行窗口cd C:\wamp\bin\mysql\mysql5.1.36\binmysql -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;
