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

tariqjamal-abdulazeez · 2023-11-20T20:26:06Z

tariqjamal-abdulazeez
Nov 20, 2023

$ 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 · 2023-11-20T20:28:05Z

ThiefMaster
Nov 20, 2023
Maintainer

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

Did you check that?

0 replies

ThiefMaster · 2023-11-20T20:28:55Z

ThiefMaster
Nov 20, 2023
Maintainer

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

0 replies

tariqjamal-abdulazeez · 2023-11-20T20:32:51Z

tariqjamal-abdulazeez
Nov 20, 2023
Author

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"

0 replies

Ghost-2022 · 2024-03-04T08:35:05Z

Ghost-2022
Mar 4, 2024

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.

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

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

{{title}}

{{editor}}'s edit

{{editor}}'s edit

Replies: 4 comments

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

Select a reply

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

tariqjamal-abdulazeez Nov 20, 2023

Replies: 4 comments

ThiefMaster Nov 20, 2023 Maintainer

ThiefMaster Nov 20, 2023 Maintainer

tariqjamal-abdulazeez Nov 20, 2023 Author

Ghost-2022 Mar 4, 2024

tariqjamal-abdulazeez
Nov 20, 2023

ThiefMaster
Nov 20, 2023
Maintainer

ThiefMaster
Nov 20, 2023
Maintainer

tariqjamal-abdulazeez
Nov 20, 2023
Author

Ghost-2022
Mar 4, 2024