Good day members.
Created a database, created a table " user " spent scripts on it.
I decided to change the passwords enter the link description here :
I went to the “ Privileges ” tab, there is one user with different “Host”. In the user where host = 127.0.0.1 - I changed the password ( Edit privileges -> Change password ) to my own.
After changing the password of the user with host = localhost, the message “ The password for“ root ”@” localhost ”was changed successfully appears, then when selecting the same database, the message“ loading ”appears and the program DEPENDS .
If you do not wait for the message to disappear and update phpMyAdmin, then it does not load and throws an error:

«MySQL said: Documentation Cannot connect: invalid settings. Connection for controluser as defined in your configuration failed. phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.»

MySQL overload does not help
What am I doing wrong?

opened the file " ... \ home \ localhost \ www \ Tools \ phpmyadmin \ config.inc.php " made replacements ['password'] and ['AllowNoPassword']:

 CollapsedWrap disabledLine numbers off $i++; /* Authentication type */ $cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = 'root'; // MySQL user $cfg['Servers'][$i]['password'] = '58fvcjm3ew0fvke8iudcuj'; // MySQL password (only needed $cfg['Servers'][$i]['AllowNoPassword'] = false;

launched MySQL (Endels) error (phpMyAdmin):

 "MySQL said: Documentation Cannot connect: invalid settings. phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server."
  • Is the cfg ['Servers'] [$ i] ['controluser'] line commented out? If not, what is written in it? Tried to restart the MySQL server? - cheops
  • The line is not commented out: / * User for advanced features * / $ cfg ['Servers'] [$ i] ['controluser'] = 'root'; $ cfg ['Servers'] [$ i] ['controlpass'] = ''; . I have Endels, which I reboot, which I reboot every time after changing the parameters. - Konstantin78

1 answer 1

The fact is that controluser is used to manage the database for servicing phpMyAdmin. He basically can work without this database. Moreover, if you changed the login type to the config, you can use the default user to manage the phpMyAdmin database. It is best to comment out the following lines of config.inc.php

 // $cfg['Servers'][$i]['controlhost'] = ''; // $cfg['Servers'][$i]['controlport'] = ''; // $cfg['Servers'][$i]['controluser'] = 'pma'; // $cfg['Servers'][$i]['controlpass'] = 'pmapass';
  • Lines * // $ cfg ['Servers'] [$ i] ['controlhost'] = ''; // $ cfg ['Servers'] [$ i] ['controlport'] = ''; * was not in the file, the others * // $ cfg ['Servers'] [$ i] ['controluser'] = 'root'; // $ cfg ['Servers'] [$ i] ['controlpass'] = ''; * commented out. But the problem (in the first message) remained . - Konstantin78