Mysqldump issue
I changed my Cpanel account password for the account associated with my https//:IP:2083 link and now my database backup script keeps failing with the error :
mysqldump: Got error: 1045: Access denied for user 'USER'@'localhost' (using password: YES) when trying to connect.
The credentials for this mysql user are still the same if I use them on the command line.
mysqldump --defaults-extra-file=CONFIG.FILE -uUSER DATABASE| gzip > file.sql.gz
This command has worked fine for years now, but after changing the password to the cpanel account, I can not seem to fix this issue. I did notice that cpanel placed my new username and password in the same config file that I use for mysqldump under a [client] line. I moved the config to a new place with the same permissions and removed the client section, and that did not seem to fix the problem either. Any ideas?
-
Hi, It seems that the issue with password or PRIVILEGES. First make sure the password is correct. You have to check using the following command. mysql -u USERNAME -p
after issuing the command it asks for a password.0 -
Hi, It seems that the issue with password or PRIVILEGES. First make sure the password is correct. You have to check using the following command.
mysql -u USERNAME -p
after issuing the command it asks for a password.
The grants and password are all exactly the same as they were before. I am able to log in to mysql using the original username and password from command line. I have enabled "GRANT SELECT, CREATE, REFERENCES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER" grants and they have worked just fine in the past0 -
please update your Cpanel account password via the WHM Root interface, then try 0 -
Hello, You can also try updating the MySQL user password if you prefer it to be different than the cPanel account password: "WHM Home " SQL Services " Change MySQL User Password" Thank you. 0
Please sign in to leave a comment.
Comments
4 comments