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 CreditAttribution: 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 🇨🇦
CreditAttribution: ergonlogic 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 CreditAttribution: helmo at Initfour websolutions commented
Status: Postponed (maintainer needs more info) » Fixed

Status: Fixed » Closed (fixed)

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