(resolved) Cannot log in to the MySQL server

General Discussion
1

Hello,
I’m continuing experimenting and just installed LAMP.

I had previously changed HostName and Password and when trying to log into
phpmyadmin interface I cannot access with root and either of the two passwords:
raspberry the default one and the new one I set up.

Is there a short way to solve this? I’m starting googling around…

Many thanks for any hint you might give me,
Virgus

2

I just added the line in /etc/phpmyadmin/config.inc.php

$cfg['Servers'][$i]['host'] = '127.0.0.1';

under /* Authentication type / → / Server parameters */
and it works now with the original “raspberry” password.

3

Hi Virgus,

I followed your steps:

  • Installed LAMP + PHPMYADMIN
  • changed the hostname and root password.
  • rebooted

I can still login fine to phpmyadmin using root / raspberry. So i’am not sure why you were required to add the localhost addition.
Also, the phpmyadmin password is unique and can only be changed inside phpmyadmin.