MySQL service is not up due to port problems

Today, a colleague said that his MySQL database does not come, very depressed, the error is as follows

#/etc/init.d/mysql Start
Starting MySQL .... error! The server quit without updating PID file (/data/mysql/mysql3306/data/mysql.pid).

The first time I thought about the error log, the error log is as follows:

# Vim Error.log
2017-05-04t13:35:17.965606z 0 [ERROR] Can ' t start server:bind on TCP/IP port:permission denied
2017-05-04t13:35:17.965643z 0 [ERROR] do already has another MYSQLD server running on port:1005?
2017-05-04t13:35:17.965674z 0 [ERROR] aborting

(1) First reaction is insufficient authority, through the troubleshooting, sufficient user rights, MySQL data Catalog owner and the group is MySQL, so excluded;

(2) Error The second sentence indicates that there may be a MySQL service occupying 1005 ports, so the Ss-nltup|grep MySQL command to view the result is that there is no MySQL service.

(3) Finally on the internet Baidu a lot, have no fruit, suddenly have an idea, MySQL port range contains 1005? So the view manual found as follows:

--port=port_num
The port number that is the server should use when listening for TCP/IP connections. The port number
Must be 1024x768 or higher unless the server is started by the root system user.

The manual is very clear, the port range of MySQL is greater than or equal to 1024, the cost of a long time, only to find that the original manual has been written dead, real thankless, or honestly use the default port, read more manuals.

This article is from the "10979687" blog, please be sure to keep this source http://10989687.blog.51cto.com/10979687/1922213

MySQL service is not up due to port problems