东风雨 下载,去皱美白,yazhoubt
第一种方法:利用mysql命令查看
mysql 内建直接看 status 就可以看到系统常见讯息, 如下述范例:
检查mysql是否成功启动
#!/bin/bash #mysql check port="0" port=`netstat -lnt | grep 3306 | wc -l ` echo $port if [ $port -eq 1 ] then echo "mysql is running" else echo "mysql is not running" echo "progrome reeady to start mysql " sudo service mysql start ./check_mysql.sh fi
检测 mysql 是否宕掉,如果宕掉则启动
如果你的 mysql 经常宕机,可以用这个脚本来实现宕机后自动启动,把它加到 crontab 里执行即可。
详细介绍请看
#!/bin/bash result=`/usr/bin/mysqladmin ping` expected='mysqld is alive' if [[ "$result" != "$expected" ]] then echo "it's dead - restart mysql" # email subject subject="[mysql error] - attempting to restart service" # email to ? email="info@endyourif.com" # email text/message emailmessage="/tmp/emailmessage.txt" echo "$result was received"> $emailmessage echo "when we were expected $expected" >>$emailmessage # send an email using /bin/mail mail -s "$subject" "$email" < $emailmessage sudo /etc/init.d/mysql restart fi
mysql bat启动和关闭服务bat版
@echo off for /f "skip=3 tokens=4" %%i in ('sc query mysql') do set "zt=%%i" &goto :next :next if /i "%zt%"=="running" ( echo 已经发现该服务在运行,正在已经关闭服务 net stop mysql ) else ( echo 该服务现在处理停止状态,正在现在开启服务 net start mysql ) exit pause
经测试有时候不是很好用。
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
小白安装登录mysql-8.0.19-winx64的教程图解(新手必看)
Navicat连接MySQL时报10060、1045错误及my.ini位置问题
网友评论