How can I connect to MySQL in Python 3 on Windows?

Question

I am currently working with ActiveState Python 3 on Windows os and I want to connect to my MySQL database. I discovered that mysqldb was the module to use. I can't find mysqldb for Python 3.

Kindly let me know how to connect to MySQL in Python 3?

Answer 1

For connecting mysql in Python, you can use pymysql as it is a complete Python MySQL client.

It works with Python 3.x and doesn't have any dependencies.

import pymysql

conn = pymysql.connect(host='127.0.0.1', unix_socket='/tmp/mysql.sock', user='root', passwd=None, db='mysql')

cur = conn.cursor()

cur.execute("SELECT Host,User FROM user")

for r in cur:

    print(r)

cur.close()

conn.close()