Python and MySQL

software development

#1

Hi all,

I’m new to Python and wondered in anyone had installed MySQLdb (or any module to connect to MySQL Python) and could explain to me how ?

Thanks!


#2

Hi Yanik,

I recommend you to use MySQL connector Python because

  • it work with both Python 2 and 3

  • it is official Oracle driver for MySQL for working with Python.

  • It is purely written in Python

  • You can also use C extension to connect to MySQL.

  • MySQL Connector/Python is implementing the MySQL Client/Server protocol completely in Python. This means you don’t have to compile anything

  • Also, it has great support for connection pooling

Following resources will be very helpful for you

Install MySQL connector Python

Python MySQL Tutorial