Return to Question

app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://:@/

But there is an error: Traceback (most recent call last): File "", line 1, in File "/home/ec2-user/venv/lib/python3.7/site-packages/flask_sqlalchemy/init.py", line 514, in get return type.query_class(mapper, session=self.sa.session()) File "/home/ec2-user/venv/lib/python3.7/site-packages/sqlalchemy/orm/scoping.py", line 74, in call return self.registry() File "/home/ec2-user/venv/lib/python3.7/site-packages/sqlalchemy/util/collections.py", line 1001, in call return self.registry.setdefault(key, self.createfunc()) File "/home/ec2-user/venv/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2950, in call return self.class(**local_kw) File "/home/ec2-user/venv/lib/python3.7/site-packages/flask_sqlalchemy/init.py", line 143, in init bind = options.pop('bind', None) or db.engine File "/home/ec2-user/venv/lib/python3.7/site-packages/flask_sqlalchemy/init.py", line 877, in engine return self.get_engine() File "/home/ec2-user/venv/lib/python3.7/site-packages/flask_sqlalchemy/init.py", line 896, in get_engine return connector.get_engine() File "/home/ec2-user/venv/lib/python3.7/site-packages/flask_sqlalchemy/init.py", line 559, in get_engine self._engine = rv = sqlalchemy.create_engine(info, **options) File "/home/ec2-user/venv/lib/python3.7/site-packages/sqlalchemy/engine/init.py", line 424, in create_engine return strategy.create(*args, **kwargs) File "/home/ec2-user/venv/lib/python3.7/site-packages/sqlalchemy/engine/strategies.py", line 81, in create dbapi = dialect_cls.dbapi(**dbapi_args) File "/home/ec2-user/venv/lib/python3.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 102, in dbapi return import('MySQLdb') ModuleNotFoundError: No module named 'MySQLdb'

app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://<user>:<password>@<host>/<dbname>

But there is an error:

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/home/ec2-user/venv/lib/python3.7/site-packages/flask_sqlalchemy/__init__.py", line 514, in __get__
    return type.query_class(mapper, session=self.sa.session())
  File "/home/ec2-user/venv/lib/python3.7/site-packages/sqlalchemy/orm/scoping.py", line 74, in __call__
    return self.registry()
  File "/home/ec2-user/venv/lib/python3.7/site-packages/sqlalchemy/util/_collections.py", line 1001, in __call__
    return self.registry.setdefault(key, self.createfunc())
  File "/home/ec2-user/venv/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2950, in __call__
    return self.class_(**local_kw)
  File "/home/ec2-user/venv/lib/python3.7/site-packages/flask_sqlalchemy/__init__.py", line 143, in __init__
    bind = options.pop('bind', None) or db.engine
  File "/home/ec2-user/venv/lib/python3.7/site-packages/flask_sqlalchemy/__init__.py", line 877, in engine
    return self.get_engine()
  File "/home/ec2-user/venv/lib/python3.7/site-packages/flask_sqlalchemy/__init__.py", line 896, in get_engine
    return connector.get_engine()
  File "/home/ec2-user/venv/lib/python3.7/site-packages/flask_sqlalchemy/__init__.py", line 559, in get_engine
    self._engine = rv = sqlalchemy.create_engine(info, **options)
  File "/home/ec2-user/venv/lib/python3.7/site-packages/sqlalchemy/engine/__init__.py", line 424, in create_engine
    return strategy.create(*args, **kwargs)
  File "/home/ec2-user/venv/lib/python3.7/site-packages/sqlalchemy/engine/strategies.py", line 81, in create
    dbapi = dialect_cls.dbapi(**dbapi_args)
  File "/home/ec2-user/venv/lib/python3.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 102, in dbapi
    return __import__('MySQLdb')
ModuleNotFoundError: No module named 'MySQLdb'