Connect to MySQL database and create user model

2. Installing and configuring the Python3.6+flask+mysql database
   1. Download and install MySQL database
   2. Download and install Mysql-python middleware
   3. Pip Install Flask-sqlalchemy (Python's ORM Framework SQLAlchemy)
4. MySQL CREATE database
6. Database configuration Information config.py
8. Build MySQL and App connections
9. Create a user model

    fromFlaskImportFlask fromFlask_sqlalchemyImportSQLAlchemyImportConfigapp= Flask (__name__) App.config.from_object (config) DB=SQLAlchemy (APP)classUser (db. Model):__tablename__='User'ID= db. Column (db. Integer,primary_key=true,autoincrement=True) Username= db. Column (db. String (nullable=),False) Password= db. Column (db. String (nullable=),False) Db.create_all () @app. Route ('/')defHello_world ():return 'Hello world!'if __name__=='__main__': App.run ()

   sqlalchemy_database_uri='mysql+pymysql://root: @localhost: 3306/mis15?charset=utf8'  = False

Connect to MySQL database and create user model