Page 1 of 1

SQL database bakup error

Posted: March 31st, 2023, 2:41 am
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.

Re: SQL database bakup error

Posted: April 3rd, 2023, 12:40 pm
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.

Re: SQL database bakup error

Posted: April 7th, 2023, 5:19 pm
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!