install python MySQLdb to python3 not python

Question

i have Ubuntu and installed python3 since my script is written in it. Since I use MYSQL with MySQLdb, I installed

apt-get install python-mysqldb

however this installed MySQLdb to Python (which is 2.6 on Ubuntu) and not to Python3.

1. How can I install MySQLdb for Python3
2. Should I use it at all or switch to PyMSQL

Sorry, I have just started working with Python today...

Solution 1

As far as I know, it's not ported to python3 yet.

Solution 2

1- You can use this command sudo apt-get install python3-mysqldb

It worked for me.

2- also you can install pip install PyMySQL.

Then add lines to __init__.py file

# __init__.py file

import pymysql
pymysql.install_as_MySQLdb()

Solution 3

MySQLdb is not yet Python3 compatible, but oursql, a Python-MySQL driver, is.

Solution 4

you can use this:

https://github.com/davispuh/MySQL-for-Python-3/wiki/Install-on-Linux

It worked for me.

Solution 5

How to install MySQLdb for Python2

sudo apt-get install python-mysqldb

How to install MySQLdb for Python3

sudo apt-get install python3-mysqldb

View more solutions

Comments

[Patrick Da Silva]

For me too! Thanks!

[Budi Mulyo]

it's works to install but can't used, not listed in modul after installed successfully