#-*- coding = utf-8 -*-
#@Time : 2021/4/7 14:45
#@Author : Zyh
#@File : testmysql.py
#@Software : PyCharm

import pymysql


conn = pymysql.connect(host='localhost',port=3306,user='zyh',passwd='mysql123',db='dota2bigdata',cursorclass=pymysql.cursors.DictCursor)

# connection = pymysql.connect(db='dota2bigdata')


cursor = conn.cursor()
sql = '''
      show databases;
    '''
cursor.execute(sql)
result = cursor.fetchall()
for item in result:
    print(item)

cursor.close()
conn.close()