GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.8' IDENTIFIED BY 'www.linuxidc.com' WITH GRANT OPTION; // 给某个服务器赋予权限
相关文章
- Mysql远程连接报错：Host is not allowed to connect to this MySQL server
- Mysql-报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- ERROR 2002 (HY000): Cant connect to local MySQL server through socket的解决方法
- 【mysql报错】ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/tmp/‘
- ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/run/mysqld/‘
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket
- ERROR 2002 (HY000): Can 't connect to local MySQL server through socket '/tmp/mysql.sock '(2) "
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)解决办法
- java.sql.SQLException: null, message from server: "Host 'xxx' is not allowed to connect to this MySQL server"
- Mysql 数据库允许远程连接 服务器连接错误 Host 'XXX' is not allowed to connect to this MySQL server