Python and MySQL

If an external application, e.g. written in Python, needs to access MySQL server, take a look at MySQL Option Setting  bind-address . You can also see some practical advise in Ubuntu online help about MySQL. For MySQL Options File format see MySQL Reference Manual.

Ubuntu Machine Steps:

1. Edit sudo vi /etc/mysql/my.cnf and modify the line with bind-address = 192.168.xxx.xxx [your server address to accept external calls], e.g. add at the end of the file the next lines:
   [mysqld]
   bind-address = 192.168.xxx.xxx
2. Restart MySQL daemon:
   sudo service mysql restart

Python Remote Machine Steps:

1. Proceed as in the tutorialspoint “Python MySQL Database Access” article, e.g.:

   import MySQLdb
   
   print "Hello World!"
   
   # Open database connection
   db = MySQLdb.connect("192.168.xxx.xxx", "testuser", "test123", "testdb" )
   
   # prepare a cursor object using cursor() method
   cursor = db.cursor()
   
   # execute SQL query using execute() method.
   cursor.execute("SELECT VERSION()")
   
   # Fetch a single row using fetchone() method.
   data = cursor.fetchone()
   
   print "Database version : %s " % data
   
   # disconnect from server
   db.close()

   Output Sample:

   Hello World!
   Database version : 5.7.15-0ubuntu0.16.04.1

   Possible output in case there is no server running:

   Hello World!
   Traceback (most recent call last):
   …
   _mysql_exceptions.OperationalError: (2003, “Can’t connect to MySQL server on ‘192.168.xxx.xxx’ (10060)”)

DIG

---

Additional Tutorials Links

MySQL Python tutorial

---