Warning: MySQL Connection Failed: Host 'localhost' is not allowed to connect to this MySQL server in C:\apache\htdocs\phpmyadmin\lib.inc.php on line 255 Error MySQL said: Back
不是,进入mysql的权限就是user表等控制的!一个真正的超级用户一般需要两条记录,最好通过grant方式授予,这样最直观!grant all on *.* to root@'localhost' identified by 'your pass' with grant option grant all on *.* to root@'%' identified by 'your pass'这样,在user表里会有两条记录,一条host字段为localhost,一条host字段为%建议你多参考MySQL手册!里面讲的很清楚!!!!
但是我删除之前,我可以很确定的说host字段里没有%,user字段里没有_ 我记得它们在phpmyadmin的use表里内容如下: user host password root localhost rootshoulou 210.75.40.208 密码都是经过加密的,都是最高权限。
在手工编辑权限表之后,需要执行Flush Privileges来重载mysql数据库的权限表!如果使用GRANT或者REVOKE语句,就不用!
Warning: MySQL Connection Failed: Host 'localhost' is not allowed to connect to this MySQL server in C:\apache\htdocs\phpmyadmin\lib.inc.php on line 255
Error
MySQL said:
Back
grant all on *.* to root@'%' identified by 'your pass'这样,在user表里会有两条记录,一条host字段为localhost,一条host字段为%建议你多参考MySQL手册!里面讲的很清楚!!!!
我记得它们在phpmyadmin的use表里内容如下:
user host password
root localhost
rootshoulou 210.75.40.208
密码都是经过加密的,都是最高权限。