It could be the case where you are running the Python file with the wrong Python installation. In VS Code we can choose the interpreter using which we want to run our Python file.
By default, the Python extension looks for and uses the first Python interpreter it finds in the system path. To select a specific environment, use the Python: Select Interpreter command from the Command Palette (Ctrl+Shift+P).
Just choose Python 3.8.9 from the list of interpreters. For complete guide you can refer to the documentation: https://code.visualstudio.com/docs/python/environments#_select-and-activate-an-environment
Answer from anirudh sharma on Stack OverflowI am starting with Python and did short script in VScode. When I try to run it I get this error:
PS C:\Users\spider> & C:/Python39/python.exe c:/Users/spider/drek.pyTraceback (most recent call last):File "c:\Users\spider\drek.py", line 5, in <module>import mysql.connectorModuleNotFoundError: No module named 'mysql'
I ran pip install mysql-connector and it installed it. If I run pip list I get this:
PS C:\Users\spider> pip list
Package Version---------------------- -------mysql-connector 2.2.9mysql-connector-python 8.0.24pip 21.0.1protobuf 3.15.8six 1.15.0wheel 0.36.2
PS C:\Users\spider>
Why I can't use MySql commands and how to fix it?
It could be the case where you are running the Python file with the wrong Python installation. In VS Code we can choose the interpreter using which we want to run our Python file.
By default, the Python extension looks for and uses the first Python interpreter it finds in the system path. To select a specific environment, use the Python: Select Interpreter command from the Command Palette (Ctrl+Shift+P).
Just choose Python 3.8.9 from the list of interpreters. For complete guide you can refer to the documentation: https://code.visualstudio.com/docs/python/environments#_select-and-activate-an-environment
You got two Python installed in your system. Python3 and Python2. Pip3 is just for python3. You must use pip2 or pip2.7 for work with python2. Search if you got the pip2 package installed is not then install it.
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 PATH.
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 -m pip).
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. read https://www.sqlshack.com/visual-studio-code-for-mysql-and-mariadb-development/
Hope any of this works. It took me a lot of googling and reading.
Check for the current Python Interpreter VSCode is using
Ctrl+P.Add your virtual environment PATH where your module is installed in
'C:\Users\<username>\.virtualenvs\<virtualenvname>\Scripts\python'.
You need to add your current working directory to the Python search path. This can be done with an environment variable:
export PYTHONPATH=.
There is a similar question here: Import "flask" could not be resolved from sourcePylancereportMissingModuleSource
How to solve this error... Help me someone
You might want to check out the following article:
Can not get mysql-connector-python to install in virtualenv (Stackoverflow)
The accepted answer states the following:
Several things. There is an inconsistency in package naming so you may want to do:
pip search mysql-connectorto find out what it is called on your platform. I got two results
mysql-connector-pythonandmysql-connector-repackaged.so try this first:
pip install mysql-connector-pythonthis may additionally give an error like this:
Some externally hosted files were ignored (use --allow-external mysql-connector-python to allow).so finally this should do the job:
pip install mysql-connector-python --allow-external mysql-connector-python
The following command solved the issue for me.
pip install mysql-connector-python-rf
This post expands a little on the differences between mysql-connector-python and the -rf suffixed variant.
I already did the whole pip install mysql-connector-python thing, but the error’s still haunting me. How am I supposed to sleep in peace. Need help