I am using ActiveState Python 3 on Windows and wanted to connect to my MySQL database.
I heard that
mysqldb was the module to use.
I can't find
mysqldb for Python 3.
Is there a repository available where the binaries exist for
How can I connect to MySQL in Python 3 on Windows?
There are currently a few options for using Python 3 with mysql:
MySQLdb, after calling
benchmarks here: https://github.com/methane/mysql-driver-benchmarks
You should probably use pymysql - Pure Python MySQL client instead.
It works with Python 3.x, and doesn't have any dependencies.
This pure Python MySQL client provides a DB-API to a MySQL database by talking directly to the server via the binary client/server protocol.
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()