How do I connect to a MySQL Database in Python?

Question

I want to connect to the MySQL database in python, how to do it? Kindly guide me!

Answer 1

There is one package named mysql connector which works for pure Python, and it is system independent, and dead simple to install. You just download, double-click, confirm the license agreement, and go. There is no requirement for Xcode, MacPorts, compiling, restarting …

Then you connect like:

import mysql.connector    

cnx = mysql.connector.connect(user='scott', password='tiger',

                              host='127.0.0.1',

                              database='employees')

try:

   cursor = cnx.cursor()

   cursor.execute("""

      select 3 from your_table

   """)

   result = cursor.fetchall()

   print result

finally:

    cnx.close()