sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError)

[tariqjamal-abdulazeez]

$ flask db upgrade
'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.
'FLASK_ENV' is deprecated and will not be used in Flask 2.3. Use 'FLASK_DEBUG' instead.
INFO  [alembic.env] Tables which are allowed for autogeneration: vsessions, vparticipants, vrecordings, vevents, interpreter_vsession_notifications, provider_vri_settings, notification_device, sites, customers, interpreters, languages, contacts, customers, logins_int, interpreter_availability, mobile_app_versions, operators
INFO  [alembic.env] To add more, look at alembic.ini in the alembic:include section
Traceback (most recent call last):
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 145, in __init__
    self._dbapi_connection = engine.raw_connection()
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 3292, in raw_connection
    return self.pool.connect()
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 452, in connect
    return _ConnectionFairy._checkout(self)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 1269, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 716, in checkout
    rec = pool._do_get()
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/sqlalchemy/pool/impl.py", line 284, in _do_get
    return self._create_connection()
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 393, in _create_connection
    return _ConnectionRecord(self)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 678, in __init__
    self.__connect()
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 903, in __connect
    pool.logger.debug("Error on connect(): %s", e)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
    raise exc_value.with_traceback(exc_tb)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 898, in __connect
    self.dbapi_connection = connection = pool._invoke_creator(self)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/sqlalchemy/engine/create.py", line 637, in connect
    return dialect.connect(*cargs, **cparams)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 616, in connect
    return self.loaded_dbapi.connect(*cargs, **cparams)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/pymysql/__init__.py", line 94, in Connect
    return Connection(*args, **kwargs)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/pymysql/connections.py", line 325, in __init__
    self.connect()
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/pymysql/connections.py", line 599, in connect
    self._request_authentication()
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/pymysql/connections.py", line 871, in _request_authentication
    auth_packet = self._process_auth(plugin_name, auth_packet)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/pymysql/connections.py", line 942, in _process_auth
    pkt = self._read_packet()
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/pymysql/connections.py", line 684, in _read_packet
    packet.check_error()
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/pymysql/protocol.py", line 220, in check_error
    err.raise_mysql_exception(self._data)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: YES)")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/bin/flask", line 8, in <module>
    sys.exit(main())
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/flask/cli.py", line 1050, in main
    cli.main()
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/click/core.py", line 1053, in main
    rv = self.invoke(ctx)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/click/core.py", line 1659, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/click/core.py", line 1659, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/click/core.py", line 1395, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/click/core.py", line 754, in invoke
    return __callback(*args, **kwargs)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/click/decorators.py", line 26, in new_func
    return f(get_current_context(), *args, **kwargs)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/flask/cli.py", line 357, in decorator
    return __ctx.invoke(f, *args, **kwargs)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/click/core.py", line 754, in invoke
    return __callback(*args, **kwargs)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/flask_migrate/cli.py", line 136, in upgrade
    _upgrade(directory, revision, sql, tag, x_arg)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/flask_migrate/__init__.py", line 96, in wrapped
    f(*args, **kwargs)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/flask_migrate/__init__.py", line 271, in upgrade
    command.upgrade(config, revision, sql=sql, tag=tag)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/alembic/command.py", line 320, in upgrade
    script.run_env()
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/alembic/script/base.py", line 563, in run_env
    util.load_python_file(self.dir, "env.py")
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/alembic/util/pyfiles.py", line 92, in load_python_file
    module = load_module_py(module_id, path)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/alembic/util/pyfiles.py", line 108, in load_module_py
    spec.loader.exec_module(module)  # type: ignore
  File "<frozen importlib._bootstrap_external>", line 850, in exec_module
  File "<frozen importlib._bootstrap>", line 228, in _call_with_frames_removed
  File "migrations/env.py", line 123, in <module>
    run_migrations_online()
  File "migrations/env.py", line 105, in run_migrations_online
    with connectable.connect() as connection:
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 3268, in connect
    return self._connection_cls(self)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 147, in __init__
    Connection._handle_dbapi_exception_noconnection(
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2430, in _handle_dbapi_exception_noconnection
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 145, in __init__
    self._dbapi_connection = engine.raw_connection()
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 3292, in raw_connection
    return self.pool.connect()
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 452, in connect
    return _ConnectionFairy._checkout(self)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 1269, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 716, in checkout
    rec = pool._do_get()
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/sqlalchemy/pool/impl.py", line 284, in _do_get
    return self._create_connection()
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 393, in _create_connection
    return _ConnectionRecord(self)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 678, in __init__
    self.__connect()
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 903, in __connect
    pool.logger.debug("Error on connect(): %s", e)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
    raise exc_value.with_traceback(exc_tb)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 898, in __connect
    self.dbapi_connection = connection = pool._invoke_creator(self)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/sqlalchemy/engine/create.py", line 637, in connect
    return dialect.connect(*cargs, **cparams)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 616, in connect
    return self.loaded_dbapi.connect(*cargs, **cparams)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/pymysql/__init__.py", line 94, in Connect
    return Connection(*args, **kwargs)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/pymysql/connections.py", line 325, in __init__
    self.connect()
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/pymysql/connections.py", line 599, in connect
    self._request_authentication()
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/pymysql/connections.py", line 871, in _request_authentication
    auth_packet = self._process_auth(plugin_name, auth_packet)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/pymysql/connections.py", line 942, in _process_auth
    pkt = self._read_packet()
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/pymysql/connections.py", line 684, in _read_packet
    packet.check_error()
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/pymysql/protocol.py", line 220, in check_error
    err.raise_mysql_exception(self._data)
  File "/Users/tariqjamal/anaconda3/envs/lvdispatch_2/lib/python3.9/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
    raise errorclass(errno, errval)
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1045, "Access denied for user 'root'@'localhost' (using password: YES)")
(Background on this error at: https://sqlalche.me/e/20/e3q8)

It seems like when attempting to upgrade the changes in the database using a specific command, you're encountering an error. However, the command flask db migrate works perfectly fine with flask-sqlalchemy^2.4.3.

Could anyone help me to solve this issue

Environment:

• Python version: 3.8
• Flask-SQLAlchemy version: 3.1.1
• SQLAlchemy version: 20.0.5

[ThiefMaster]

sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1045, "Access denied for user 'root'@'localhost' (using password: YES)")

Did you check that?

[ThiefMaster]

Also, do not ping random maintainers unless the issue is really specific to them.

[tariqjamal-abdulazeez]

Bro after trying all possibility but the error is not resolved and this was occurred during only the migrate the changes to db

Datebase uri link
SQLALCHEMY_DATABASE_URI = "mysql+pymysql://root:password@127.0.0.1:3306/database"

[Ghost-2022]

The problem has been resolved. Does the password contain any special characters?
The same code works when running on Windows, but it fails when placed inside a container.

[735Andrew]

Thank you for your advice of special characters!