mysql error：Host is not allowed to connect to this MySql server

ALL PRIVILEGES ON *.* TO ‘username‘@‘%‘ IDENTIFIED BY ‘password‘ WITH GRANT OPTION; FLUSH PRIVILEGES;

2> 允许用户从指定IP访问mysql server

其中，host为特定IP地址

GRANT ALL PRIVILEGES ON *.* TO ‘username‘@‘host‘ IDENTIFIED BY ‘password‘ WITH GRANT OPTION;
FLUSH PRIVILEGES;

3> 允许用户从特定IP访问mysql server指定数据库

其中，host为特定IP地址

GRANT ALL PRIVILEGES ON dbname.* TO ‘username‘@‘host‘ IDENTIFIED BY ‘password‘ WITH GRANT OPTION;
FLUSH PRIVILEGES;

 

mysql error：Host is not allowed to connect to this MySql server

标签：

本文系统来源：http://www.cnblogs.com/chenyongjun/p/4604924.html

【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！