flask 写入mysql数据库

使用了mysql 远程连接 

暂时写死查询条件 

from flask import make_response,render_template
from flaskext.mysql import MySQL
 
app = Flask(__name__)

app.config['MYSQL_DATABASE_USER'] = 'root'
app.config['MYSQL_DATABASE_PASSWORD'] = '密码'
app.config['MYSQL_DATABASE_DB'] = '数据库名'
app.config['MYSQL_DATABASE_HOST'] = 'ip地址'

mysql = MySQL()
mysql.init_app(app)

@app.route('/')
def index():
    return '<h1>Hello World!</h1>'

@app.route('/mysql')
def mesql():
    cursor = mysql.get_db().cursor()
    cursor.execute("select name from csa where age=20")
    username = cursor.fetchall()
    return render_template('mysql_user.html', username = username)

if __name__ == "__main__":
    hostname = socket.gethostname()
    ip='0.0.0.0'
    app.run( host=ip,port=5000,debug=False )

但是最终结果 

正确结果应该是 Hello,cs1!here is mysql!