So I rented this server with Debian 7, and wanted to install a webserver, and followed the following tutorial:


And I'm now stuck at the PHPMyAdmin part. Probably the problem is that I tried to install PHPMyAdmin before changing the root password.

So I purged PHPMyAdmin, and currently the problem is that I'm unable to login at all to mysql. So to break it down, the command:

mysql -h localhost -u root -p

asks me for a password, and the password ALWAYS doesn't work. So I started searching for a solution, and found this one here:


So I reset the password using the mysql-command


like a gillion times... and the new password never works! I tried also to flush privileges after the password reset... but no use.

Please advise. This is the first time setting my own server.

Thank you for any efforts.

  • did you first kill the mysql daemon – Gaurav Joseph Jan 18 '14 at 11:31
  • @GauravJoseph Of course, and started the safe-mode – The Quantum Physicist Jan 18 '14 at 11:37
  • You might want to try FLUSH PRIVILEGES after the UPDATE command – Gaurav Joseph Jan 18 '14 at 11:59
  • @GauravJoseph I did that... in fact it's mentioned in the post... – The Quantum Physicist Jan 18 '14 at 12:03
  • Did it 3 times now worked every time. – Gaurav Joseph Jan 18 '14 at 12:04

Thanks to Gaurav, it works now. It turns out that the default root user name was "admin" and not "root".

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.