initdb 错误

[282144757]

Traceback (most recent call last):
File "venv/bin/flask", line 11, in
sys.exit(main())
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/flask/cli.py", line 513, in main
cli.main(args=args, prog_name=name)
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/flask/cli.py", line 380, in main
return AppGroup.main(self, *args, **kwargs)
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/click/core.py", line 697, in main
rv = self.invoke(ctx)
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/click/core.py", line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/click/core.py", line 895, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/click/core.py", line 535, in invoke
return callback(*args, **kwargs)
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/click/decorators.py", line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/flask/cli.py", line 257, in decorator
return __ctx.invoke(f, *args, **kwargs)
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/click/core.py", line 535, in invoke
return callback(*args, **kwargs)
File "/Users/levy/wechat-admin/manager.py", line 15, in initdb
db.drop_all()
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/flask_sqlalchemy/init.py", line 1015, in drop_all
self._execute_for_all_tables(app, bind, 'drop_all')
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/flask_sqlalchemy/init.py", line 999, in _execute_for_all_tables
op(bind=self.get_engine(app, bind), **extra)
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/sqlalchemy/sql/schema.py", line 4031, in drop_all
tables=tables)
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1939, in _run_visitor
with self._optional_conn_ctx_manager(connection) as conn:
File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/contextlib.py", line 87, in enter
return next(self.gen)
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1932, in _optional_conn_ctx_manager
with self.contextual_connect() as conn:
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2123, in contextual_connect
self._wrap_pool_connect(self.pool.connect, None),
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2158, in _wrap_pool_connect
return fn()
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/sqlalchemy/pool.py", line 403, in connect
return _ConnectionFairy._checkout(self)
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/sqlalchemy/pool.py", line 791, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/sqlalchemy/pool.py", line 532, in checkout
rec = pool._do_get()
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/sqlalchemy/pool.py", line 1196, in _do_get
self._dec_overflow()
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 66, in exit
compat.reraise(exc_type, exc_value, exc_tb)
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 187, in reraise
raise value
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/sqlalchemy/pool.py", line 1193, in _do_get
return self._create_connection()
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/sqlalchemy/pool.py", line 350, in _create_connection
return _ConnectionRecord(self)
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/sqlalchemy/pool.py", line 477, in init
self.__connect(first_connect_check=True)
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/sqlalchemy/pool.py", line 674, in __connect
connection = pool._invoke_creator(self)
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/sqlalchemy/engine/strategies.py", line 106, in connect
return dialect.connect(*cargs, **cparams)
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 411, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/pymysql/init.py", line 90, in Connect
return Connection(*args, **kwargs)
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/pymysql/connections.py", line 706, in init
self.connect()
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/pymysql/connections.py", line 931, in connect
self._get_server_information()
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/pymysql/connections.py", line 1269, in _get_server_information
self.server_charset = charset_by_id(lang).name
File "/Users/levy/wechat-admin/venv/lib/python3.7/site-packages/pymysql/charset.py", line 38, in by_id
return self._by_id[id]
KeyError: 255

[1980744819]

你找到解决办法了没

[kaishuibaicai]

/wechat-admin/venv/lib/python3.6/site-packages/pymysql/connections.py 里的链接mysql数据库默认登录密码是空的，需要找的connection的方法里填入你电脑里的mysql的登录密码，就可以初始化数据库了。