How do I connect to a MySQL Database in Python?

[spark-user · Accepted solution]

Hi Kaniz,

One way you could do this is to use the connector API and call its constructor as follows

import mysql.connector
 
sqlConnect = mysql.connector.connect(user='userName', password='password', host='127.0.0.1', database='databaseName')
 

You would also want to close the connection after you are done using it

sqlConnet.close()

[_raman_]

I have tried to connect the mysql database using above code but failed to connect.

getting this as error : DatabaseError: 2003 (HY000): Can't connect to MySQL server on 'localhost:3306' (111)

and after using host as 127.0.0.1 getting this as error : 

DatabaseError: 2003 (HY000): Can't connect to MySQL server on '127.0.0.1:3306' (111)