Connect MySQL (version 8.0.25)

[osyangy]

Traceback (most recent call last): File "c:\software\program\python\python38\lib\site-packages\aiomysql\connection.py", line 503, in _connect await self._request_authentication() File "c:\software\program\python\python38\lib\site-packages\aiomysql\connection.py", line 796, in _request_authentication await self._process_auth(plugin_name, auth_packet) File "c:\software\program\python\python38\lib\site-packages\aiomysql\connection.py", line 848, in _process_auth pkt = await self._read_packet() File "c:\software\program\python\python38\lib\site-packages\aiomysql\connection.py", line 593, in _read_packet packet.check_error() File "c:\software\program\python\python38\lib\site-packages\pymysql\protocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "c:\software\program\python\python38\lib\site-packages\pymysql\err.py", line 109, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1045, "Access denied for user 'root'@'...' (using password: YES)")

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

Traceback (most recent call last): File "c:\software\program\python\python38\lib\site-packages\tortoise\backends\mysql\client.py", line 115, in create_connection self._pool = await mysql.create_pool(password=self.password, *self._template) File "c:\software\program\python\python38\lib\site-packages\aiomysql\pool.py", line 29, in _create_pool await pool._fill_free_pool(False) File "c:\software\program\python\python38\lib\site-packages\aiomysql\pool.py", line 167, in _fill_free_pool conn = await connect(echo=self._echo, loop=self._loop, File "c:\software\program\python\python38\lib\site-packages\aiomysql\connection.py", line 75, in _connect await conn._connect() File "c:\software\program\python\python38\lib\site-packages\aiomysql\connection.py", line 521, in _connect raise OperationalError(2003, pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on '...*'")

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "c:\software\program\python\python38\lib\runpy.py", line 194, in _run_module_as_main return _run_code(code, main_globals, None, File "c:\software\program\python\python38\lib\runpy.py", line 87, in _run_code exec(code, run_globals) File "C:\SoftWare\Program\Python\Python38\Scripts\aerich.exe__main.py", line 7, in File "c:\software\program\python\python38\lib\site-packages\aerich\cli.py", line 317, in main cli() File "c:\software\program\python\python38\lib\site-packages\click\core.py", line 764, in call return self.main(args, kwargs) File "c:\software\program\python\python38\lib\site-packages\click\core.py", line 717, in main rv = self.invoke(ctx) File "c:\software\program\python\python38\lib\site-packages\click\core.py", line 1134, in invoke Command.invoke(self, ctx) File "c:\software\program\python\python38\lib\site-packages\click\core.py", line 956, in invoke return ctx.invoke(self.callback, ctx.params) File "c:\software\program\python\python38\lib\site-packages\click\core.py", line 555, in invoke return callback(args, kwargs) File "c:\software\program\python\python38\lib\site-packages\click\decorators.py", line 17, in new_func return f(get_current_context(), *args, *kwargs) File "c:\software\program\python\python38\lib\site-packages\aerich\cli.py", line 41, in wrapper loop.run_until_complete(f(args, kwargs)) File "c:\software\program\python\python38\lib\asyncio\base_events.py", line 616, in run_until_complete return future.result() File "c:\software\program\python\python38\lib\site-packages\aerich\cli.py", line 91, in cli await Migrate.init(tortoise_config, app, location) File "c:\software\program\python\python38\lib\site-packages\aerich\migrate.py", line 66, in init await Tortoise.init(config=config) File "c:\software\program\python\python38\lib\site-packages\tortoise__init__.py", line 598, in init await cls._init_connections(connections_config, _create_db) File "c:\software\program\python\python38\lib\site-packages\tortoise\init__.py", line 390, in _init_connections await connection.create_connection(with_db=True) File "c:\software\program\python\python38\lib\site-packages\tortoise\backends\mysql\client.py", line 135, in create_connection raise DBConnectionError(f"Can't connect to MySQL server: {self._template}") tortoise.exceptions.DBConnectionError: Can't connect to MySQL server: {'host': '...', 'port': 3306, 'user': 'root', 'db': 'recharge', 'autocomm it': True, 'charset': 'utf8mb4', 'minsize': 1, 'maxsize': 5, 'sql_mode': 'STRICT_TRANS_TABLES'}

But used Mysql (5.7) was successful to connect.

[long2ice]

Check your connection config