upon executing 'python3.9 main.py

[kiyomiki]

upon executing 'python3.9 main.py' i get this, any fix?

• Serving Quart app 'main'
• Debug mode: False
• Please use an ASGI server (e.g. Hypercorn) directly in production
• Running on http://127.0.0.1:8000 (CTRL + C to quit) [2024-03-23 13:01:33,429] ERROR in app: Exception Traceback (most recent call last): File "/usr/local/lib/python3.9/dist-packages/quart/app.py", line 1671, in startup await self.ensure_async(func)() File "/home/kiyo/osu-nuts/guweb/main.py", line 31, in mysql_conn await glob.db.connect(glob.config.mysql) # type: ignore File "/usr/local/lib/python3.9/dist-packages/cmyui/mysql.py", line 37, in connect self.pool = await aiomysql.create_pool(**config, autocommit=True) File "/usr/local/lib/python3.9/dist-packages/aiomysql/pool.py", line 29, in _create_pool await pool._fill_free_pool(False) File "/usr/local/lib/python3.9/dist-packages/aiomysql/pool.py", line 182, in _fill_free_pool conn = await connect(echo=self._echo, loop=self._loop, File "/usr/local/lib/python3.9/dist-packages/aiomysql/connection.py", line 75, in _connect await conn._connect() File "/usr/local/lib/python3.9/dist-packages/aiomysql/connection.py", line 540, in _connect await self._request_authentication() File "/usr/local/lib/python3.9/dist-packages/aiomysql/connection.py", line 855, in _request_authentication await self._process_auth(plugin_name, auth_packet) File "/usr/local/lib/python3.9/dist-packages/aiomysql/connection.py", line 907, in _process_auth pkt = await self._read_packet() File "/usr/local/lib/python3.9/dist-packages/aiomysql/connection.py", line 652, in _read_packet packet.raise_for_error() File "/usr/local/lib/python3.9/dist-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/local/lib/python3.9/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1045, "Access denied for user 'kiyo'@'localhost' (using password: YES)") Traceback (most recent call last): File "/usr/local/lib/python3.9/dist-packages/quart/asgi.py", line 320, in call await self.app.startup() File "/usr/local/lib/python3.9/dist-packages/quart/app.py", line 1671, in startup await self.ensure_async(func)() File "/home/kiyo/osu-nuts/guweb/main.py", line 31, in mysql_conn await glob.db.connect(glob.config.mysql) # type: ignore File "/usr/local/lib/python3.9/dist-packages/cmyui/mysql.py", line 37, in connect self.pool = await aiomysql.create_pool(**config, autocommit=True) File "/usr/local/lib/python3.9/dist-packages/aiomysql/pool.py", line 29, in _create_pool await pool._fill_free_pool(False) File "/usr/local/lib/python3.9/dist-packages/aiomysql/pool.py", line 182, in _fill_free_pool conn = await connect(echo=self._echo, loop=self._loop, File "/usr/local/lib/python3.9/dist-packages/aiomysql/connection.py", line 75, in _connect await conn._connect() File "/usr/local/lib/python3.9/dist-packages/aiomysql/connection.py", line 540, in _connect await self._request_authentication() File "/usr/local/lib/python3.9/dist-packages/aiomysql/connection.py", line 855, in _request_authentication await self._process_auth(plugin_name, auth_packet) File "/usr/local/lib/python3.9/dist-packages/aiomysql/connection.py", line 907, in _process_auth pkt = await self._read_packet() File "/usr/local/lib/python3.9/dist-packages/aiomysql/connection.py", line 652, in _read_packet packet.raise_for_error() File "/usr/local/lib/python3.9/dist-packages/pymysql/protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "/usr/local/lib/python3.9/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1045, "Access denied for user 'kiyo'@'localhost' (using password: YES)")

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "/home/kiyo/osu-nuts/guweb/main.py", line 74, in app.run(port=8000, debug=glob.config.debug) # blocking call File "/usr/local/lib/python3.9/dist-packages/quart/app.py", line 850, in run loop.run_until_complete(asyncio.gather(*tasks)) File "/usr/lib/python3.9/asyncio/base_events.py", line 647, in run_until_complete return future.result() File "/usr/local/lib/python3.9/dist-packages/hypercorn/asyncio/init.py", line 44, in serve await worker_serve( File "/usr/local/lib/python3.9/dist-packages/hypercorn/asyncio/run.py", line 87, in worker_serve raise exception File "/usr/local/lib/python3.9/dist-packages/hypercorn/asyncio/lifespan.py", line 43, in handle_lifespan await self.app( File "/usr/local/lib/python3.9/dist-packages/hypercorn/app_wrappers.py", line 34, in call await self.app(scope, receive, send) File "/usr/local/lib/python3.9/dist-packages/quart/app.py", line 1638, in call await self.asgi_app(scope, receive, send) File "/usr/local/lib/python3.9/dist-packages/quart/app.py", line 1664, in asgi_app await asgi_handler(receive, send) File "/usr/local/lib/python3.9/dist-packages/quart/asgi.py", line 322, in call await send( File "/usr/local/lib/python3.9/dist-packages/hypercorn/asyncio/lifespan.py", line 101, in asgi_send raise LifespanFailureError("startup", message.get("message", "")) hypercorn.utils.LifespanFailureError: Lifespan failure in startup. '(1045, "Access denied for user 'kiyo'@'localhost' (using password: YES)")'

[7ez]

kiyo I think the error is self explainable you do not have access to the database on your account

[kiyomiki]

right i understand that part, but i just dont know how to give myself access

[7ez]

sudo mysql grant all on *.* to 'kiyo'@'localhost'; exit

[kiyomiki]

still getting the same error

[7ez]

are u using docker

[kiyomiki]

unsure

[kiyomiki]

i think i am