pymysql.err.InternalError: (1130, "Host '192.168.198.1' is not allowed to connect to this MySQL serv

最新推荐文章于 2023-02-13 15:12:38 发布

竹杖芒鞋轻胜马，谁怕？一蓑烟雨任平生。

最新推荐文章于 2023-02-13 15:12:38 发布

阅读量3.9k

点赞数 1

分类专栏：解决问题

本文链接：https://blog.csdn.net/qq_21127151/article/details/94804041

版权

解决问题专栏收录该内容

58 篇文章 2 订阅

订阅专栏

 ~/workspace/python/bbs  python manage.py db migrate                                                                                                                                           1 ↵
Traceback (most recent call last):
  File "/Users/yuanting/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2262, in _wrap_pool_connect
    return fn()
  File "/Users/yuanting/venv/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 303, in unique_connection
    return _ConnectionFairy._checkout(self)
  File "/Users/yuanting/venv/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 760, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File "/Users/yuanting/venv/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 492, in checkout
    rec = pool._do_get()
  File "/Users/yuanting/venv/lib/python3.7/site-packages/sqlalchemy/pool/impl.py", line 238, in _do_get
    return self._create_connection()
  File "/Users/yuanting/venv/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 308, in _create_connection
    return _ConnectionRecord(self)
  File "/Users/yuanting/venv/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 437, in __init__
    self.__connect(first_connect_check=True)
  File "/Users/yuanting/venv/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 639, in __connect
    connection = pool._invoke_creator(self)
  File "/Users/yuanting/venv/lib/python3.7/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
    return dialect.connect(*cargs, **cparams)
  File "/Users/yuanting/venv/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 451, in connect
    return self.dbapi.connect(*cargs, **cparams)
  File "/Users/yuanting/venv/lib/python3.7/site-packages/pymysql/__init__.py", line 94, in Connect
    return Connection(*args, **kwargs)
  File "/Users/yuanting/venv/lib/python3.7/site-packages/pymysql/connections.py", line 325, in __init__
    self.connect()
  File "/Users/yuanting/venv/lib/python3.7/site-packages/pymysql/connections.py", line 598, in connect
    self._get_server_information()
  File "/Users/yuanting/venv/lib/python3.7/site-packages/pymysql/connections.py", line 975, in _get_server_information
    packet = self._read_packet()
  File "/Users/yuanting/venv/lib/python3.7/site-packages/pymysql/connections.py", line 684, in _read_packet
    packet.check_error()
  File "/Users/yuanting/venv/lib/python3.7/site-packages/pymysql/protocol.py", line 220, in check_error
    err.raise_mysql_exception(self._data)
  File "/Users/yuanting/venv/lib/python3.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.InternalError: (1130, "Host '192.168.198.1' is not allowed to connect to this MySQL server")

解决方案：
方案1.修改mysql密码策略，比如将密码长度设的短一点
设定密码长度：set global validate_password_length=6
方案2.修改数据库密码符合数据库要求
参考连接：
https://blog.csdn.net/Hello_World_QWP/article/details/79551789