• Support
  • Database backup not working in cron job.

|-Start backup[2023-07-05 13:35:39]

|-Backup database:sql_ptcare_co_kr
|-Database size: 23.70 MB
|-Database character set: utf8
|-Partition / available disk space is: 613.73 GB, available Inode is: 59174894

|-Start exporting database: 2023-07-05 13:35:39

|-Error:Database export failed!

|-mysqldump: Got error: 1045: "Access denied for user 'root'@'localhost' (using password: YES)" when trying to connect

Checking the database backup error log in cron shows the above. When I searched, it said that I had to enter the database loose password, so I checked and it was entered.
Even with phpmyadmin, login to the root and user DB accounts works fine.

The backup worked fine until June 23rd, but it doesn't work after that. Where should I check?

  • aaPanel_Kern replied to this.
  • aaP_master0
    Hello, the log shows that the password is wrong, did you change the password using the command line or phpmyadmin?
    Can you try to change the root password on the database interface and log in with the new password?

    aaP_master0
    Hello, the log shows that the password is wrong, did you change the password using the command line or phpmyadmin?
    Can you try to change the root password on the database interface and log in with the new password?

      aaPanel_Kern
      When I go to the backup folder, it is actually being backed up, but in the database menu, there is no backup file or backups after June 23rd are not visible.


      a year later

      Same issue here, and after changing root PW phpadmin works with new PW but cron backup still gives same error