MySQL for Linux cannot be accessed remotely

1. First, you need to confirm whether the user only allows localhost access;

Log in to MySQL under Linux

mysql-uroot-p password;

Use MySQL;

Select ' Host ', ' User ' from ' user '

You can see:

If your user's host is not%, you cannot access it remotely

2. The default Linux firewall is not developing 3306 of this port

Vi/etc/sysconfig/iptables //Open this file to see if there are any 3306

If not, add

Under "-A input–m State--state new–m tcp–p–dport 22–j ACCEPT", add:

-A input-m State--state new-m tcp-p-dport 3306-j ACCEPT

Save, and then restart

Service Iptables Restart

MySQL for Linux cannot be accessed remotely