(resolved) Cannot log in to the MySQL server

Have some feedback, questions, suggestions, or just fancy a chat? Pop it in here.
Locked
Virgus

(resolved) Cannot log in to the MySQL server

Post by Virgus »

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
Virgus

Re: #2002 Cannot log in to the MySQL server

Post by Virgus »

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

Code: Select all

$cfg['Servers'][$i]['host'] = '127.0.0.1';
under /* Authentication type */ -> /* Server parameters */
and it works now with the original "raspberry" password.
User avatar
Fourdee
Site Admin
Posts: 2788
Joined: Tue Feb 06, 2007 1:36 pm

Re: #2002 Cannot log in to the MySQL server

Post by Fourdee »

Virgus wrote: 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.
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.
If you find our project or support useful, then we’d really appreciate it if you’d consider contributing to the project however you can.
Donating is the easiest – you can use PayPal or become a DietPi patron.
Locked