转model时报错
来源:7-3 自动生成model

前辈贝贝
2023-02-14
(venv) PS F:\Pythonfiles\ericsson> flask-sqlacodegen “mysql://root:Lj_123456@192.168.188.128/mysql” --tables user --outfile “common/models/user.py” --flask
Traceback (most recent call last):
File “F:\Pythonfiles\ericsson\venv\lib\site-packages\sqlalchemy\engine\base.py”, line 1964, in _exec_single_context
self.dialect.do_execute(
File “F:\Pythonfiles\ericsson\venv\lib\site-packages\sqlalchemy\engine\default.py”, line 747, in do_execute
cursor.execute(statement, parameters)
File “F:\Pythonfiles\ericsson\venv\lib\site-packages\MySQLdb\cursors.py”, line 206, in execute
res = self._query(query)
File “F:\Pythonfiles\ericsson\venv\lib\site-packages\MySQLdb\cursors.py”, line 319, in _query
db.query(q)
File “F:\Pythonfiles\ericsson\venv\lib\site-packages\MySQLdb\connections.py”, line 254, in query
_mysql.connection.query(self, query)
MySQLdb.OperationalError: (1049, “Unknown database ‘Engine(mysql://root:***@192.168.188.128/mysql)’”)
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File “C:\Users\Administrator\AppData\Local\Programs\Python\Python310\lib\runpy.py”, line 196, in _run_module_as_main
return _run_code(code, main_globals, None,
File “C:\Users\Administrator\AppData\Local\Programs\Python\Python310\lib\runpy.py”, line 86, in run_code
exec(code, run_globals)
File "F:\Pythonfiles\ericsson\venv\Scripts\flask-sqlacodegen.exe_main.py", line 7, in
File “F:\Pythonfiles\ericsson\venv\lib\site-packages\sqlacodegen\main.py”, line 57, in main
metadata.reflect(engine, args.schema, not args.noviews, tables)
File “F:\Pythonfiles\ericsson\venv\lib\site-packages\sqlalchemy\sql\schema.py”, line 5466, in reflect
insp.get_table_names(schema)
File “F:\Pythonfiles\ericsson\venv\lib\site-packages\sqlalchemy\engine\reflection.py”, line 397, in get_table_names
return self.dialect.get_table_names(
File “”, line 2, in get_table_names
File “F:\Pythonfiles\ericsson\venv\lib\site-packages\sqlalchemy\engine\reflection.py”, line 97, in cache
ret = fn(self, con, args, kw)
File “F:\Pythonfiles\ericsson\venv\lib\site-packages\sqlalchemy\dialects\mysql\base.py”, line 2885, in get_table_names
rp = connection.exec_driver_sql(
File “F:\Pythonfiles\ericsson\venv\lib\site-packages\sqlalchemy\engine\base.py”, line 1772, in exec_driver_sql
ret = self._execute_context(
File “F:\Pythonfiles\ericsson\venv\lib\site-packages\sqlalchemy\engine\base.py”, line 1842, in _execute_context
return self._exec_single_context(
File “F:\Pythonfiles\ericsson\venv\lib\site-packages\sqlalchemy\engine\base.py”, line 1983, in _exec_single_context
self._handle_dbapi_exception(
File “F:\Pythonfiles\ericsson\venv\lib\site-packages\sqlalchemy\engine\base.py”, line 2325, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File “F:\Pythonfiles\ericsson\venv\lib\site-packages\sqlalchemy\engine\base.py”, line 1964, in _exec_single_context
self.dialect.do_execute(
File “F:\Pythonfiles\ericsson\venv\lib\site-packages\sqlalchemy\engine\default.py”, line 747, in do_execute
cursor.execute(statement, parameters)
File “F:\Pythonfiles\ericsson\venv\lib\site-packages\MySQLdb\cursors.py”, line 206, in execute
res = self._query(query)
File “F:\Pythonfiles\ericsson\venv\lib\site-packages\MySQLdb\cursors.py”, line 319, in _query
db.query(q)
File “F:\Pythonfiles\ericsson\venv\lib\site-packages\MySQLdb\connections.py”, line 254, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (1049, "Unknown database 'Engine(mysql://root:@192.168.188.128/mysql)’")
[SQL: SHOW FULL TABLES FROM Engine(mysql://root:***@192.168.188.128/mysql)
]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
1回答
-
编程浪子
2023-05-24
您好
您这个报错已经很明显了,应该是配置的有问题,如下的
一般本地的ip我们用127.0.0.1
然后就是确认下用户名和密码是不是对的,如果还有问题麻烦加我:1586538192
mysql://root:Lj_123456@192.168.188.128/mysql
00
相似问题