# -*- coding: utf-8 -*-
"""
Created on Wed May  1 08:44:22 2019

@author: Sim
"""

import mysql.connector as myc

conn = myc.connect(user='user_ID', password='ur_password',
#                              host='127.0.0.1',
                              host='111.112.113.256',
                              database='sakila')
cursor = conn.cursor()
query1 = "SHOW TABLES"
cursor.execute(query1)
arow = cursor.fetchone()
for arow in cursor:
    print(arow)

cursor.close()
conn.close()