Django: mysql: 1045, “Access denied to user

I have the whole setup working for months on my local computer.

I’m installing on a remote site now.

Created a fresh mysql DB, and created a new user (“someuser”) and gave it complete grants, like so –

GRANT ALL PRIVILEGES ON .
TO ‘someuser’@’localhost’ IDENTIFIED BY ‘somepassword’ WITH GRANT OPTION;

I have sync’d the db, using “python manage.py syncdb” and the correct tables were created. My settings.py has this same user.

But when I try to login a user through the application, and it hits the DB, I see the following in the logs –

(1045, "Access denied for user 'someuser'@'localhost' (using password: YES)")

I logged in through mysql (installed on the same box as django) and checked the grants and it correctly shows –

Grants for[email protected]

GRANT ALL PRIVILEGES ON * . * TO ‘someuser’@’localhost’ IDENTIFIED BY PASSWORD ‘*thesaltedpasswordOverHere’ WITH GRANT OPTION

I don’t want to use the root user/password for django, since it doesn’t seem the correct way.

Any pointers as to what might be wrong ?

I do it like this for a database named foo_db:

create database foo_db;
create user foo_user identified by 'foo_password';
grant all on foo_db.* to 'foo_user'@'%';
flush privileges;
Hello, buddy!稿源:Hello, buddy! (源链) | 关于 | 阅读提示

本站遵循[CC BY-NC-SA 4.0]。如您有版权、意见投诉等问题,请通过eMail联系我们处理。
酷辣虫 » 综合编程 » Django: mysql: 1045, “Access denied to user

喜欢 (0)or分享给?

专业 x 专注 x 聚合 x 分享 CC BY-NC-SA 4.0

使用声明 | 英豪名录