Task "Install additional packages on node 'ppa.database.tld' according role PPA_MYSQL" failed with error below:
[INFO] Drop test database... [INFO] mysql -uroot -e'drop database test' [INFO] Unable to drop test database... [INFO] Remove default anonymous MySQL user accounts......` [INFO] mysql -uroot mysql -e'delete from db;delete from user where not (host="localhost" and user="root");flush privileges' ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) [ERROR] Unable to remove default anonymous MySQL user accounts...
Service node was registered with database user "root", this is temporary user and should not be used.
To fix the issue:
Login to the database service node
Restart MySQL server with
Remove password for user root:
mysql>update user set Password=NULL where User='root' and Host='localhost';
skip-grant-tablesoption and restart MySQL server.
Restart failed task