ImportError: No module named 'mysql' in Python Django

Dung Do Tien Nov 16 2021 132

Hello Guys, I'm just studying Python Django one week before. I used the MySQL database for my project.

I have created some line code to help connect to the database, it's like that

import mysql.connector as sql
con = sql.connect(host="127.0.0.1", user="sa", passwd="my_pass", database="Students")

if con.is_connected() == false
   print("Cant not connect to My SQL")

-- TODO get data here.
   
con.close()

But when running this code I got an exception ImportError: No module named 'mysql'.

Traceback (most recent call last):
  File "<pyshell#8>", line 1, in <module>
    import mysql.connector
ImportError: No module named 'mysql'

Do you have any suggestions for me? I'm using MySQL 8.0

Thanks so much.

Have 2 answer(s) found.
  • D

    Devx Mon Nov 16 2021

    You need to install mysql-connector package first. You can install as below:

    Python 3:

    pip3 install mysql-connector

    Python 2:

    pip install mysql-connector

    And it's worked for you.

  • P

    Palakorn Sangketchon Nov 16 2021

    I got the same problem and I solved it by running two commands below:

    pip3 install mysql-connector
pip3 install mysql-connector-python-rf

    I hope it's helpful for you.

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. ImportError: No module named MySQLdb in Python Django
  14. MongoDB throw certificate verify failed: certificate has expired in Python
  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