The solution to the inaccessibility of Port 3306 in mysql

The purpose of this article is to share with you the solution to the inaccessible port 3306 in mysql. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

The solution to the inaccessibility of the mysql 3306 error port: first, modify the update of the value of the host field to localhost in the user table of the mysql library to [%] with the code [mysql > use mysql], and then restart the mysql service to access it.

Workaround for the inaccessible port of mysql 3306 error:

1. Update the value of host field in user table of mysql library to localhost to%.

Command:

Mysql > use mysqlmysql > update user set host=' 'where host='localhost'

2. Before revision

3. After modification

4. Restart the mysql service and access it.

Thank you for reading! So much for the inaccessible solution to port 3306 in mysql. I hope the above content can be of some help to you so that you can learn more. If you think the article is good, you can share it and let more people see it.