我刚刚在mac系统中安装了mysql,并为mysql数据库配置了Djangosettings.py
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': '/usr/local/mysql-8.0.23-macos10.15-x86_64/data/takeawaywebshop', #changed in production
'USER': data['mysql']['username'],
'PASSWORD': data['mysql']['password'],
'HOST': '',
'PORT': '',
}
}
当我从manage.py启动下面的调用dbshell的命令时,我收到一个错误,指出数据库访问拒绝
python manage.py dbshell
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1044 (42000): Access denied for user 'jianwu'@'localhost' to database '/usr/local/mysql-8.0.23-macos10.15-x86_64/data/takeawaywebshop'
CommandError: "mysql --user=jianwu --password=xxxxxx /usr/local/mysql-8.0.23-macos10.15-x86_64/data/takeawaywebshop" returned non-zero exit status 1.
你知道我错过了什么吗?
通过在不提供完整路径的情况下将settings.py
中的'NAME'更改为takeawaywebshop
来修复此问题。