py mysqlクライアント

import mysql.connector

#        
conn = mysql.connector.connect(
    user='root',
    password='123456789',
    host='host.example.com',
    database='test')

#   cursor()        
cur = conn.cursor()
cur.execute("select * from student")

for (id,name) in cur:
    print(id,name)

cur.close()
#        
conn.close()
"""
1  
2  
3  

"""