Test PHP connection to MYSQL

Create a file testmysql. php with the following content :? Php $ linkMySQL_connect ('mysql server name', MySQL Username ', password'); if (! $ Link) echoError !; ElseechoOk !; MySQL_close ();? HostAisnotallowedtoconnecttothisMySQLserver first check the firewall and then

Create a file testmysql. php with the following content :? Php $ link = MySQL_connect ('mysql server name', 'mysql username', 'Password'); if (! $ Link) echo Error !; Else echo OK !; MySQL_close ();? Host 'A' is not allowed to connect to thisMySQL server first view the firewall and then

Create a file testmysql. php with the following content:

$ Link = MySQL_connect ('mysql server name', 'mysql username', 'Password ');
If (! $ Link) echo "Error! ";
Else echo "OK! ";
MySQL_close ();
?>

Host 'A' is not allowed to connect to thisMySQL server

First view the Firewall

Then

View Solution

ERROR 1130: Host '192. 168.1.22 'is not allowed to connect tothis MySQL server

Solution:
1.Change the table.It may be that your account is not allowed to log on remotely, but only on localhost. At this time, you only need to log in to mysql on the computer of localhost, and change the "host" entry in the "user" table in the "mysql" database to "%" from "localhost"

Mysql-u root-pvmwaremysql> usemysql; mysql> update user set host = '%' where user = 'root'; mysql> select host, user from user;