网上很多方法都试过就是不行,最后通过设置端口的防火墙成功连接
方法1(ubuntu):
sudo ufw allow 3306
方法2:
iptables -I INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT
方法3(centos):
firewall-cmd --add-port=3306/tcp --permanent
firewall-cmd --reload
firewall-cmd --query-port=3306/tcp
mysql -u root -p
use mysql;
select host,user from user where user='root';
update user set host = '%' where user ='root';
flush privileges;