Re: remote access to database

[bhanu kiran]

See, i am working on Python and MySQL.
In my code, if anyone enter all the values in a form and click the "submit" button, then it automatically insert into local database and automatically updated in the remote database .
Here, we use IP address for the remote access.

try:
import MySQLdb
import _mysql_exceptions as DB_EXC
cxn = MySQLdb.connect(host ='192.168.1.23')
cur = cxn.cursor()
cur = cxn.cursor()
no = cur.execute("select * from navicat.temp1") ## this is the database query you have to write.
cur.close()
cxn.commit()
cxn.close()
except ImportError , e:
return None

we write like this.