Article ID: 118585, created on Nov 12, 2013, last review on May 1, 2014

  • Applies to:
  • Plesk Automation

Symptoms

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...

Cause

Service node was registered with database user "root", this is temporary user and should not be used.

Resolution

To fix the issue:

  1. Login to the database service node

  2. Restart MySQL server with skip-grant-tables option

  3. Remove password for user root:

    mysql>update user set Password=NULL where User='root' and Host='localhost';
    
  4. Remove skip-grant-tables option and restart MySQL server.

  5. Restart failed task

Search Words

install additional packages according role PPA_MYSQL failed

Unable to remove default anonymous MySQL user accounts

e0aff7830fa22f92062ee4db78133079 caea8340e2d186a540518d08602aa065

Email subscription for changes to this article
Save as PDF