# -*- coding: utf-8 -*-
"""
Created on Mon Jan 17 10:00:28 2022

@author: Sim
"""
import mysql.connector as myc

host='210.115.233.104'; user='mysqluser'; password='passme';  db='sakila'
#host='210.115.233.77'; user='root'; password='ChoSim99**';  db='mysql'
conn = myc.connect(user=user, password=password,
                              host=host,
                              database= db)
cursor = conn.cursor()
query1 = "SHOW TABLES"
cursor.execute(query1)
rows = cursor.fetchall()
print('Total Row(s):', cursor.rowcount)
for row in rows:
    print(row)

cursor.close()
conn.close()