How to back up MySQL database?

[calvinphanctt]

Hello everyone,

I need to back up my database using this command:

mysqldump --opt -Q -u database_user -p database_name > mydatabase.sql

but it asked for the password, I enter the password for that database_user but it said :
mysqldump: Got error: 1045: Access denied for user 'timbanga_timbang'@'localhost' (using password: YES) when trying to connect.

What should I do? I enter password correctly though.

Sincerely,
Calvin

[cPanelTristan]

Hello Calvin,

You would need to either use the root user without passing the -p flag or the cPanel username user rather than the cPanel database username, so timbanga user's password for cPanel and MySQL instead:

mysqldump --opt -Q -u timbanga -p database_name > mydatabase.sql

[calvinphanctt]

Hi Tristan,

It doesn't work either. The same error message!

Please help! Thank you.

Regards,
Calvin

[cPanelTristan]

Did you try as the root user? Are you certain that is the MySQL username and password for that user? If it is the right MySQL password for the user, then this command will work:

mysql -u timbanga -p

When prompted for the password for the timbanga user, then enter it. If it lets you into MySQL, then the password is right. If it doesn't let you into MySQL, then that isn't the user's MySQL password.

[calvinphanctt]

Hello,

I even tried the password for user "root" but it still didn't work. I have the config file with the password I set, I guarantee it is correct but I don't know why it keeps giving that error message!



Please help.

Thank you.

Regards,
Calvin

[Infopro]

If it was me I think I'd just go to my cPanel, click this users name in Databases section and give him a new password and then try that password with my backup command. To troubleshoot, basically. If it works be sure to update that config file with the new password.

GL!

[cPanelTristan]

Can you even enter MySQL command line on the machine in question?

mysql

Please enter that in root SSH when logged in as the root user. If you receive an error, please indicate it here.

If you can log into that service, then open up a ticket. The root user when *not* passing the -p flag using mysqldump should always work if you are logged in as root. As such, if you tried as root user and did not pass the -p flag, it shouldn't have rejected the command. There's something wrong with MySQL if it did.