Solution to MySQL startup successfully but not listening to the port

Problem Description

MySQL is started successfully. Use ps -ef |grep mysql to see the process, as shown below:

You can also log in to the server, as shown below:

But using netstat -antp| grep 3306 you can see that there is no listening port.

Checking the MySQL configuration file, the port has not changed.

Solution

After checking, it was found that skip-networking was used in the configuration file. It can be seen that the function of this option is not to listen to the port, and users on the same host are connected through sockets. External hosts will not be able to connect because there is no listening port.

After commenting out skip-networking , restart MySQL and you can see the port listening.

Summarize

The above is the full content of this article. I hope that the content of this article can bring some help to your study or work. If you have any questions, you can leave a message to communicate. Thank you for your support of 123WORDPRESS.COM.