MySQL报错：WARNING in log: (OperationalError('(pymysql.err.OperationalError) (1130, "x.x.x.x\' is not allowed to connect to this MySQL server")',),)

原因：不容许本地机器连远程mysql服务。

按以下步骤操作解决该问题：
1，登录mysql
> mysql -u root -p

2，切换到mysql库
mysql > use mysql;

3，执行以下命令
mysql > select 'host' from user where user='root';
mysql > update user set host = '%' where user ='root';
# 要刷新权限才能生效
mysql > flush privileges;

MySQL

我的笔记

MySQL如何导出指定字段的数据到文件中 MySQL

Mac系统忘记MySQL密码怎么办 MySQL

如何查看MySQL数据库及表编码格式 MySQL

MySQL关键字手册 MySQL

OperationalError('(pymysql.err.OperationalError) (2006, "MySQL server has gone away (BrokenPipeError(32, 'Broken pipe'))")') Python MySQL SQLAlchemy

Debian安装MySQL提示：Depends: libssl1.1 (>= 1.1.1) but it is not installable Debian MySQL

PyCharm连接数据库报错：1130-host ... is not allowed to connect to this MySql server MySQL

MAC下登录mysql8错误：ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) MySQL

(pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on 'localhost' ([Errno 61] Connection refused)") MySQL

Python3 连接数据库 MySQL8 时报错：(pymysql.err.DataError) (1366, "Incorrect string value: '\\x... Python MySQL

MySQL数据库系统关键字列表 MySQL

MySQL查询时使用 substring 方法截取字段长度 MySQL

部署的Python项目连接MySQL报错：WARNING in log: (OperationalError('(pymysql.err.OperationalError) (2006, "MySQL server has gone away (BrokenPipeError(32, \'Broken pipe\'))")',),) MySQL

MySQL创建数据，指定默认字符集，并制定排序规则 MySQL