# -*- coding: utf-8 -*-
"""
Created on Tue Nov 15 14:36:14 2022

@author: Sim
"""

import mysql.connector as myc
host='210.115.233.278'; user='userID' 
password='password';  db='dbName'
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()