i have problem while connecting python to mysql

Question

im trying to connect my python script to mysql, but any of the mysql python connectors does'nt work.

Here is part of my code:

import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="root",
  passwd="",
  database="mydatabase"
)

and here is error:

 Traceback (most recent call last):
   File "type.py", line 1, in <module>
     import mysql.connector
   File "/root/mysql.py", line 1, in <module>
     import mysql.connector
 ImportError: No module named connector

Install module using pip command based on your python version. — bkyada
– bkyada, Commented Jul 18, 2019 at 17:24
Try these possible answers: stackoverflow.com/a/24272278/8291579 stackoverflow.com/questions/12229580/… — Marcus Weinberger
– Marcus Weinberger, Commented Jul 18, 2019 at 17:26
Possible duplicate of Import mysql.connector Python. See the most upvoted answer rather than accepted one. — jpmc26
– jpmc26, Commented Jul 18, 2019 at 21:45

jdpy19 · Accepted Answer · 2019-07-18 17:35:11Z

0

You may not have Connector installed, I would recommend using pip list to see if it is or pip install mysql-connector-python.

This is a great resource: https://dev.mysql.com/doc/connector-python/en/connector-python-installation-binary.html

answered Jul 18, 2019 at 17:35

jdpy19

3831 silver badge13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

cursorrux · Accepted Answer · 2021-09-10 04:51:26Z

0

You can first check whether mysqlconnector is installed on your device or not.
For this the simplest way is

to write import mysql.connector on interactive mode and hit enter;
if it doesn't give you error then your good.
If it does,
- then go to tools > open system shells >
- type : pip install mysql.connector > press enter.
- This is install the connector and try it again after it is installed.

edited Sep 10, 2021 at 4:51

cursorrux

1,4645 gold badges11 silver badges20 bronze badges

answered Sep 9, 2021 at 14:14

Suprav Lal Karmacharya

1

Collectives™ on Stack Overflow

i have problem while connecting python to mysql

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related