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

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!