import pymysql
host=
user=
passwd=
db=
charset=
port=
db = pymysql.connect(host=host, user=user, passwd=passwd, db=db, charset=charset ,port=port)
cursor = db.cursor()
所有库名
cursor.execute(‘SHOW DATABASES’)
print(cursor.fetchall())
所有表名
cursor.execute(‘SHOW TABLES’)
print(cursor.fetchall())