Shell script detects if MySQL is starting

(1) Port detection
# Netstat-lntup |grep 3306|wc-l
1

#1表示mysql已开启, 0 means close

#!/bin/bash
Port= ' Netstat-intup |grep 3306|wc-l '
If [$port-ne 1 ]
Then
/etc/init.d/mysqld start
Else
echo "Mysql is running"
Fi

(2) Whether the MySQL version is displayed
#!/bin/bash
Mysql-uroot-p password-E "select version ();"
If [$?-ne 0]
Then
/etc/init.d/mysqld start
Else
echo "MYSQL is running!!!"
Fi
#此方法最准确

This article from "All Technical Blog" blog, reproduced please contact the author!

Shell script detects if MySQL is starting