无法生成数据表
来源:4-9 将模型映射到数据库中

ABCDEFGHIJKLM
2020-02-17
老师您好,我这个一直无法生成数据表跟着您代码一行行敲的,自己设置的密码也是123456
完整的:
C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\Scripts\python.exe “D:\pycharm\PyCharm 2019.3.1\plugins\python\helpers\pydev\pydevd.py” --multiproc --qt-support=auto --client 127.0.0.1 --port 53882 --file C:/Users/YHW/Desktop/fisher/fisher.py
pydev debugger: process 14988 is connecting
Connected to pydev debugger (build 193.5662.61)
C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\flask_sqlalchemy_init_.py:835: FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
'SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and '
Traceback (most recent call last):
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\engine\base.py”, line 2276, in _wrap_pool_connect
return fn()
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\pool\base.py”, line 363, in connect
return _ConnectionFairy._checkout(self)
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\pool\base.py”, line 773, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\pool\base.py”, line 492, in checkout
rec = pool._do_get()
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\pool\impl.py”, line 139, in _do_get
self._dec_overflow()
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\util\langhelpers.py”, line 68, in exit
compat.reraise(exc_type, exc_value, exc_tb)
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\util\compat.py”, line 153, in reraise
raise value
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\pool\impl.py”, line 136, in _do_get
return self._create_connection()
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\pool\base.py”, line 308, in _create_connection
return _ConnectionRecord(self)
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\pool\base.py”, line 437, in init
self.__connect(first_connect_check=True)
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\pool\base.py”, line 652, in __connect
connection = pool.invoke_creator(self)
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\engine\strategies.py”, line 114, in connect
return dialect.connect(*cargs, **cparams)
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\engine\default.py”, line 489, in connect
return self.dbapi.connect(*cargs, **cparams)
File "C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\pymysql_init.py", line 94, in Connect
return Connection(*args, **kwargs)
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\pymysql\connections.py”, line 325, in init
self.connect()
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\pymysql\connections.py”, line 599, in connect
self._request_authentication()
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\pymysql\connections.py”, line 861, in _request_authentication
auth_packet = self._read_packet()
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\pymysql\connections.py”, line 684, in _read_packet
packet.check_error()
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\pymysql\protocol.py”, line 220, in check_error
err.raise_mysql_exception(self._data)
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\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’@‘localhost’ (using password: YES)”)
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File “c:\users\yhw\appdata\local\programs\python\python36\lib\contextlib.py”, line 81, in enter
return next(self.gen)
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\engine\base.py”, line 2040, in _optional_conn_ctx_manager
with self._contextual_connect() as conn:
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\engine\base.py”, line 2242, in _contextual_connect
self._wrap_pool_connect(self.pool.connect, None),
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\engine\base.py”, line 2280, in _wrap_pool_connect
e, dialect, self
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\engine\base.py”, line 1547, in _handle_dbapi_exception_noconnection
util.raise_from_cause(sqlalchemy_exception, exc_info)
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\util\compat.py”, line 398, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\util\compat.py”, line 152, in reraise
raise value.with_traceback(tb)
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\engine\base.py”, line 2276, in _wrap_pool_connect
return fn()
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\pool\base.py”, line 363, in connect
return _ConnectionFairy._checkout(self)
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\pool\base.py”, line 773, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\pool\base.py”, line 492, in checkout
rec = pool._do_get()
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\pool\impl.py”, line 139, in _do_get
self._dec_overflow()
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\util\langhelpers.py”, line 68, in exit
compat.reraise(exc_type, exc_value, exc_tb)
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\util\compat.py”, line 153, in reraise
raise value
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\pool\impl.py”, line 136, in _do_get
return self._create_connection()
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\pool\base.py”, line 308, in _create_connection
return _ConnectionRecord(self)
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\pool\base.py”, line 437, in init
self.__connect(first_connect_check=True)
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\pool\base.py”, line 652, in __connect
connection = pool.invoke_creator(self)
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\engine\strategies.py”, line 114, in connect
return dialect.connect(*cargs, **cparams)
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\sqlalchemy\engine\default.py”, line 489, in connect
return self.dbapi.connect(*cargs, **cparams)
File "C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\pymysql_init.py", line 94, in Connect
return Connection(*args, **kwargs)
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\pymysql\connections.py”, line 325, in init
self.connect()
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\pymysql\connections.py”, line 599, in connect
self._request_authentication()
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\pymysql\connections.py”, line 861, in _request_authentication
auth_packet = self._read_packet()
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\pymysql\connections.py”, line 684, in _read_packet
packet.check_error()
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\site-packages\pymysql\protocol.py”, line 220, in check_error
err.raise_mysql_exception(self._data)
File “C:\Users\YHW.virtualenvs\fisher-cYsz0bDx\lib\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: http://sqlalche.me/e/e3q8)
Process finished with exit code 1
1回答
-
以病制病
2020-02-18
报错信息:1045, “Access denied for user ‘root’@‘localhost’ (using password: YES)”
首先排除一下数据库有没启动,密码不对也会出现这种情况,最好是自己Google下这个错误原因,网上资料非常多。
012020-02-18
相似问题