OperationalError: (1130, “DESKTOP-FJKISOS‘ is not allowed to connect to this MySQL server“)

通过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()