Discuss / Python / 报错连接不上数据库,哪位大神帮忙看下

报错连接不上数据库,哪位大神帮忙看下

Topic source

C:\Swift\Software\System\python3.6.1\python.exe C:/Users/Swift_wyd/PycharmProjects/Python/www/app.py INFO:root:create database connection pool... Traceback (most recent call last): File "C:\Swift\Software\System\python3.6.1\lib\site-packages\aiomysql\connection.py", line 470, in _connect yield from self._request_authentication() File "C:\Swift\Software\System\python3.6.1\lib\site-packages\aiomysql\connection.py", line 687, in _request_authentication auth_packet = yield from self._read_packet() File "C:\Swift\Software\System\python3.6.1\lib\site-packages\aiomysql\connection.py", line 552, in _read_packet packet.check_error() File "C:\Swift\Software\System\python3.6.1\lib\site-packages\pymysql\connections.py", line 393, in check_error err.raise_mysql_exception(self._data) File "C:\Swift\Software\System\python3.6.1\lib\site-packages\pymysql\err.py", line 107, 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/Swift_wyd/PycharmProjects/Python/www/app.py", line 119, in <module> loop.run_until_complete(init(loop)) File "C:\Swift\Software\System\python3.6.1\lib\asyncio\base_events.py", line 466, in run_until_complete return future.result() File "C:/Users/Swift_wyd/PycharmProjects/Python/www/app.py", line 107, in init await www.orms.create_pool(loop=loop,host='127.0.0.1', port=3306, user='root', password='123456', db='awesome') File "C:\Users\Swift_wyd\PycharmProjects\Python\www\orms.py", line 27, in create_pool loop=loop File "C:\Swift\Software\System\python3.6.1\lib\site-packages\aiomysql\utils.py", line 66, in await resp = yield from self._coro File "C:\Swift\Software\System\python3.6.1\lib\site-packages\aiomysql\pool.py", line 28, in _create_pool yield from pool._fill_free_pool(False) File "C:\Swift\Software\System\python3.6.1\lib\site-packages\aiomysql\pool.py", line 164, in _fill_free_pool **self._conn_kwargs) File "C:\Swift\Software\System\python3.6.1\lib\site-packages\aiomysql\utils.py", line 61, in iter resp = yield from self._coro File "C:\Swift\Software\System\python3.6.1\lib\site-packages\aiomysql\connection.py", line 80, in _connect yield from conn._connect() File "C:\Swift\Software\System\python3.6.1\lib\site-packages\aiomysql\connection.py", line 490, in _connect self._host) from e pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on '127.0.0.1'")

Process finished with exit code 1

廖雪峰

#2 Created at ... [Delete] [Delete and Lock User]

学会看出错信息:

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

密码不对


  • 1

Reply