方法一
#!/usr/bin/python
# -*- coding: UTF-8 -*-
import sys
import datetime
import mysql.connector
from mysql.connector import errorcode
reload(sys)
sys.setdefaultencoding('utf-8')
conf = {
'user': 'bestfei',
'password': 'password',
'host': '10.101.196.187',
'database': 'fei',
'raise_on_warnings': True,
}
try:
con = mysql.connector.connect(**conf)
except mysql.connector.Error as err:
if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
print("Something is wrong with your user name or password")
elif err.errno == errorcode.ER_BAD_DB_ERROR:
print("Database does not exist")
else:
print(err)
else:
print &#