python 建立ssh连接 并登陆mysql

实例1：paramiko模块
#!/usr/bin/python
import paramiko
ssh = paramiko.SSHClient()
ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy())
ssh.connect("10.10.1.1",22,"root","1111")
stdin, stdout, stderr = ssh.exec_command("mysql -uroot -p123456 -Dmysql -e 'select user from user'")
print stdout.readlines()
ssh.close()

实例2:用MySQLdb模块操作MySQL数据库非常方便
#!/usr/bin/python
import os, sys
import MySQLdb
try:
conn= MySQLdb.connect(host='10.10.1.1',user='root',passwd='123456’,db='address')
except Exception,e:
print e
sys.exit()
cursor=conn.cursor()
sql=’insert into address(name, address) values(%s, %s)’
value=((“lixiaomeng”,”china”),(“lxm”,”china”))
try
cursor.executemany(sql,values)
except Exception, e:
print e
sql=”select * from address”
cursor.execute(sql)
data=cursor.fetchall()
if data
for x in data:
print x[0],x[1]
cursor.close()
conn.close()