I am on Ubuntu 14.04
My system was upgraded a few days ago.
Now for every command from deleting to creating a site fails.

I get this:
SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: NO)

I am also getting this now:
sudo mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

but i can loggin once I enter my password
sudo mysql -u root -p
Enter password: xxxxxx
>mysql

any thoughts on how to troubleshoot to give you more detail?

Comments

helmo’s picture

helmo commented

Could it be that the password stored by aegir is lost? You could try to edit the server node (usually node/2), enter the correct password. And let provision re-verify it.

ergonlogic’s picture

ergonlogic
he/him
Primary language English
Location Montréal, Québec 🇨🇦
commented
Category: Bug report » Support request
Status: Active » Postponed (maintainer needs more info)

Check in the db server context, which would normally be found at /var/aegir/.drush/server_localhost.alias.drushrc.php. The 'master_db' field ought to have the proper credentials. If not, update them there, and tasks should work again.

If sudo mysql -u root used to work for you, then you must have the db password in your ~/.my.cnf. Perhaps the db password changed?

helmo’s picture

helmo commented
Status: Postponed (maintainer needs more info) » Fixed

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.