Please contact your support team if you have a question or need assistance for any Rackspace products, services, or articles.
This is probably a noob question, but I just created a MySQL user using phpMyAdmin (backups@localhost), but that user is having issues logging in to MySQL via the shell
using mysqldump commandmysqldump: Got error: 1045: Access denied for user 'backups'@'localhost' (using password: YES) when trying to connect
using mysql command: ERROR 1045 (28000): Access denied for user 'backups'@'localhost' (using password: YES)
I've searched all over the internet, but no solutions seem to work. I've flushed the privileges, I have no anonymous users, and still can't get them to login. The only user that can login is root. root has a password, and root can login anywhere just fine
Any other suggestions are appreciated.
A huge thank you to @damon__jones on twitter who discovered it was an issue with how the passwords were hashed by phpMyAdmin.
The solution was to create the user without a password and then set it manually via SQL commands using
SET PASSWORD FOR 'backups'@'localhost' = PASSWORD('newpass');
which will hash it using the new format - this now lets me login correctly from anywhere with this user.
, This is a great article. It gave me a lot of useful information. thank you very much. Link profile: http://phongkhamdakhoathegioi.vn/hien-tuong-ngua-hau-mon-vao-ban-dem-la-benh-gi.html
Giặt nệm tại nhà là nhu cầu của rất nhiều gia đình Việt. Đặc biệt là trong thời buổi cuộc sống bộn bề công việc, không phải ai cũng có đủ thời gian & kỹ thuật để giặt nệm sạch sẽ.
Thanks for your share. It gave me a lot of useful information
Thanks for your shares. It's so helpful