我已经阅读了两天的很多堆栈溢出问题,但是我无法弄清楚问题所在(我使用的是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/

10-12 12:30
查看更多