flask如何连接mysql数据库_使用Flask，SQLAlchemy连接到MySQL数据库

我想用Flask连接到MySQL数据库。以下是我的代码：app.config['MYSQL_HOST'] = 'localhost'

app.config['MYSQL_USER'] = 'admin'

app.config['MYSQL_PASSWORD'] = '********'

app.config['MYSQL_DB'] = 'abc'

app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False

app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql+pymysql://admin:********@localhost/abc'

api = Api(app)

db = SQLAlchemy(app)

ma = Marshmallow(app)

db.create_all()

class Video(db.Model):

id = db.Column(db.Integer, primary_key=True)

videoid = db.Column(db.String(80), unique=True)

video_timestamp = db.Column(db.Integer, unique=True)

def __init__(self, videoid, video_timestamp):

self.videoid = videoid

self.video_timestamp = video_timestamp

我遇到了这个错误：sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146,

"Table 'abc.video' doesn't exist") [SQL: 'SELECT video.id AS

video_id, video.videoid AS video_videoid, video.video_timestamp AS

video_video_timestamp \nFROM video']

我知道如何连接到SQLite数据库，但连接到MySQL数据库似乎很困难？

有人能帮我吗？