Cron backup of MySQL database does not work anymore. Error: ★start backup[2024-09-19 14:26:56] (1045, "Access denied for user 'root'@'127.0.0.1' (using password: YES)&quot😉 (1045, "Access denied for user 'root'@'127.0.0.1' (using password: YES)&quot😉 |-Error：Failed to connect to database [localhost: 3306] |-Message sent successfully. |-The message notification has been sent. I have already done the following multiple times: Restart panel Pressed Fix button Set a new MySQL Root password and checked access via phpmyadmin etc. Initial FIX NOT WORKING: Delete cron and add again. but same error.

Try to add the root user and the host is 127.0.0.1, the password is the same as the host localhost aaP_crazykiddodk

Hi, can you give us your aapanel information? The server makes a snapshot backup first, if possible, please send it to kern@aapanel.com . It is recommended to fill in the following Post link: SSH IP address, account password and port: aapanel login link address and account password: Detailed problem description: No post link will not be able to know which user's information is, and the problem will not be processed aaP_crazykiddodk

This is not possible as I have clients secure information and live sites running. Where is the database backup information coming from? is it stored in DB?

Is it possible to take a screenshot of the phpmyadmin user? aaP_crazykiddodk

took a screenshot of the root user from phpmyadmin. Or you can take a screenshot of the root user of mysql aaP_crazykiddodk

but there is nothing there, all priv are Y and host set to localhost

Again everything works, sites, phpmyadmin even DB backup from Database list only Cron that does not

It seems like that worked, hmmm but how come since I have not changed anything with root user.

What version of aapanel are you using? aaP_crazykiddodk

Cron MySQL backup not working

aaPanel_Kern

Hello, have you tried resetting the root password?

takitzis

I found the problem.

When the databases created by AApanel gave privileges for user root only from localhost and not from 127.0.0.1
I had to do CREATE USER 'root'@'127.0.0.1' IDENTIFIED BY 'your_password';

The problem is that the cron job for some reason is using the host "127.0.0.1" while the individual backup from "Databases" section is using the "localhost".

Please fix it for the other users than may have the same problem.

« Previous Page