I'm trying to import pymysql to my python script in VSCode but am getting the following error
Import "pymysql" could not be resolved from sourcePylancereportMissingModuleSource
I installed the module with pip the same way I have with all other modules such as Pandas, which works fine
Here's the import line for reference
import pymysql
Any quick fixes or explanations of what is going on would be appreciated, thanks
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
Run pip show pymysql to check if module is installed in \current selected interpreter\lib\site-packages:
If not, please reinstall it to current used environment. If it is, open Command Palette(Ctrl+Shift+P) and choose Reload Window, the warning should go away.
Maybe it's late, but in my case issue was solved by redoing virtual environment in my project with flask and pymysql. My .env was previously created working with flask.
In VS: View -> Command Palette -> Python environment -> .venv -> Delete and Recreate
After recreate:
python -m pip install flask
python -m pip install pymysql
In case this could help somebody.
It's pretty simple:
To solve the error, install the module by running the pip install pymysql command.
