Hello, I have a problem with database backup. |-Error：Database export failed! |-mysqldump: Got error: 1045: "Access denied for user 'root'@'localhost' (using password: NO)" when trying to connect I recreated the backup task, same error. Thanks

manpovver Do you use cron to back up the database? What is your database version?

aaPanel_Jose aaPanel_Jose Do you use cron to back up the database? Yes. aaPanel_Jose What is your database version? MySQL 10.4.12-MariaDB

manpovver Repair panel can solve the problem that mariadb10.4 cannot reset the root password After trying to repair the panel, reset the mysql root password before performing the backup

Tha same error after update+repair |-Error：Database export failed! |-mysqldump: Got error: 1045: "Access denied for user 'root'@'localhost' (using password: NO)" when trying to connect

manpovver can i login your panel to check? please send the panel login info to jose@aapanel.com if you allow

aaPanel_Jose i have the same problem: |-Error：Database export failed! |-mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect 1- I use cron to back up the database, and the Database is MySQL 5.7.31. so that I can start back to back up the database I always have to restart mysql and it works again but that has to be done every day and it is not safe for a backup.

angelitoflow Please check whether the mysql root password is empty or 'admin' on the database page, and can you post your mysql configuration file for me to see?

Database export failed

angelitoflow

aaPanel_Jose the root password is fine, mysql always works again when I restart it, it works fine for one day and suddenly stops working until I restart it one more time.

aaPanel_Jose

angelitoflow
Please check if your RAM usage has been overloaded?
Or provide your mysql err log.

angelitoflow

aaPanel_Jose this is the Mysql error log
https://nublado.online/error.txt

aaPanel_Jose

angelitoflow
Is the log you are here? Did not see any useful error message
/www/server/data/your_hostname.err

angelitoflow

aaPanel_Jose Hi Jose Please Help me with this error, it always keeps happening. even install everything new on a new server just migrate the data from the web and everything remains the same.
/www/server/data/your_hostname.err here -- https://nublado.online/error.txt

angelitoflow

aaPanel_Jose

angelitoflow
It seems that the problem is caused by the lack of a password when backing up the panel. Can I log in to your panel to check it? If possible, please send the panel login information to jose@aapanel.com

angelitoflow

aaPanel_Jose I send the email Jose

idyahia

Hello

i have i think the same error, i can't backup mysql database from php my admin or from CMD, please help me solve this issue

idyahia

jazz1611

@idyahia
did you have try export database via SSH command ?

idyahia

jazz1611 yes but no luck

jazz1611

idyahia
what error report?

idyahia

jazz1611

Hi Jazz,

You can find attached the error report

jazz1611

idyahia
hello, please try add this parameter "--no-tablespaces". if not work try with "--column-statistics=0 --no-tablespaces"
source: https://dba.stackexchange.com/questions/271981/access-denied-you-need-at-least-one-of-the-process-privileges-for-this-ope

aaPanel_thisyear

Hello, under the root user, the server command line needs to execute the above command to give the next process permission. The statement is as follows:
grant reload on *.* to 'test'@'localhost';