Python 3.4 MySQL Connector Not Found Only When Running a Script File

Question

I'm having a problem running my script file.

This is on Windows 7.

I've downloaded and installed Python 3.4

Downloaded and installed the connector https://dev.mysql.com/downloads/connector/python/

When I run python in my command prompt line by line the script works fine with no problems and returns the data from my database.

python C:\Users\myUser\Documents\python\mysql.py

I get

ImportError: No module named 'mysql.connector'; 'mysql' is not a package

So for some reason it isn't able to find the module when I run the script from the file. It's the first line in it BTW.

import mysql.connector

But it works fine if I just execute Python in my command prompt and then run the line.

answer here may be helpful stackoverflow.com/questions/12229580/… . try using from mysql import connector . Link provides a good explanation of submodule imports — Busturdust
– Busturdust, Commented Jan 19, 2016 at 18:52
I ran import sys print(sys.path) from a file in the same folder to see what Python sees as the folder to look for the library, and it includes the correct folder as the last element of the list. The folder includes the "mysql" folder and another internal "connector" folder and all the init files are there too. — Chicago Excel User
– Chicago Excel User, Commented Jan 19, 2016 at 20:45
OK, I'm still conflicted what's going on here. I've tried with pymysql library and no problems whatsoever. — Chicago Excel User
– Chicago Excel User, Commented Jan 19, 2016 at 21:05

user2561395 · Accepted Answer · 2019-05-24 23:50:56Z

1

Change the name from mysql.py to mysqlxx.py. It's looking in your file instead of the module.

answered May 24, 2019 at 23:50

user2561395

111 bronze badge

Sign up to request clarification or add additional context in comments.

Comments

Busturdust · Accepted Answer · 2016-01-19 21:31:53Z

0

I am assuming python C:\Users\myUser\Documents\python\mysql.py is a custom script, and is not the mysql connector

Unforunately for you, the name of your script shadows the exact name of the mysql module

I believe this may be causing a clash of modules, and that if you renamed your script to something more agnostic like mysql_test.py which doesnt clash with the installed module, you would be okay

answered Jan 19, 2016 at 21:31

Busturdust

2,5151 gold badge28 silver badges44 bronze badges

Collectives™ on Stack Overflow

Python 3.4 MySQL Connector Not Found Only When Running a Script File

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related