执行命令:
mysqladmin -uroot -pXX ping
显示以下结果为正常:
mysqld is alive
mysqladmin检测MySQL运行状态脚本:
#!/bin/bash
host=127.0.0.1
user=root
password=root
mysqladmin -h '$host' -u '$user' -p'$password' ping &>/dev/null
if [ $? -eq 0 ]
then
echo "MySQL is up"
else
echo "MySQL is down"
fi