配置文件:
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'OPTIONS': {
'read_default_file': '/www/wwwroot/DeerU/my.cnf',
},
}
}
my.cnf文件
my.cnf 文件
[client]
database = deeru
user = deeru
password = z4i
default-character-set = utf8mb4
报错
初始化中:
同步数据库修改 ...
同步数据库修改 ... [失败],更多信息查看 ./log/init.log
Traceback (most recent call last):
File "/www/wwwroot/DeerU/DeerU_venv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 217, in ensure_connection
self.connect()
File "/www/wwwroot/DeerU/DeerU_venv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 195, in connect
self.connection = self.get_new_connection(conn_params)
File "/www/wwwroot/DeerU/DeerU_venv/lib/python3.6/site-packages/django/db/backends/mysql/base.py", line 227, in get_new_connection
return Database.connect(**conn_params)
File "/www/wwwroot/DeerU/DeerU_venv/lib/python3.6/site-packages/MySQLdb/init.py", line 84, in Connect
return Connection(*args, **kwargs)
File "/www/wwwroot/DeerU/DeerU_venv/lib/python3.6/site-packages/MySQLdb/connections.py", line 179, in init
super(Connection, self).init(*args, **kwargs2)
MySQLdb._exceptions.OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: NO)")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "./manage.py", line 28, in
execute_from_command_line(sys.argv)
File "/www/wwwroot/DeerU/DeerU_venv/lib/python3.6/site-packages/django/core/management/init.py", line 381, in execute_from_command_line
utility.execute()
File "/www/wwwroot/DeerU/DeerU_venv/lib/python3.6/site-packages/django/core/management/init.py", line 375, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/www/wwwroot/DeerU/DeerU_venv/lib/python3.6/site-packages/django/core/management/base.py", line 323, in run_from_argv
self.execute(*args, **cmd_options)
File "/www/wwwroot/DeerU/DeerU_venv/lib/python3.6/site-packages/django/core/management/base.py", line 364, in execute
output = self.handle(*args, **options)
File "/www/wwwroot/DeerU/app/management/commands/init_deeru.py", line 53, in handle
management.call_command('migrate', stdout=f)
File "/www/wwwroot/DeerU/DeerU_venv/lib/python3.6/site-packages/django/core/management/init.py", line 148, in call_command
return command.execute(*args, **defaults)
File "/www/wwwroot/DeerU/DeerU_venv/lib/python3.6/site-packages/django/core/management/base.py", line 364, in execute
output = self.handle(*args, **options)
File "/www/wwwroot/DeerU/DeerU_venv/lib/python3.6/site-packages/django/core/management/base.py", line 83, in wrapped
res = handle_func(*args, **kwargs)
File "/www/wwwroot/DeerU/DeerU_venv/lib/python3.6/site-packages/django/core/management/commands/migrate.py", line 87, in handle
executor = MigrationExecutor(connection, self.migration_progress_callback)
File "/www/wwwroot/DeerU/DeerU_venv/lib/python3.6/site-packages/django/db/migrations/executor.py", line 18, in init
self.loader = MigrationLoader(self.connection)
File "/www/wwwroot/DeerU/DeerU_venv/lib/python3.6/site-packages/django/db/migrations/loader.py", line 49, in init
self.build_graph()
File "/www/wwwroot/DeerU/DeerU_venv/lib/python3.6/site-packages/django/db/migrations/loader.py", line 212, in build_graph
self.applied_migrations = recorder.applied_migrations()
File "/www/wwwroot/DeerU/DeerU_venv/lib/python3.6/site-packages/django/db/migrations/recorder.py", line 73, in applied_migrations
if self.has_table():
File "/www/wwwroot/DeerU/DeerU_venv/lib/python3.6/site-packages/django/db/migrations/recorder.py", line 56, in has_table
return self.Migration._meta.db_table in self.connection.introspection.table_names(self.connection.cursor())
File "/www/wwwroot/DeerU/DeerU_venv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 256, in cursor
return self._cursor()
File "/www/wwwroot/DeerU/DeerU_venv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 233, in _cursor
self.ensure_connection()
File "/www/wwwroot/DeerU/DeerU_venv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 217, in ensure_connection
self.connect()
File "/www/wwwroot/DeerU/DeerU_venv/lib/python3.6/site-packages/django/db/utils.py", line 89, in exit
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/www/wwwroot/DeerU/DeerU_venv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 217, in ensure_connection
self.connect()
File "/www/wwwroot/DeerU/DeerU_venv/lib/python3.6/site-packages/django/db/backends/base/base.py", line 195, in connect
self.connection = self.get_new_connection(conn_params)
File "/www/wwwroot/DeerU/DeerU_venv/lib/python3.6/site-packages/django/db/backends/mysql/base.py", line 227, in get_new_connection
return Database.connect(**conn_params)
File "/www/wwwroot/DeerU/DeerU_venv/lib/python3.6/site-packages/MySQLdb/init.py", line 84, in Connect
return Connection(*args, **kwargs)
File "/www/wwwroot/DeerU/DeerU_venv/lib/python3.6/site-packages/MySQLdb/connections.py", line 179, in init
super(Connection, self).init(*args, **kwargs2)
django.db.utils.OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: NO)")