直接复制代码，无需修改
第一：// %:表示从任何主机连接到mysql服务器
GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
第二:
FLUSH PRIVILEGES;
然后再使用navicat连接，就可以连接上了
相关文章
- 使用云服务器配置MariaDB环境,Navicat远程连接一直出错误代码 "2002 - Can't connect to server on '' (10060)"
- Navicat 连接MariaDB 失败： Host '*' is not allowed to connect to this MariaDB server
- ERROR 1130: Host is not allowed to connect to this MySQL server
- message from server: "Host is not allowed to connect to this MySQL server"解决办法
- 出现并解决Navicat 报错:1130-host ... is not allowed to connect to this MySql server,MySQL
- 远程登录mysql,报错：message from server: "Host is not allowed to connect to this MySQL server"解决办法
- Mysql连接报错：1130-host ... is not allowed to connect to this MySql server如何处理
- Mysql远程连接报错:SQL Error (1130): Host '192.168.6.128' is not allowed to connect to this MySQL server
- Mysql远程连接报错:SQL Error (1130): Host '192.168.61.128' is not allowed to connect to this MySQL server
- Mysql远程登录报错：Host '192.168.1.3' is not allowed to connect to this MySQL server