无法生成数据表

来源: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下这个错误原因,网上资料非常多。

0
1
ABCDEFGHIJKLM
谢谢同学已经解决
2020-02-18
共1条回复

Python Flask高级编程之从0到1开发《鱼书》精品项目

7月老师深入浅出剖析Flask核心机制,和你一起探讨Python高级编程

2751 学习 · 1277 问题

查看课程