The solution to the inaccessibility of Port 3306 in mysql

The purpose of this article is to share with you the solutions that port 3306 in mysql cannot access. 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 inaccessible port of mysql 3306: change the value of the host field in the user table of the mysql library to localhost and update it to [%] with the code [mysql > use mysql;mysql > update user set host ='%'].

Workarounds for inaccessible mysql 3306 ports:

Update the update that modifies the host field value to localhost in the user table of the mysql library to%.

Command:

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

Before modification

After modification

Restart the mysql service to access it.

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