Python script that connects to remote DB?

[KieuVanQuan]

My friend and I have a network in hamachi and my friend has a server with a database connected to it (SQL). And I would like to connect to his SQL DB from MY computer.  Here's an example:

 

Let's say I want to perform an 'inject into' command. Or just modify a table...or let's say I want to run a query in his DB remotely, from my PC. How do I connect to his db from my PC?

 

I know all his DB details, ip, domain name, db name, passwords, everything.

 

Thanks.

[LtStaffel]

I bet there's a module for this.

If not, then you could painfully use sockets.

[riklaunim]

There are database libraries for Python. Just pick the library based on what type of database you have (MySQL, Postgresql, other...)

[vorticalbox]

pymysql is what i use.

 

import pymysql.cursors

# Connect to the database
connection = pymysql.connect(host='localhost',
                             user='user',
                             password='passwd',
                             db='db',
                             charset='utf8mb4',
                             cursorclass=pymysql.cursors.DictCursor)

try:
    with connection.cursor() as cursor:
        # Create a new record
        sql = "INSERT INTO `users` (`email`, `password`) VALUES (%s, %s)"
        cursor.execute(sql, ('webmaster@python.org', 'very-secret'))

    # connection is not autocommit by default. So you must commit to save
    # your changes.
    connection.commit()
finally:
    connection.close()