mysql.PyCharm中的connector在使用kwargs运行connect()时会产生分

Question

我正在尝试使用Python设置mysql客户端。我的mysql服务器现在在我的ubuntu系统中。

问题是，如果我用PyCharm运行模块，它会产生分段错误(见下面的错误)。然而，我用PyCharm调试器、PyCharm控制台、Python控制台和linux bash运行它，它工作正常。我不知道问题出在哪里了。

程序是:

import faulthandler; faulthandler.enable()
import mysql.connector
dbparams = dict(host='localhost', user='user', password='password')
connection_empty = mysql.connector.connect()
print(connection_empty)
connection = mysql.connector.connect(**dbparams)
print(connection)
show_db_query = 'SHOW DATABASES'
cursor = connection.cursor()
cursor.execute(show_db_query)
for element in cursor:
print(element)

我用以下命令运行程序:

/usr/bin/python3.6 /path/to/program/example.py PYTHONFAULTHANDLER=1

回溯如下:

<mysql.connector.connection.MySQLConnection object at 0x7f06c1527e48>
Fatal Python error: Segmentation fault
Current thread 0x00007f06c16a0740 (most recent call first):
File "/usr/lib/python3.6/ssl.py", line 391 in __new__
File "/usr/lib/python3.6/ssl.py", line 502 in create_default_context
File "$HOME/.local/lib/python3.6/site-packages/mysql/connector/network.py", line 448 in switch_to_ssl
File "$HOME/.local/lib/python3.6/site-packages/mysql/connector/connection.py", line 209 in _do_auth
File "$HOME/.local/lib/python3.6/site-packages/mysql/connector/connection.py", line 355 in _open_connection
File "$HOME/.local/lib/python3.6/site-packages/mysql/connector/abstracts.py", line 1003 in connect
File "$HOME/.local/lib/python3.6/site-packages/mysql/connector/connection.py", line 108 in __init__
File "$HOME/.local/lib/python3.6/site-packages/mysql/connector/__init__.py", line 278 in connect
File "$HOME/path/to/program/example.py", line 8 in <module>
Process finished with exit code 139 (interrupted by signal 11: SIGSEGV)

系统是ubuntu 18.04

PyCharm的版本是2019.1.1

mysql Ver 14.14 Distrib 5.7.33

mysql-connection-python 8.0.23

任何想法都将受到赞赏，谢谢!

Answer 1

所以，我按照nbk的建议更新了我的python版本(我做了python3.7，因为我已经安装了它)。

现在证明是有效的。遗憾的是，我不知道问题出在哪里。