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

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

8. establish MySQL and app connections

    from  flask import   flask,render_template  from  flask_sqlalchemy import   SQLAlchemy  import   Configapp  = Flask (__name__ ) #   Initializes a flask object that needs to pass a parameter __name__  app.config.from_object ( Config) db  =sqlalchemy (APP) Db.create_all ()  

    

10. Create a user model

    #/Create the User model class "user" (db). Model):    __tablename__ = ' user '    id=db. Column (db. integer,primare_key=taberror,autoincrement=True)    username=db. Column (db. String (a), nullable=False)    password=db. Colum (db. String (), nullable=False)    

Connect to MySQL database and create user model