ModuleNotFoundError No module named mysql

Question

Hi Guys,

I am trying to connect MySQL with python. But I am getting this below error.

import mysql.connector
ModuleNotFoundError                       Traceback (most recent call last)
<ipython-input-7-e4a81bca169b> in <module>
----> 1 import mysql.connector
ModuleNotFoundError: No module named 'mysql'

Answer 1

Hi@akhtar,

You need to install mysql-connector to connect Python with MySQL. You can use the below command to install this in your system.

 C:\Users\Nadeem Akhter>pip install mysql-connector-python-rf
Collecting mysql-connector-python-rf
  Downloading mysql-connector-python-rf-2.2.2.tar.gz (11.9 MB)
     |████████████████████████████████| 11.9 MB 111 kB/s
Building wheels for collected packages: mysql-connector-python-rf
  Building wheel for mysql-connector-python-rf (setup.py) ... done
  Created wheel for mysql-connector-python-rf: filename=mysql_connector_python_rf-2.2.2-cp36-cp36m-win_amd64.whl size=249460 sha256=b3b15baa6cbb68935e2c221725ca7133f2714623b26531f2e34f56b0e3d051ee
  Stored in directory: c:\users\nadeem akhter\appdata\local\pip\cache\wheels\51\40\3f\136443b7177ee453aa9d6c8862fc2d1a1ea8ff8ee0999d1971
Successfully built mysql-connector-python-rf
Installing collected packages: mysql-connector-python-rf
Successfully installed mysql-connector-python-rf-2.2.2

Get a further understanding from the Microsoft SQL course

Comments

Sir.
I have installed
pip install mysql-connector-python
pip install mysql-connector-python-rf
pip3 install mysql-connector-python
After installing all this I have worked for 3 hours for completing my project then suddenly it show no module found mysql
Please sir help me it's an emergency
I have also uninstalled and reinstalled it then also I'm getting same

---

Hi@priyanshu,
After installing the module, restart your command line or your IDE. So that the changes will update.

---

Actually I had the same issue when running the program in Pycharm, then i realize this really dumb thing, there is a setting include-system-site-packages in the pyvenv.cfg file which somehow was defaulting to false but once it is changed and set to true.  Everything worked.  Hope this helps for everyone.

include-system-site-packages = true
version = 3.8.6

---

Hello, @Markl,

Thanks for contributing to Edureka's community. Do register with Edureka's community and earn techie points to your account and share your knowledge with all the geeks here!!