Backup Fail - mysql login problem

[lucio3011 (lucio_alfonso)]

NethServer Version: NethServer release 7.7.1908 (final)
Module: Backup

Hi when I make the backup on a NFS Drive I received this error messages.

Apr 9 20:13:23 qcs-nethserver esmith::event[2276]: Action: /etc/e-smith/events/pre-backup-data/S20nethserver-backup-config-predatabackup SUCCESS [20.016452]
Apr 9 20:13:23 qcs-nethserver esmith::event[2276]: ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)
Apr 9 20:13:23 qcs-nethserver esmith::event[2276]: Action: /etc/e-smith/events/pre-backup-data/S50mysql-dump-tables FAILED: 1 [0.330849]

Does anyone have any ideas how I can solve this problem?

[mrmarkuz (Markus Neuberger)]

Did you change your mysql root password?

If yes, please set it back to the one you find in /root/.my.cnf or /var/lib/nethserver/secrets/mysql.

[lucio3011 (lucio_alfonso)]

Hi Markuz
Many thanks for your anwer.

can you give me the right way to change the root password ?

I found the password with cat /root/.my.cnf

Thanks a lot,

#stay@home

[mrmarkuz (Markus Neuberger)]

Here is the solution for similar problem:

DataBackup Fails

Hi @Jimbo You have changed you root password and backup can’t work. I suggest you to reset your root password and create an admin account to manage your database (e.g. with phpmyadmin). Follow this procedure: grep password .my.cnf Copy this password and then launch this commands: service mysqld stop mysqld_safe --skip-grant-tables & mysql FLUSH PRIVILEGES; set password for 'root'@'localhost' = PASSWORD('yourcopiedpwd'); And then: service mysqld stop service mysqld start If from ser…

Other ways of (re)setting the mariadb root password:

Using phpmyadmin.

Nethserver-glpi needs testers

Copy your new password inside /var/lib/nethserver/secretes/mysql then execute: /etc/e-smith/events/actions/system-adjust Pray that everything will be automatically fixed

Howto install guacamole

Please try this and enter the actual root password: mysqladmin -p password UY4_FzRrsMYs7D1q Now you should be able to login to mysql without password.