python 监控mysql是否正常 | 张志明的个人博客

#!/usr/bin/env python
# coding=utf-8

# first install : yum install MySQL-python

import MySQLdb

try:
    conn = MySQLdb.connect(host='localhost',user='root',passwd='yourpasswd',port=3306)

    cur=conn.cursor()

    conn.select_db('mysql')

    count = cur.execute('select count(*) from user')
   
    print count

    cur.close()
    conn.close()

except MySQLdb.Error,e:
    print "Mysql Error %d: %s" % (e.args[0], e.args[1])

#!/usr/bin/env python

# coding=utf-8

# first install : yum install MySQL-python

import MySQLdb

try:

conn = MySQLdb.connect(host='localhost',user='root',passwd='yourpasswd',port=3306)

cur=conn.cursor()

conn.select_db('mysql')

count = cur.execute('select count(*) from user')

print count

cur.close()

conn.close()

except MySQLdb.Error,e:

print "Mysql Error %d: %s" % (e.args[0], e.args[1])

About
Latest Posts

Zhiming Zhang

Senior devops at Appannie

一个奔跑在运维路上的胖子

Latest posts by Zhiming Zhang (see all)

什么是ami - 二月 22, 2021
istio Ingress Gateways - 十一月 25, 2020
Istio VirtualService - 十一月 23, 2020

一	二	三	四	五	六	日
« 二
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30	31