|-Error：Database export failed! |-mysqldump: Got error: 1045: "Access denied for user 'root'@'localhost' (using password: NO)" when trying to connect I find some topics on forum but i still can't find solution. Anyone know how to fix this problem?

aaP_chanlynguyen94 Hello, it shows that the root password of the database is incorrect. Have you used other tools or commands to change the root password. Try to reset the root password in the databases interface of the panel.

I tried resetting the password in the database interface but it still doesn't work.

aaP_chanlynguyen94 Can log in if try to use phpmyadmin? Or use the command line

Yes, i can still login to phpmyadmin with that root password.

aaP_chanlynguyen94 Hello, have you solved the problem? If not, check whether the mysql user information is normal Execute the query task after logging in to MySQL select user,host from mysql.user;

|-Error：Database export failed! Traceback (most recent call last): File "/www/server/panel/plugin/gdrive/gdrive_main.py", line 675, in <module> q.execute_command(sys.argv) File "/www/server/panel/plugin/gdrive/gdrive_main.py", line 631, in execute_command save=int(args[3])) File "class/panelBackup.py", line 680, in backup_database self.send_failture_notification(error_msg, target=db_name) File "class/panelBackup.py", line 873, in send_failture_notification title = self.generate_failture_title() TypeError: generate_failture_title() missing 1 required positional argument: 'task_name' getting this error when my corn job runs to backup the database.... used to run previously good, but after panel update it has stopped running . thou site backup is occurring good. having the issue just with database backup.

Hello, what is the version of your panel? Does trying to fix the panel fix it? Does trying to add a new task fix it? angelTDW

current panel verison: 6.8.29 havent tried to run the fix command. also tried to add new task for database backup but same thing.

just ran the fix and pressed ctrl+f5 still the same issue... should I restart the server and check?

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: No post link will not be able to know which user's information is, and the problem will not be processed angelTDW

Database cron backup failed (google drive)

aaPanel_Kern

Go to the server provider's website to find

angelTDW

checked teh hosting site, they have created a snapshot, but I am only able to restore or delete snapshot, not download snapshot.

so, should I send u my servers access on mail?

aaPanel_Kern

yes

angelTDW

mail zsent. do check it.. and revert.
also tried to restart the server but it didn't helped,.

angelTDW

still gettting the error...

|-Error：Database export failed!
|-mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect

thou I have enabled root password in ssh

aaPanel_Kern

Hello, please check if the root password of the database interface is correct? If not correct try resetting the root password

angelTDW

aaPanel_Kern

aaPanel_Kern Hello, please check if the root password of the database interface is correct? If not correct try resetting the root password

Is it possible to log in using phpmyadmin? Can the information of the root user of the database be screenshotted?

angelTDW

ok will check it again, yesterday when I checked, it was correct... but still it was showing error....

angelTDW

i am able to login to the root with the password....
but still getting the same error in corn job...
just tested.
should I restart the server..and see?

angelTDW

also, letting the root authentication to be accessible isn't a security risk?

angelTDW

yes, i am able to login to phpmyadmin using the root password successfully.
user: root
pass: my password.
but still the script is showing error.

aaPanel_Kern

angelTDW
Is it normal to try to change the root password on the database interface and then create a database?

angelTDW

aaPanel_Kern didn't get it kern.
What are you saying.

aaPanel_Kern

angelTDW

« Previous Page