Search Engine: Elastic

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

  • Applies to:
  • Plesk Automation


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:

  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

e0aff7830fa22f92062ee4db78133079 caea8340e2d186a540518d08602aa065

Email subscription for changes to this article
Save as PDF