phpstudy小皮面板: 连接mysql数据库问题：1130 host 'PHP' is not allowed to connect to this MySQL server

phpstudy小皮面板: 连接mysql数据库问题：1130 host 'PHP' is not allowed to connect to this MySQL server

解决：

1、先在服务器中通过命令行方式（打开phpstudy界面->右下角其他菜单选项->MySQL工具->MySQL命令行）
登录mysql：mysql   -u root -p 密码 （如果mysql初始账号和密码都是root）
2、执行use mysql;
3、执行grant all privileges on *.* to root@'%' identified by '密码';
4、执行flush privileges;

grant all privileges on *.* to root@'%' identified by 'root';

5.7 MySQL：DBA管理员：新添加帐号、报错：1130-Host is not allowed to connect to this MySQL server
http://www.zh-cjh.com/shujuku/2699.html
5.8 MySQL：DBA管理员：使用客户端连接本地mysql，报错：1251- Client does not support authentication protocol requested by server;consider upgrading Mysql client。
http://www.zh-cjh.com/shujuku/2700.html
登录mysql数据库出现 : ERROR 1045 (28000): Access denied for user ‘ODBC‘@‘localhost‘ (using password: NO)
http://www.zh-cjh.com/shujuku/2501.html
MySQL连接：Host is not allowed to connect to this MySQL server
http://www.zh-cjh.com/shujuku/2502.html

phpstudy小皮面板: 连接mysql数据库问题：1130 host 'PHP' is not allowed to connect to this MySQL server
http://www.zh-cjh.com/kaifabiancheng/1611.html

MySQL（列表、list、全）mysqllist
http://www.zh-cjh.com/wenzhangguilei/2503.html
文章归类、所有文章列表、LISTLIST
http://www.zh-cjh.com/wangzhangonggao/2195.html