aaPanel_Jose 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
manpovver 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
aaPanel_Jose manpovver can i login your panel to check? please send the panel login info to jose@aapanel.com if you allow
angelitoflow 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.
aaPanel_Jose 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?
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.
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 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
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
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
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
