Connect to a remote mysql database using Python and MySQLdb

remote_db_connector.py

#!/usr/bin/env python
# -*- coding: utf-8 -*-

############################################################
#                                                          #
# Simple script to connect to a remote mysql database      #
#                                                          #
#                                                          #
# Install MySQLdb package by running:                      #
#                                                          #
#                       pip install MySQL-python           #
#                                                          #
############################################################


import MySQLdb as db

HOST = "remote host"
PORT = 3306
USER = "username of remote mysql instance"
PASSWORD = "password of remote mysql instance"
DB = "database name"

try:
    connection = db.Connection(host=HOST, port=PORT,
                               user=USER, passwd=PASSWORD, db=DB)

    dbhandler = connection.cursor()
    dbhandler.execute("SELECT * from your_table")
    result = dbhandler.fetchall()
    for item in result:
        print item

except Exception as e:
    print e

finally:
    connection.close()

I'm getting a error 2003 Cannot connect to the mysql server with ip xxx.xx.x.x (110) , I have made the bind address as 0.0.0.0, But still I'm not able to access the remote mysql server. when i'm trying to access with in a local host i'm able to do successfully, Thanks in advance

Thanks man, works perfectly

I am working with python 3 and I am not able to install mysqldb. Later I found MySQldb doesn't support Python 3.

Now I am using MySQL connector Python to connect MySQL.

I found following article helpful.

https://pynative.com/python-mysql-database-connection/

Thanks @ault2910, that link did the trick for me.