What to do if mysql 3306 port cannot be accessed

Mysql 3306 error port cannot be accessed solution: first modify the host field value in the user table of the mysql library to localhost and update it to [%], the code is [mysql> use mysql]; then restart the mysql service access.

mysql 3306 error port inaccessible solution:

1. Modify the host field in the user table of the mysql library Values ​​of localhost are updated to %.

Command:

mysql>  use mysql
mysql>  update user set host = '%' where host='localhost';

2. Before modification

3.After modification

##4. Restart the mysql service to access.

Related learning recommendations:

mysql tutorial

The above is the detailed content of What to do if mysql 3306 port cannot be accessed. For more information, please follow other related articles on the PHP Chinese website!