在python中如何查看mysql数据库

pip install pymysql

pip install mysql-connector-python

import pymysql

import mysql.connector

conn = pymysql.connect(host='数据库主机地址', user='用户名', password='密码', database='数据库名', port=3306)

conn = mysql.connector.connect(host='数据库主机地址', user='用户名', password='密码', database='数据库名', port=3306)

cursor = conn.cursor()

sql = "SELECT * FROM 表名"

cursor.execute(sql)

result = cursor.fetchall()

for row in result:
    print(row)

cursor.close()
conn.close()