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.
SQL database bakup error
-
- Posts: 1
- Joined: April 3rd, 2023, 12:19 pm
Re: SQL database bakup error
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.
Re: SQL database bakup error
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!
Thank you!