db for python

gistfile1.txt

import MySQLdb
db_server = '127.0.0.1:8080'
db_user = 'root'
db_password = '1234'
db_name = 'testdb'
db_charset = 'utf8'

db = MySQLdb.db.connect(db_server, db_user, db_password, db_name, charset = db_charset)
print('Connected')

cursor = db.cursor()
cursor.execute('SELECT * from student')
result = list(cursor.fetchall())
print(result)