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

   Sqlalchemy_database_uri='mysql+pymysql://root:[email Protected]:3306/mis14?charset=utf8  '= False

    fromFlask Import Flask fromflask_sqlalchemy Import Sqlalchemyimport Configapp=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 ('/') def hello_world ():return 'Hello world!'if__name__== '__main__': App.run ()

Connect to MySQL database and create user model