What should I do if mysql 3306 port cannot be accessed?

Mysql 3306 port cannot be accessed Solution: 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; mysql> update user set host = '% ' ].

Mysql 3306 port cannot be accessed solution:

Modify the host field value in the user table of the mysql library to localhost The update is %.

Command:

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

Before modification

After modification

Restart The mysql service can be accessed.

More related free learning recommendations: mysql tutorial(Video)

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