sequel pro无法连接mysql服务器

1. 添加用户

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'your_passwd' WITH GRANT OPTION;
FLUSH PRIVILEGES;

 2. iptables里删除DROP 3306端口的规则

iptables -L -n --line-numbers
// 我的DROP 3306规则在第5行
iptables -D INPUT 5

 

参考资料:

报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost