linux开启mysql窗口_linux操作系统中如何查看是否开启了MySQL服务呢？

摘要:

下文讲述linux操作系统下查看MySQL服务是否开启的方法分享&＃xff0c;如下所示&＃xff1b;

MySQL数据库服务器是linux中应用最广泛的服务之一&＃xff0c;下文将讲述检测MySQL数据库是否对外提供服务的方法分享&＃xff0c;如下所示:

实现思路:

方式1&＃xff1a;查看是否存在mysqld进程

ps -ef |grep mysqld

方式2:查看是否存在mysqld进程

ps -aux|grep mysqld

方式3:查看ysqld的状态

service mysqld status

方式4&＃xff1a;查看mysql的状态

service mysql status

例&＃xff1a;

[root&＃64;**** mySqlBack]# ps -ef|grep mysqld

mysql 14457 20949 0 Sep09 ? 00:04:41 /usr/local/mysql/libexec/mysqld --basedir&＃61;/usr/local/mysql --datadir&＃61;/usr/local/mysql/var ***********

root 17671 17627 0 09:49 pts/0 00:00:00 grep mysqld

root 20949 1 0 Sep04 ? 00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir&＃61;/usr/local/mysql/var --pid-file&＃61;/usr/local/mysql/var/*********.pid

[root&＃64;**** mySqlBack]# ps -aux|grep mysql

mysql 14457 0.4 2.3 591868 23788 ? Sl Sep09 4:41 /usr/local/mysql/libexec/mysqld --basedir&＃61;/usr/local/mysql --datadir&＃61;/usr/local/mysql/var

root 17677 0.0 0.0 103320 844 pts/0 S&＃43; 09:49 0:00 grep mysql

root 20949 0.0 0.0 11340 240 ? S Sep04 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir&＃61;/usr/local/mysql/var --pid-file&＃61;/usr/local/mysql/var/**********.pid

[root&＃64;***** mySqlBack]# service mysqld status

MySQL running (14457) [ OK ]