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
UPDATE user SET password=PASSWORD('YOUR_NEW_PASSWORD_HERE') WHERE user = 'root';
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.