Forum: 

After update mysql failed

raymccoy's picture

Hello i used the turnkey lamp appliance. I set a root password i installed and configured some cms and all was running fantastic. Then i did an update installed an nfs server and now i got the error:

sudo /etc/init.d/mysql restart
 * Stopping MySQL database server mysqld                                 [fail]
 * Starting MySQL database server mysqld                                 [ OK ]
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'

so how can i repair this ? it seems that the upate  has written a new password to /etc/mysql/debian.cnf

i tried to repair this but i can't login to the mysql server with my known root password.

 

Anyone can tell me the steps to solve this.

 

Liraz Siri's picture

The update overwrote your /etc/mysql/debian.cnf with a new debian-sys-maint password without actually changing the password in MySQL. This is a known Ubuntu bug, see the launchpad bug report for more information.

Post new comment