mysql Debian based - Python 3.11 Configuration Setup w/ Pycharm

mysql Debian based - Python 3.11 Configuration Setup w/Pycharm

mysql Debian based - Python 3.11 Configuration Setup w/ Pycharm
Photo by Kenny Eliason / Unsplash

Getting a mysql connector to work in a Debian based environment is actually messy. Really messy.  So messy in fact - it required it's own guide after reading dozens of tidbit guides throughout the Internet.  Once one can finally figure it out  - you only do yourself justice to document it to yourself.

Python 3.9 will not cleanly install witih mysql-connector. Just don't use it.

To make work:

  1. Set Pycharm to recognize Python 3.11:

2. Build yourself some template code to test the mysql connector as in:

import mysql.connector
cnx = mysql.connector.connect(user='root', password='password', host='', database='', auth_plugin='mysql_native_password')

3. Alter the permissions in your mysql so that it can work with mysql_native_password:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '{NewPassword}';

If you need a mysql create user guide it is here:

4. Clean out mysql-connector / mysql-connector-python and reinstall:

  • You pretty much have to add option '--break-system-packages' to everything you install and uninstall as it is pushing to virtual environments:
sudo pip3 uninstall mysql-connector --break-system-packages
sudo pip3 uninstall mysql-connector-python --break-system-packages
sudo pip3 install mysql-connector-python --break-system-packages

Now step-debug your code to confirm that you have a working connector:

In the debug section you will see your proof:

Linux Rocks Every Day