can not add user successfully (got an issue with mysql)

[fuckbfa]

Ubuntu 19.04,
Python 2.7.16, Python 3.7.3,
pip 19.1.1 from /usr/local/lib/python2.7/dist-packages/pip (python 2.7)
pip 18.1 from /usr/lib/python3/dist-packages/pip (python 3.7)
mysql Ver 14.14 Distrib 5.7.26, for Linux (x86_64) using EditLine wrapper

all the requirements have been successfully installed

---

the script use python3, but MySQLdb is not supported by python3

python3 trojan_manager.py int
Traceback (most recent call last):
  File "trojan_manager.py", line 19, in <module>
    import MySQLdb
ModuleNotFoundError: No module named 'MySQLdb'

try to use pymysql instead:

import pymysql
pymysql.install_as_MySQLdb() 

then successfully get in

but when I've added a user, quit, and query again, there's nothing in the database

journalctl -u mysql
Aborted connection to db: 'trojan' user: 'trojan' host: 'localhost' (Got an error reading communication packets)

sorry for the poor english

[malikshi]

same here nothing else in database. and how to setting client with user and password?

[k4yt3x]

Did you install the dependencies from requirements.txt?
Specifically mysqlclient