{"id":212,"date":"2015-10-21T12:15:40","date_gmt":"2015-10-21T04:15:40","guid":{"rendered":"http:\/\/cn.hostease.com\/xueyuan\/?p=212"},"modified":"2015-11-10T13:50:09","modified_gmt":"2015-11-10T05:50:09","slug":"shell%e8%84%9a%e6%9c%ac%ef%bc%9a%e7%9b%91%e6%8e%a7mysql%e6%9c%8d%e5%8a%a1%e6%98%af%e5%90%a6%e6%ad%a3%e5%b8%b8","status":"publish","type":"post","link":"https:\/\/cn.hostease.com\/xueyuan\/jishu\/fuwuqi\/shell%e8%84%9a%e6%9c%ac%ef%bc%9a%e7%9b%91%e6%8e%a7mysql%e6%9c%8d%e5%8a%a1%e6%98%af%e5%90%a6%e6%ad%a3%e5%b8%b8\/","title":{"rendered":"shell\u811a\u672c\uff1a\u76d1\u63a7MySQL\u670d\u52a1\u662f\u5426\u6b63\u5e38"},"content":{"rendered":"

\u76d1\u63a7MySQL\u670d\u52a1\u662f\u5426\u6b63\u5e38\uff0c\u901a\u5e38\u7684\u601d\u8def\u4e3a<\/strong>\uff1a\u68c0\u67e53306\u7aef\u53e3\u662f\u5426\u542f\u52a8\uff0cps\u67e5\u770bmysqld\u8fdb\u7a0b\u662f\u5426\u542f\u52a8\uff0c\u547d\u4ee4\u884c\u767b\u5f55mysql\u6267\u884c\u8bed\u53e5\u8fd4\u56de\u7ed3\u679c\uff0cphp\u6216jsp\u7a0b\u5e8f\u68c0\u6d4b\uff08\u9700\u8981\u5f00\u53d1\u4eba\u5458\u5f00\u53d1\u7a0b\u5e8f\uff09\u7b49\u7b49\uff1b<\/p>\n

\u65b9\u6cd51\uff1a\u76d1\u542c3306\u7aef\u53e3<\/strong><\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n<\/td>\n
\n
\n
#!\/bin\/bash<\/code><\/div>\n
#written\u00a0by\u00a0mofansheng@2015-10-15<\/code><\/div>\n
<\/div>\n
port=`<\/code>netstat<\/code>\u00a0-nlt|<\/code>grep<\/code>\u00a03306|<\/code>wc<\/code>\u00a0-l`<\/code><\/div>\n
if<\/code>\u00a0[\u00a0$port\u00a0-<\/code>ne<\/code>\u00a01\u00a0]<\/code><\/div>\n
then<\/code><\/div>\n
\u00a0<\/code>\/etc\/init<\/code>.d<\/code>\/mysqld<\/code>\u00a0start<\/code><\/div>\n
else<\/code><\/div>\n
\u00a0<\/code>echo<\/code>\u00a0\"MySQL\u00a0is\u00a0running\"<\/code><\/div>\n
fi<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\u65b9\u6cd52\uff1a\u67e5\u770bmysqld\u8fdb\u7a0b<\/strong><\/p>\n

\u6ce8\u610f\u6ce8\u610f\uff1a\u5982\u679c\u4f7f\u7528\u8fdb\u7a0b\u8fc7\u6ee4\u7684\u8bdd\uff0c\u811a\u672c\u540d\u79f0\u5982\u679c\u91cc\u9762\u5305\u542bmysql\u7684\u8bdd\uff0c\u811a\u672c\u6267\u884c\u6709\u5751\uff0c\u5207\u8bb0\uff01\uff01\uff01\u56e0\u4e3a\u4f1a\u628a\u811a\u672c\u4e5fgrep\u4e86\u4e00\u6b21\uff0c\u5bfc\u81f4\u7ed3\u679c\u4e0d\u51c6\u786e\uff1b<\/strong><\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n<\/td>\n
\n
\n
[root@localhost\u00a0baby]<\/code>#\u00a0cat\u00a0check_mysql.sh<\/code><\/div>\n
#!\/bin\/bash<\/code><\/div>\n
#written\u00a0by\u00a0mofansheng@2015-10-15<\/code><\/div>\n
<\/div>\n
process=`<\/code>ps<\/code>\u00a0-ef\u00a0|<\/code>grep<\/code>\u00a0mysql|<\/code>grep<\/code>\u00a0-<\/code>v<\/code>\u00a0grep<\/code>\u00a0|<\/code>wc<\/code>\u00a0-l`<\/code><\/div>\n
if<\/code>\u00a0[\u00a0$process\u00a0-<\/code>ne<\/code>\u00a02\u00a0]<\/code><\/div>\n
then<\/code><\/div>\n
\u00a0<\/code>\/etc\/init<\/code>.d<\/code>\/mysqld<\/code>\u00a0start<\/code><\/div>\n
else<\/code><\/div>\n
\u00a0<\/code>echo<\/code>\u00a0\"MySQL\u00a0is\u00a0running\"<\/code><\/div>\n
fi<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\u6267\u884c\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n

[root@localhost baby]# sh check_mysql.sh<\/p>\n

Starting MySQL SUCCESS!<\/p>\n

\u6539\u540d\u4e4b\u540e\u6267\u884c\u4e3a\u6b63\u5e38\u7ed3\u679c\uff1a<\/strong><\/p>\n

[root@localhost baby]#\u00a0mv check_mysql.sh check_db.sh<\/p>\n

[root@localhost baby]# sh check_db.sh<\/p>\n

MySQL is running<\/p>\n

\u65b9\u6cd53:\u53cc\u4fdd\u9669\uff0c\u8fdb\u7a0b\u548c\u7aef\u53e3\u90fd\u6210\u529f\u624d\u7b97mysql\u670d\u52a1\u6b63\u5e38<\/strong><\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n<\/td>\n
\n
\n
#!\/bin\/bash<\/code><\/div>\n
#written\u00a0by\u00a0mofansheng@2015-10-15<\/code><\/div>\n
<\/div>\n
port=`<\/code>netstat<\/code>\u00a0-nlt|<\/code>grep<\/code>\u00a03306|<\/code>wc<\/code>\u00a0-l`<\/code><\/div>\n
process=`<\/code>ps<\/code>\u00a0-ef\u00a0|<\/code>grep<\/code>\u00a0mysql|<\/code>grep<\/code>\u00a0-<\/code>v<\/code>\u00a0grep<\/code>\u00a0|<\/code>wc<\/code>\u00a0-l`<\/code><\/div>\n
if<\/code>\u00a0[\u00a0$port\u00a0-<\/code>eq<\/code>\u00a01\u00a0]\u00a0&&\u00a0[\u00a0$process\u00a0-<\/code>eq<\/code>\u00a02\u00a0]<\/code><\/div>\n
then<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>echo<\/code>\u00a0\"MySQL\u00a0is\u00a0running\"<\/code><\/div>\n
else<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>\/etc\/init<\/code>.d<\/code>\/mysqld<\/code>\u00a0start<\/code><\/div>\n
fi<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

4:\u4f7f\u7528\u5ba2\u6237\u7aef\u767b\u5f55mysql\u6267\u884c\u547d\u4ee4\uff0c\u67e5\u770b\u8fd4\u56de\u7ed3\u679c\u6d4b\u8bd5\u670d\u52a1\u662f\u5426\u542f\u52a8\uff0c\u7406\u8bba\u4e0a\u6b64\u65b9\u6cd5\u6700\u53ef\u9760\u3002<\/strong><\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n<\/td>\n
\n
\n
[root@localhost\u00a0baby]<\/code>#\u00a0cat\u00a0check_db_client.sh<\/code><\/div>\n
#!\/bin\/bash<\/code><\/div>\n
#written\u00a0by\u00a0mofansheng@2015-10-15<\/code><\/div>\n
<\/div>\n
mysql\u00a0-uroot\u00a0-p123456\u00a0-e\u00a0<\/code>\"select\u00a0version();\"<\/code>\u00a0&><\/code>\/dev\/null<\/code><\/div>\n
if<\/code>\u00a0[\u00a0$?\u00a0-<\/code>ne<\/code>\u00a00\u00a0]<\/code><\/div>\n
then<\/code><\/div>\n
\u00a0<\/code>\/etc\/init<\/code>.d<\/code>\/mysqld<\/code>\u00a0start<\/code><\/div>\n
else<\/code><\/div>\n
\u00a0<\/code>echo<\/code>\u00a0\"MySQL\u00a0is\u00a0running\"<\/code><\/div>\n
fi<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\u6267\u884c\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n

[root@localhost baby]# sh check_db_client.sh<\/p>\n

MySQL is running<\/p>\n","protected":false},"excerpt":{"rendered":"

\u76d1\u63a7MySQL\u670d\u52a1\u662f\u5426\u6b63\u5e38\uff0c\u901a\u5e38\u7684\u601d\u8def\u4e3a\uff1a\u68c0\u67e53306\u7aef\u53e3\u662f\u5426\u542f\u52a8\uff0cps\u67e5\u770bmysqld\u8fdb\u7a0b\u662f\u5426\u542f\u52a8\uff0c\u547d\u4ee4\u884c\u767b … \u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[9],"tags":[45,62,63],"class_list":["post-212","post","type-post","status-publish","format-standard","hentry","category-fuwuqi","tag-mysql","tag-shell","tag-63"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/212","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/comments?post=212"}],"version-history":[{"count":1,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/212\/revisions"}],"predecessor-version":[{"id":213,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/212\/revisions\/213"}],"wp:attachment":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/media?parent=212"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/categories?post=212"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/tags?post=212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}