ImportError: No module named MySQLdb in Python Django

Dung Do Tien Nov 20 2021 111

Hello, I am a newbie in Python I was beginning to learn Python two months ago. I have created a simple web application with Python.

I am using Python version 3.9.7 and installing MySQL version 8.0 and Django

I create a file function help connect to MySQL as below:

ImportError: No module named MySQLdb

But when I ran the code above I got an exception throw : ImportError: No module named MySQLdb.

ImportError: No module named MySQLdb

Any suggestions for me?

Have 3 answer(s) found.
  • d

    dang nhat hai long Nov 20 2021

    I saw you import MySQLdb in your code to help connect to the MySQL database.

    You have to install two packages are mysql-connector-python and mysql-python. To install them you can run the command below:

    pip install mysql-connector-python
pip install mysql-python

    I hope it solve for you.

  • W

    Watcharapong Jakkawannorasing Nov 20 2021

    You need to install libmysqlclient-dev package first, by using command : sudo apt install libmysqlclient-dev and THEN

    For python 2.x run command:

    pip install mysql-python

    For python 3.x run command:

    pip install mysqlclient

    This solution worked for me.

  • R

    Raja T Nov 20 2021

    We have 3 packages that need to install to help connect to MYSQL:

    1. Install the mysqlclient package:

    pip install mysqlclient

    2. Install the mysql-connector-python packaged:

    pip install mysql-connector-python

    3. Install the pymysql package:

    pip install pymysql

    After all is done, you can re-try run your code.

Related Q&A May You Like

  1. ValueError: cannot reindex from a duplicate axis in Python
  2. ValueError: Cannot convert non-finite values (NA or inf) to integer in Python
  3. ModuleNotFoundError: No module named 'pandas' in Python
  4. How to print WITHOUT New line in Python using print method?
  5. How to print a new line in Python 3 with a long string?
  6. Short command to check python version in Linux or Window?
  7. SyntaxError: invalid character in identifier in Python
  8. ImportError: No module named 'ConfigParser' in Python
  9. ModuleNotFoundError: No module named 'numpy' in Python 3.x
  10. ImportError: No module named matplotlib.pyplot in Python
  11. Error divide by zero encountered in double_scalars in Python
  12. PermissionError: [Errno 13] Permission denied in Python
  13. MongoDB throw certificate verify failed: certificate has expired in Python
  14. ImportError: No module named 'mysql' in Python Django
  15. MySQL error authentication plugin 'caching_sha2_password' is not supported in Python
Leave An Answer
* NOTE: You need Login before leave an answer

* Type maximum 2000 characters.

* All comments have to wait approved before display.

* Please polite comment and respect questions and answers of others.

Most Quizs Popular

Start Test

Javascript - Functions
Start Test

Asp.Net Core - Exam test 01
Start Test

Asp.Net Core - Exam test 02
Start Test

C# - Level Beginner

Popular Tips

This site uses cookies so that we can remember you and understand how you interact with our website. This allows us to improve and customize your browsing experience. See our Cookies Policy.
X Close