使用flasksqlalchemy创建一个mysql表

Question

我试图用flask sqlalchemy在python解释器中创建一个mysql表。我得到了错误

File "/Users/chen97me/Documents/project/instaad/venv/lib/python3.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 118, in dbapi
    return __import__("MySQLdb")
File "/Users/chen97me/Documents/project/instaad/venv/lib/python3.7/site-packages/MySQLdb/__init__.py", line 18, in <module>
    from . import _mysql
ImportError: dlopen(/Users/chen97me/Documents/project/instaad/venv/lib/python3.7/site-packages/MySQLdb/_mysql.cpython-37m-darwin.so, 2): Library not loaded: @rpath/libmysqlclient.21.dylib
  Referenced from: /Users/chen97me/Documents/project/instaad/venv/lib/python3.7/site-packages/MySQLdb/_mysql.cpython-37m-darwin.so
  Reason: image not found

我键入的代码如下

from website import create_app, db
app = create_app()
ctx = app.app_context()
ctx.push()
db.create_all()

这是我的项目目录中的venv/lib/python3.7/site-packages/目录中的内容

我正在运行MacOSX，根据我的研究，这可能与此有关。你知道吗

我的配置.py文件

class Config:
    SECRET_KEY='123456'
    SQLALCHEMY_DATABASE_URI='mysql:///root:mysqls@localhost/website'