pymysql incompatibility in pycharm
Answered
Hi, I am using pycharm 2019.1 for my data processing. We need to use pymysql for database management as well. Over the the last week, I gradually noticed that pycharm is actually incompatible with pymysql, as the same database is accessed with matlab and other software like mysql-workbench and navicat easily without issues. In addition, I could simply manipulate the database with python when it's running in the command window directly. But in pycharm, once I connected to the database, the error below appeared:
Mysql server has gone away. Reconnecting to the server.
Also, in the server log file, it shows:
Aborted connection 41 to db: 'unconnected' user: '*' host: '127.0.0.1' (Got an error reading communication packets)
Could anyone take a look at this issue? Thanks.
Below is my computer config:
OS: Windows 10
Python: 3.7.3
Pycharm: 2019.1
pymysql: 0.9.3
mysql server: 5.7.26
Please sign in to leave a comment.
Hi,
PyMySQL isn't supported at the moment. Please vote for the corresponding feature request https://youtrack.jetbrains.com/issue/PY-10494
good to know it's confirmed that pymysql is not supported. already vote for the support! Do you know where I can find the full list of compatible packages in pycharm?
There is no such list. You can use almost any package. Some of them require additional support from our side though (like we do with Django, for example) to work with them in a more friendly way.
Awesome! Thank you so much for your hard-working. I believe pycharm is really the IDE that could make python community much more mature:-) Looking forward to the pymysql support.