I'm having a problem today. Unable to remotely link MySQL
Host ' XXX ' is not allowed to connect to this MySQL server solution/How to turn on MYSQ
Solve the first prompt question first
It turns out that no Telnet user was created in MySQL
Log in to MySQL
MySQL -uroot-p123456
How to turn on MySQL remote account-2) Create a remote login user and authorize
> Grant all privileges the test_db.* to [email protected]' 192.168.1.101 ' identified by ' 123456 ';
(in Baidu search ' IP ' will show the current local IP address)
The above statement indicates that all permissions to the TEST_DB database are granted to root, allowing the root user to remotely log on to the 192.168.1.101 IP and set the root user's password to 123456.
Then there's the firewall problem.
/etc/sysconfig/iptables
Add the following sentence
-j ACCEPT
Remote connection to Linux server MySQL