Scribd
Upload
19 views4 pages

DB Error

The document describes an error encountered while running a Python script that uses SQLAlchemy to connect to a MySQL database. The error indicates that access is denied for the user 'root' at 'localhost' due to authentication issues. This is a common problem related to incorrect credentials or user permissions in the database configuration.

Uploaded by

Şhőąîb Çhouhadary
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
19 views4 pages

DB Error

The document describes an error encountered while running a Python script that uses SQLAlchemy to connect to a MySQL database. The error indicates that access is denied for the user 'root' at 'localhost' due to authentication issues. This is a common problem related to incorrect credentials or user permissions in the database configuration.

Uploaded by

Şhőąîb Çhouhadary
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

PS C:\Users\user\OneDrive\Desktop\python> python test.

py
Traceback (most recent call last):
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
engine\base.py", line 146, in __init__
self._dbapi_connection = engine.raw_connection()
~~~~~~~~~~~~~~~~~~~~~^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
engine\base.py", line 3302, in raw_connection
return self.pool.connect()
~~~~~~~~~~~~~~~~~^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
pool\base.py", line 449, in connect
return _ConnectionFairy._checkout(self)
~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
pool\base.py", line 1263, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
pool\base.py", line 712, in checkout
rec = pool._do_get()
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
pool\impl.py", line 179, in _do_get
with util.safe_reraise():
~~~~~~~~~~~~~~~~~^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
util\langhelpers.py", line 146, in __exit__
raise exc_value.with_traceback(exc_tb)
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
pool\impl.py", line 177, in _do_get
return self._create_connection()
~~~~~~~~~~~~~~~~~~~~~~~^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
pool\base.py", line 390, in _create_connection
return _ConnectionRecord(self)
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
pool\base.py", line 674, in __init__
self.__connect()
~~~~~~~~~~~~~~^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
pool\base.py", line 900, in __connect
with util.safe_reraise():
~~~~~~~~~~~~~~~~~^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
util\langhelpers.py", line 146, in __exit__
raise exc_value.with_traceback(exc_tb)
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
pool\base.py", line 896, in __connect
self.dbapi_connection = connection = pool._invoke_creator(self)
~~~~~~~~~~~~~~~~~~~~^^^^^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
engine\create.py", line 643, in connect
return dialect.connect(*cargs, **cparams)
~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
engine\default.py", line 621, in connect
return self.loaded_dbapi.connect(*cargs, **cparams)
~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\pymysql\
connections.py", line 361, in __init__
self.connect()
~~~~~~~~~~~~^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\pymysql\
connections.py", line 669, in connect
self._request_authentication()
~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\pymysql\
connections.py", line 957, in _request_authentication
auth_packet = self._read_packet()
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\pymysql\
connections.py", line 775, in _read_packet
packet.raise_for_error()
~~~~~~~~~~~~~~~~~~~~~~^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\pymysql\
protocol.py", line 219, in raise_for_error
err.raise_mysql_exception(self._data)
~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\pymysql\
err.py", line 150, 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 "C:\Users\user\OneDrive\Desktop\python\test.py", line 65, in <module>
db.create_all()
~~~~~~~~~~~~~^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\
flask_sqlalchemy\extension.py", line 900, in create_all
self._call_for_binds(bind_key, "create_all")
~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\
flask_sqlalchemy\extension.py", line 881, in _call_for_binds
getattr(metadata, op_name)(bind=engine)
~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
sql\schema.py", line 5868, in create_all
bind._run_ddl_visitor(
~~~~~~~~~~~~~~~~~~~~~^
ddl.SchemaGenerator, self, checkfirst=checkfirst, tables=tables
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
)
^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
engine\base.py", line 3252, in _run_ddl_visitor
with self.begin() as conn:
~~~~~~~~~~^^
File "C:\Python313\Lib\contextlib.py", line 141, in __enter__
return next(self.gen)
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
engine\base.py", line 3242, in begin
with self.connect() as conn:
~~~~~~~~~~~~^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
engine\base.py", line 3278, in connect
return self._connection_cls(self)
~~~~~~~~~~~~~~~~~~~~^^^^^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
engine\base.py", line 148, in __init__
Connection._handle_dbapi_exception_noconnection(
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
err, dialect, engine
^^^^^^^^^^^^^^^^^^^^
)
^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
engine\base.py", line 2442, in _handle_dbapi_exception_noconnection
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
engine\base.py", line 146, in __init__
self._dbapi_connection = engine.raw_connection()
~~~~~~~~~~~~~~~~~~~~~^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
engine\base.py", line 3302, in raw_connection
return self.pool.connect()
~~~~~~~~~~~~~~~~~^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
pool\base.py", line 449, in connect
return _ConnectionFairy._checkout(self)
~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
pool\base.py", line 1263, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
pool\base.py", line 712, in checkout
rec = pool._do_get()
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
pool\impl.py", line 179, in _do_get
with util.safe_reraise():
~~~~~~~~~~~~~~~~~^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
util\langhelpers.py", line 146, in __exit__
raise exc_value.with_traceback(exc_tb)
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
pool\impl.py", line 177, in _do_get
return self._create_connection()
~~~~~~~~~~~~~~~~~~~~~~~^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
pool\base.py", line 390, in _create_connection
return _ConnectionRecord(self)
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
pool\base.py", line 674, in __init__
self.__connect()
~~~~~~~~~~~~~~^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
pool\base.py", line 900, in __connect
with util.safe_reraise():
~~~~~~~~~~~~~~~~~^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
util\langhelpers.py", line 146, in __exit__
raise exc_value.with_traceback(exc_tb)
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
pool\base.py", line 896, in __connect
self.dbapi_connection = connection = pool._invoke_creator(self)
~~~~~~~~~~~~~~~~~~~~^^^^^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
engine\create.py", line 643, in connect
return dialect.connect(*cargs, **cparams)
~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\sqlalchemy\
engine\default.py", line 621, in connect
return self.loaded_dbapi.connect(*cargs, **cparams)
~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\pymysql\
connections.py", line 361, in __init__
self.connect()
~~~~~~~~~~~~^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\pymysql\
connections.py", line 669, in connect
self._request_authentication()
~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\pymysql\
connections.py", line 957, in _request_authentication
auth_packet = self._read_packet()
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\pymysql\
connections.py", line 775, in _read_packet
packet.raise_for_error()
~~~~~~~~~~~~~~~~~~~~~~^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\pymysql\
protocol.py", line 219, in raise_for_error
err.raise_mysql_exception(self._data)
~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^
File "C:\Users\user\AppData\Roaming\Python\Python313\site-packages\pymysql\
err.py", line 150, 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)
PS C:\Users\user\OneDrive\Desktop\python>

You might also like