python:mysql_config not found when connecting to Mysql DB

Question

Im trying to connect mysql through python and have the following packages installed.

apt-get install python-pip

pip install flask

apt-get install python-mysqldb

pip install flask-restful

After searching few of the posts, tried installing the below too: (which doesnt seem to work or is not installing)

apt install libmysqlclient-devel

easy_install mysql-python

pip install MySQL-python

My python version : Python 2.7.12

In my script im using:

import MySQLdb 

And in my command if i try:

python nameserver.py

I get the error as:

import MySQLdb ImportError: No module named MySQLdb 

Answer 1

You can solve to use this:

first, install build-essential with this:

apt install build-essential

and then, install libmysqlclient-dev with this:

apt install libmysqlclient-dev

then try install mysqlclient with pip like this:

pip install mysqlclient

Answer 2

I recommend you to use PyMysql . I found it quite easy to use .

Here is an example :

 import pymysql conn = pymysql.connect(host='localhost', port=3306, user='<username>', passwd='<password>', db='mysql') cur = conn.cursor() cur.execute("SELECT <Column> FROM <Table>") 

Here you can find out more about pyMysql : https://github.com/PyMySQL/PyMySQL