Pycharm连接Mysql
import MySQLdb
conn = MySQLdb.Connect(host="localhost", port=3306, user="root", password="***", database="数据库名字", charset="utf8")
cursor = conn.cursor() #游标
cursor.execute("select * from Movie;") #执行sql语句
data = cursor.fetchall()
print(data)