mysql 用户名屏蔽词过滤

-- coding: utf8 --

生成sql语句

import MySQLdb

import pymysql
import sys
import random
import string

defaultencoding = 'utf-8'
if sys.getdefaultencoding() != defaultencoding:
reload(sys)
sys.setdefaultencoding(defaultencoding)

def getdb(db_name):

server_info = open(path + "/SqlServerInfo.txt", "r")

connectInfo = []

for line in server_info:

h = line.strip().decode('gbk').encode('utf-8')

connectInfo.append(h)

password_info = open("E:/DB_backup/passwd.txt", "r")
passwd = []
for line in password_info:
    v = line.strip().decode('gbk').encode('utf-8')
    passwd.append(v)

# 连接

host = connectInfo[0].split("=")[1]