Shulou(Shulou.com)06/02 Report--

This article mainly introduces the Linux system how to view the status of MySQL related knowledge, the content is detailed and easy to understand, the operation is simple and fast, has a certain reference value, I believe you will have something to gain after reading this Linux system how to view the status of MySQL, let's take a look.

View method:

. Use the command # service mysqld status command to view the startup status of mysql as shown in the figure: mysqld is stopped means that the mysql service is stopped, and if it is mysqld is running, it means that the mysql service is started

two。 Use the command chkconfig-list command to check the startup status of mysql as shown in the figure: if the service of mysqld is not found in the following service, if the status is off, the mysql service has not been started

3. Use the command chkconfig-list mysqld command to check the startup status of mysql as shown in the figure: if the service of mysqld is not found in the following service, if the status is off, the mysql service has not been started

4. Use the command chkconfig-list | grep on command to check the startup status of mysql as shown in the figure: if the mysql service has been started, then this service will be available here

5. Use the command chkconfig-list | grep off command to check the startup status of mysql as shown in the figure: if the mysql service is not started, then this service will be available here

6. Use the command ps aux | grep mysqld command to view the startup status of mysql as shown in the figure: the following figure shows the status of startup and non-startup.

7. Use the command pidof mysqld command to view the startup status of mysql as shown in the figure: if PID is displayed, the program is not started if PID is not displayed.

This is the end of the article on "how the Linux system checks the status of MySQL". Thank you for reading! I believe that everyone has a certain understanding of the knowledge of "how to check the status of MySQL in Linux system". If you want to learn more, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.