I installed automysqlbackup via the apt packager manager via
sudo apt install automysqlbackup.
sudo automysqlbackup worked fine with 14.04 but starting with 16.04, it doesn't work anymore once in mysql I do
update mysql.user set plugin='mysql_native_password' where user='root'; with Error
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
update mysql.user set plugin='unix_socket' where user='root'; will work with
sudo automysqlbackup, I created a new config file (automysqlbackup.conf) in hope that by specifiying a config file with needed entries I can amend this issue. But running
sudo automysqlbackup /etc/automysqlbackup/automysqlbackup.conf still outputs the same error
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO). As a result, somehow
sudo automyslbackup doesn't seem to take the config file into account. Do you guys have any clue why this is so?