mysqlx无法使用python连接数据库

2024-09-28 22:23:57 发布

您现在位置:Python中文网/ 问答频道 /正文

我已经安装了最新的mysql connector for Python来连接mysql Shell。当我试图使用Python getting below error连接MySQL Shell时

>>> import mysqlx
>>> mysqlx.get_session("mysqlx://root:<passsword>@localhost:3306/mySchema")
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/usr/lib64/python3.3/site-packages/mysqlx/__init__.py", line 193, in get_session
    return XSession(settings)
  File "/usr/lib64/python3.3/site-packages/mysqlx/connection.py", line 464, in __init__
    self._connection.connect()
  File "/usr/lib64/python3.3/site-packages/mysqlx/connection.py", line 328, in connect
    return super(XConnection, self).connect()
  File "/usr/lib64/python3.3/site-packages/mysqlx/connection.py", line 160, in connect
    self._handle_capabilities()
  File "/usr/lib64/python3.3/site-packages/mysqlx/connection.py", line 164, in _handle_capabilities
    data = self.protocol.get_capabilites().capabilities
  File "/usr/lib64/python3.3/site-packages/mysqlx/protocol.py", line 88, in get_capabilites
    return self._reader.read_message()
  File "/usr/lib64/python3.3/site-packages/mysqlx/protocol.py", line 56, in read_message
    return self._read_message()
  File "/usr/lib64/python3.3/site-packages/mysqlx/protocol.py", line 62, in _read_message
    raise ProgrammingError("The connected server does not have the "
mysqlx.errors.ProgrammingError: The connected server does not have the MySQL X protocol plugin enabled
>>>

确保启用了X插件,因为我可以使用mysqlsh读取、写入和删除集合。不知道为什么会出现这个错误,任何帮助建议都会对我有帮助。在


Tags: inpyselfgetreturnpackagesusrconnect