EasyPHP: mySQL/PHPmyAdmin does not work anymore after setting root user password - Plugin '*8AA9864C904BBB2AC83C09FA1004AC23FB18F4E8' is not loaded

Question

This what happened in a local developer installation of EasyPHP:

1. i set the password trough PHPmyAdmin for the root user (because i need to have a password for a new user and it seems that if the root has no a password defined the password for new users is not saved)

2. in the config file config.inc.php I set the password as defined

      /* Authentication type */
      $cfg['Servers'][$i]['auth_type'] = 'config';
      $cfg['Servers'][$i]['user'] = 'root';
      $cfg['Servers'][$i]['password'] = 'Soksunae123';
      /* Server parameters */
      $cfg['Servers'][$i]['host'] = '127.0.0.1';
      $cfg['Servers'][$i]['connect_type'] = 'tcp';
      $cfg['Servers'][$i]['compress'] = false;
      /* Select mysql if your server does not have mysqli */
      $cfg['Servers'][$i]['extension'] = 'mysqli';
      $cfg['Servers'][$i]['AllowNoPassword'] = true;
      $cfg['Servers'][$i]['hide_db'] = '(mysql|information_schema|performance_schema|test|phpmyadmin)';

3. i restarted all the servers (and also, since it didn't work, i rebooted the windows system)

4. when i try to run PHPmyAdmin i get this error

5. if I try to access by console i get the same error "#1524 - Plugin '*8AA9864C904BBB2AC83C09FA1004AC23FB18F4E8' is not loaded" obviously after editing the password

6. looking to the settings of PHPmyAdmin in EasyPHP main page it seems the pw is not set for root user (but it could be not true since when accessing by console i get the same error using the right pw)

any ideas? thanks.

Answer 1

MySQL has a setting for every login where you can control what hosts that user can use to login. It's possible that when you set the root password, you might have also changed the allowed hosts to "%" (All Hosts), which blocks local login (your phpMyAdmin instance is probably running on the local machine). See this answer for a possible explanation as to why this occurs (I'm pretty sure it's right).

In a shell on the local server, try this to login as root with a password:

shell> mysql -u root -p
Enter Password:
Access denied for user 'root'@'localhost' (using password: YES)

If you see that last line, and you're sure you're using the correct password, it likely means that the root account can only logon from TCP, not local socket. You can explicitly connect over TCP with this syntax:

mysql -u root -p --host=127.0.0.1

If the loopback (127.0.0.1) address doesn't work, try your LAN IP instead. Once you're in, you can add a second root login that can only login from localhost, and optionally set the same (or a different) password. Docs on account management via SQL commands.

More help in the connection troubleshooting docs.