Extracting ip address from mysql query list using python

Question

I would like to extract an ip address from mysql using python.

here is my code,

cnx = mysql.connector.connect(host=mysql_localhost, user=user, password=password, database=database)
cursor = cnx.cursor()
cursor.execute("select inet_ntoa(server) as ip from settings" )
#print 'Data inserted into Database'
results = cursor.fetchone()
print(results)
cursor.close()
cnx.close()

and my result is

('192.168.0.15',)

how can i save the result above to an ip address?

Answer 1

After doing

results = cursor.fetchone()

results has the value ('192.168.0.15',). That is a tuple consisting of one element, a string.

You get it with results[0].

If you want to connect to that host, simply do

mysql_target_host = results[0]

and then

cnx = mysql.connector.connect(host=mysql_target_host, user=user, password=password, database=database)

as I strictly vote against mysql_localhost because that could lead to confusion.

Answer 2

That is a human readable interpretation of an IP address?

You could use IPy to parse it further.

Im not sure what else you are after