import pymysql

hostname = '104.196.69.254'
username = 'aquaponics'
password = 'duck'
database = 'Controller_1'

connection = pymysql.connect(host=hostname, user=username, db=database, charset='utf8', cursorclass=pymysql.cursors.DictCursor)

try:
	with connection.cursor() as cursor:
		sql = "INSERT INTO 'test' ('name', 'age') VALUES (%s, %s)"
		cursor.execute(sql, ('coleman', 17))
		connection.commit()
finally:
	connection.close()