1130-host ... is not allowed to connect to this MySql server

发表于 : 2017-10-17   · CC BY-NC-SA 4.0 ·   1532 人浏览

mysql默认是不能用客户端远程连接的
开启mysql远程登录

mysql -u root -p"密码" 
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;
mysql>FLUSH PRIVILEGES;
mysql>exit
MySQL centos 远程登录 1130