我已经阅读了两天的很多堆栈溢出问题,但是我无法弄清楚问题所在(我使用的是Mac)。
我做了:mysql -u root -p
。
因此,它要求输入密码,而root密码为空,不仅输入将我带入mysql监视器,而且还收到了以下消息:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is xxx
Server version: 5.7.18 Homebrew
然后:
mysql> CREATE DATABASE concon CHARACTER SET utf8;
。因此:
mysql>CREATE USER 'concon'@'localhost' IDENTIFIED BY 'thepassword';
。最后:
mysql> GRANT ALL ON concon.* TO 'concon'@'localhost'
。所以我退出mysql并运行
sudo python manage.py runserver
问题是我收到:
django.db.utils.OperationalError: (1045, "Access denied for user 'concon'@'localhost' (using password: YES)")
我的数据库是(在settings.py中):
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'concon',
'USER': 'concon',
'PASSWORD': 'thepassword',
'HOST': 'localhost',
'PORT': '',
}
}
当我这样做时:
SHOW GRANTS FOR 'concon'@'localhost';
表明:
+------------------------------------------------------------+
| Grants for concon@localhost |
+------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'concon'@'localhost' |
| GRANT ALL PRIVILEGES ON `concon`.* TO 'concon'@'localhost' |
+------------------------------------------------------------+
最佳答案
试试这个命令:
“ mysql>冲洗特权;”
在您授予用户特权之后
关于python - Django:1045,“用户被拒绝访问,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/44461296/