import os
import pexpect
os.system('service mysql restart')
try:
print 'create database water ...'
mysql2 = pexpect.spawn('mysql -u root -p', timeout=3)
mysql2.expect("Enter password:")
mysql2.sendline('') # 密码
mysql2.expect('mysql>')
mysql2.sendline('create database %s;' % '') # 数据库名
mysql2.sendcontrol('d')
print 'done ...'
except Exception, e:
print e