I have downloaded mysql.connector and mysql but still there is the same issue
import mysql.connector mydb = mysql.connector.connect( host="localhost", user="root", passwd="Password" ) print(mydb)
ModuleNotFoundError: No module named ‘mysql’ – this is the error
Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.
There’s two potential solutions to this, but first a piece of advice: never run the command
pip directly. What you really want is
<path to python> -m pip, replacing
<path to python> with the path to the specific Python you want to install for. That way you guarantee that pip will install into the environment/interpreter you expect instead of just whatever
pip happens to be first on your
With that out of the way, option one is to make sure that the Python environment you have selected in the Python extension matches the one you have been installing into. Simply running
pip does not guarantee this, and so it’s quite possible you have been installing into one version of Python but connecting the Python extension to another. You can run
Python: Select interpreter in the command palette to choose the proper environment (or click on the Python interpreter details down in the status bar).
The second option — and in my opinion the better one — is to create a virtual environment and do the installation in there. So you could do
<path to python> -m venv .venv in the directory of your workspace and the Python extension will pick this up and ask if you want to use that virtual environment. When you open a new terminal it should activate that virtual environment, letting you run
python -m pip to install into that virtual environment (you can also do the activation manually or simply specify the path to the Python interpreter in the virtual environment directly when running
It took me more than two hours to solve this.
There can be multiple problems:-
You r saving that python file as mysql.py which causes this error.
solution : change the name. This one is exception.
explanation : https://discussion.dreamhost.com/t/helping-installing-a-python-mysql-connection/64222
Path of python is not added in SYSTEM VARIABLES as it may be present in users
but may not be updated there. So, check path of both python and Mysql.
It is very important step.
- You might be using idle saved on desktop as shortcut. So don’t and open from start.
- As many people suggested, use pip method to install connector and also check path again.
ApexSQL Database Power Tools ..Install this extension if you are using VScode.
Hope any of this works. It took me a lot of googling and reading.
pip install mysql-connector or pip3 install mysql-connector
and make sure your file is not named as “mysql.py”.
Go to command line and type the command
pip install mysql
this should work, because you don’t have mysql installed for python
Try installing like below in CMD or install through IDE.
pip install mysql-connector