Windows 11 - Python mysql import error

Python Help
1

‘’’
This code was running with no issues and connecting to a remote mysql DB and not sure why it is failing now with this error. Appreciate any help as I am new to python.

The ERROR
Traceback (most recent call last):
File “C:/PROJECTS/Python/mySQL/mySQL_Forum.py”, line 2, in
from mysql.connector import Error
ImportError: cannot import name ‘Error’ from ‘mysql.connector’ (unknown location)

I have masked out my clients db credentials which are correct, the database server is running.

Pip file list
Package Version

certifi 2025.1.31
charset-normalizer 3.4.1
idna 3.10
mysql-connector-python 9.2.0
pip 25.0.1
requests 2.32.3
urllib3 2.3.0
xlrd 2.0.1



'''
import mysql.connector
from mysql.connector import Error

HOST = "*******************"
PORT = "****"   
USER = "*******"
PASSWD = "*******"
DATABASE = "******"


try:
    mydb = mysql.connector.connect(
        host= HOST,
        port=PORT,
        user=USER,
        passwd=PASSWD,
        database=DATABASE
    )

    if mydb.is_connected():
        print("Successfully connected to the database")
    else:
        print("Connection failed")

    cursor = mydb.cursor()
    cursor.execute("SELECT DATABASE();")
    record = cursor.fetchone()
    print("You're connected to database:", record[0])
    # My code should go here 

except Error as e:
    print(f"Error: {e}")

finally:
    if 'cursor' in locals():
        cursor.close()
    if 'mydb' in locals() and mydb.is_connected():
        mydb.close()
        print("MySQL connection is closed")
'''
2

I think it might need to be:

from mysql.connector.errors import Error

3

Blockquote
Thankyou Matthew for your timely reply. I did implement the change and got the following
Traceback (most recent call last):
File “C:\PROJECTS\Python\mySQL\mySQL_BK.py”, line 2, in
from mysql.connector.errors import Error
ModuleNotFoundError: No module named ‘mysql.connector.errors’

Blockquote
The strange thing being this code worked and now it doesn’t. I am sure that it’s something I have done when I uninstalled the pip mysql-python-connector and reinstalled it again. But not experienced enough to understand what effect this would have had. If I comment out the mysql.connector.errors import Error then I get this error:

Blockquote
Exception has occurred: AttributeError
module ‘mysql.connector’ has no attribute ‘connect’
File “C:\PROJECTS\Python\mySQL\mySQL_BK.py”, line 15, in
mydb = mysql.connector.connect(
^^^^^^^^^^^^^^^^^^^^^^^
AttributeError: module ‘mysql.connector’ has no attribute ‘connect’

I trapped the above error in debug mode in VS Code. Still scratching my head.

Cliff

4

I just installed mysql-connector-python-9.2.0 to try it out and the import in your original code worked for me.

Maybe it’s picking up the wrong file because of a name conflict.

Try:

import mysql
print(mysql.__file__)

at the top of your code.

Does it give the correct path to mysql, or to another file with that name?

5

As MRAB suggested you may be masking mysql.
Could be that it is your project name that is doing the masking.

Try changing c:/PROJECTS/Python/mySQL to c:/PROJECTS/Python/cliffsql

6

Blockquote

Hi Barry… I renamed the file but still getting the same failures. When I mask the 2nd line the failure jumps to line 5 mydb = mysql.connector.connect(…) and I get this error

Traceback (most recent call last):
File “C:\PROJECTS\Python\mySQL\cliffsql.py”, line 5, in
mydb = mysql.connector.connect(
AttributeError: module ‘mysql.connector’ has no attribute ‘connect’

Really appreciate the feedback and thank you for getting involved.

Blockquote

7

You will need to do this as @MRAB suggested to find out more information.

8

Blockquote
Hi Barry and Matthew. Thank you for the response. I did open a new file call cliffmsql and ran the following code:

import mysql
print(mysql.__file__)

Blockquote
With the following output

PS C:\PROJECTS\Python> & C:/Users/CliffordMcAuley/AppData/Local/Programs/Python/Python313/python.exe c:/PROJECTS/Python/mySQL/cliffsql.py
None

Checked to see if the the mysql-connector-python was installed by attempting to install it by


C:\Users\Cliff>pip install mysql-connector-python
Requirement already satisfied: mysql-connector-python in c:\users\cliffordmcauley\appdata\local\programs\python\python313\lib\site-packages (9.2.0)

Kindest Regards
Cliff

9

Try this:

import mysql
print(mysql)

What does it print?

10

I looked at the docs here https://dev.mysql.com/doc/connector-python/en/connector-python-example-connecting.html

All the examples show use as

import mysql.connnector
11

Blockquote

Matthew and Barry
I uninstalled the mysql-connector-python and reinstalled it then system restart and I can now connect once again to my remote mysql DB. Not sure why this worked, but it did. Thank you both again for your time and talents.

Sincerely
Cliff