python3.7连接Mysql数据库

连接数据库

import pymysql.cursors
DBHOST = ‘localhost’
DBPORT = 3306
DBUSER = ‘root’
DBPASSWORD = ‘123456’
DBNAME = ‘semantic_analysis’
try:
db = pymysql.Connect(host=DBHOST,port=DBPORT,user=DBUSER,password=DBPASSWORD,database=DBNAME)
print(‘数据库连接成功！’)
except pymysql.Error as e:
print(‘数据库连接失败：’+ str(e))
注意事项：
1、post是端口变量定义时DBPORT用数字；
2、用try目的是检测异常。