通过pymysql 连接本地数据库报错
打开MySQL
mysql -u root -p
查看localhost权限
use mysql;
select host,user from user;
授予root@localhost权限
update user set host = '%' where user ='root';
flush privileges;
通过pymysql 建立连接
import pymysql
conn = pymysql.connect(host="IP地址", user="root", password="123456", db="xxx", charset="utf8")
# c创建游标
cursor = conn.cursor()