解决Navicat 出错:1130-host *** is not allowed to connect to this MySql server,MySQL

授权法(推荐)

eg1：你想dxp使用dxp666从任何主机连接到mysql服务器:(SQL代码)

-- 授权语句

GRANT ALL PRIVILEGES ON *.* TO 'dxp'@'%' IDENTIFIED BY 'dxp666' WITH GRANT OPTION;

-- 使修改生效

FLUSH   PRIVILEGES;

eg2：如果你想允许用户dxp从ip为192.168.1.1的主机连接到mysql服务器，并使用dxp666作为密码

GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.2' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

FLUSH   PRIVILEGES;

如果你想允许用户myuser从ip为192.168.1.1的主机连接到mysql服务器的dxpdb数据库，并使用mypassword作为密码

GRANT ALL PRIVILEGES ON dxpdb.* TO 'dxp'@'192.168.1.2' IDENTIFIED BY 'dxp100' WITH GRANT OPTION;

FLUSH   PRIVILEGES;