TurnKey Linux Virtual Appliance Library

After update mysql failed

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

Known Ubuntu bug

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

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account, used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <strike> <caption>

More information about formatting options

Leave this field empty. It's part of a security mechanism.
(Dear spammers: moderators are notified of all new posts. Spam is deleted immediately)