SQL database bakup error

cPanel, Industry leading hosting platform with world-class support.
Post Reply
daleypws
Posts: 2
Joined: March 24th, 2023, 11:48 pm

SQL database bakup error

Post by daleypws »

I have backups set up, but they are only partially completing, All accounts with sql are not backing up the databases and have the following error:

[ERROR] Access denied for user 'root'@'localhost' (using password: YES)


I am very green with all this and appreciate any help to get this working.
BlessingLinys
Posts: 1
Joined: April 3rd, 2023, 12:19 pm

Re: SQL database bakup error

Post by BlessingLinys »

Make sure that you use the correct password for the "root" user in the backup settings file. Log into MySQL from the command line and run the following command to grant the user "root" rights: GRANT ALL PRIVILEGES ON . TO 'root'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION; The 'password' here is the password of the user "root". After that, restart MySQL and try to back up the databases again.
Last edited by BlessingLinys on April 14th, 2023, 3:06 pm, edited 2 times in total.
daleypws
Posts: 2
Joined: March 24th, 2023, 11:48 pm

Re: SQL database bakup error

Post by daleypws »

I had to set my MySQL® Root Password. I do not have any errors now that I did that and then made sure that the backups excluded suspended websites.

Thank you!
Post Reply