How to confirm that the MySQL service has been started under Linux CentOS

Little scum · Posted on 11/13/2017 11:57:21 AM

Linux CentOS is generally used as a server, so the MySQL service should be automatically started when it is booted. Under normal circumstances, the chkconfig command is used to view the service that is automatically started on startup:

#chkconfig --list
The actual use is as follows:

You can see that 2~5 of mysql is on, indicating that the mysql service will be started automatically by random start;

However, whether mysql is really started and whether it is really running, it needs to be determined by querying the monitoring port or querying process, and the following two methods can confirm whether mysql is starting and running:

Method 1: Query the port

#netstat -tulpn
The actual use is as follows:

MySQL monitors TCP port 3306, and the last line of the command operation result in the figure indicates that the MySQL service is running.

Method 2: Query the process

ps -ef | grep mysqld
If there are two processes, mysqld_safe and mysqld, the MySQL service is currently started.

The actual use is as follows:

[linux] How to confirm that the MySQL service has been started under Linux CentOS

Related Posts

Sections viewed