Using MySQLdb with Python

To be able to connect python scripting  with MySqlDB install packages.
sudo apt-get install python-mysqldb
sudo apt-get install python-htmlgen 
sudo apt-get install phpmyadmin

use in python script 

import MySQLdb as mdb
import base64

SCRIPT = sys.argv[0].split("/")[-1:][0]
MYSQL_DATABASE_NAME='links'
MYSQL_USER='root'
MYSQL_PASSWORD=base64.b64decode('cm9vdDEyMw==')
MYSQL_PASSWORD='root123'
SQL_LIMIT = 500


database_name=MYSQL_DATABASE_NAME

con = mdb.connect('localhost',MYSQL_USER,MYSQL_PASSWORD,MYSQL_DATABASE_NAME)

cur = con.cursor()