# print all the first cell of all the rows It will letĬur.execute('SELECT * FROM YOUR_TABLE_NAME') Then it is just like using any other package : #!/usr/bin/pythonĭb = nnect(host='localhost', # your host, usually localhost This is not mandatory, But it will prevent me from answering 3 or 4 other questions in this post if something goes wrong. (You can use sudo apt-get install python-mysqldb (for debian based distros), yum install MySQL-python (for rpm-based), or dnf install python-mysql (for modern fedora distro) in command line to download.)įor Mac, you can install MySQLdb using Macport.Īfter installing, Reboot. Please note MySQLdb only supports Python 2.įor Windows user, you can get an exe of MySQLdb.įor Linux, this is a casual package (python-mysqldb). The most used package to do so is MySQLdb but it's hard to install it using easy_install. Unlike PHP, Only the SQLite driver is installed by default with Python. You must install a MySQL driver before doing anything.

Connecting to MYSQL with Python 2 in three steps

Navicat 2003