I am trying to connect python and mysql and I am facing the following error:

Question

Source code:

import mysql.connector

from mysql.connector import errorcode
try:
    cnx = mysql.connector.connect(user='root',database='menagerie')
except mysql.connector.Error as err:
    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
        print("Something is wrong with your user name or password")
    elif err.errno == errorcode.ER_BAD_DB_ERROR:
        print("Database does not exist")
    else:
        print(err)
else:
    cnx.close()

The error I am facing: 2003: Can't connect to MySQL server on '127.0.0.1:3306' (10061 No connection could be made because the target machine actively refused it)

Please refer to below link and see if it helps https://stackoverflow.com/questions/12993276/errno-10061-no-connection-could-be-made-because-the-target-machine-actively-re — Anupam Chaplot, Mar 04 '20 at 06:21

score 0 · Answer 1 · answered Mar 04 '20 at 06:34

0

import mysql.connector
cnx=mysql.connector.connect(user="root",host="localhost",passwd="*******",database="menagerie")

The above code establishes the connection to MySql.

answered Mar 04 '20 at 06:34

saurabh sisodia

312
1
8

here host is an optional parameter but passwd is necessary to make connection. – saurabh sisodia Mar 04 '20 at 06:36
mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on 'localhost:3306' (10061 No connection could be made because the target machine actively refused it) – Moin Mar 04 '20 at 07:07
^ what do I do? – Moin Mar 04 '20 at 07:08
when I don't include passwd parameter then your code print "Something is wrong with your user name or password" but if I included passwd then it works fine. – saurabh sisodia Mar 04 '20 at 14:02
If you have the same problem then try to install mysql client again. – saurabh sisodia Mar 04 '20 at 14:05

I am trying to connect python and mysql and I am facing the following error:

1 Answers1