Error

I ask for help from the guru of MySQL. This is what pma gives an error. What to do?

Closed due to the fact that it was off topic by aleksandr barakin , cheops , Streletz , Kromster , Grundy 13 Aug '16 at 19:03 .

It seems that this question does not correspond to the subject of the site. Those who voted to close it indicated the following reasons:

  • “Questions asking for help with debugging (“ why does this code not work? ”) Should include the desired behavior, a specific problem or error, and a minimum code for playing it right in the question . Questions without an explicit description of the problem are useless for other visitors. See How to create minimal, self-sufficient and reproducible example . " - Streletz, Kromster, Grundy
  • "The question is caused by a problem that is no longer reproduced or typed . Although similar questions may be relevant on this site, solving this question is unlikely to help future visitors. You can usually avoid similar questions by writing and researching a minimum program to reproduce the problem before publishing the question. " - aleksandr barakin, cheops
If the question can be reformulated according to the rules set out in the certificate , edit it .

    2 answers 2

    In the screenshots, the error " Access denied for user root (using password: NO) " and the figure " controluser " appear.

    You need to correctly set the username and password for controluser 'a . They are used to connect to the phpMyAdmin configuration storage (configuration storage) , where settings for additional functions are stored.

    Configuration storage is optional, phpMyAdmin can work without it. Therefore, you have two ways:

    • Disable configuration storage: $cfg['Servers'][$i]['pmadb'] = null; in config.inc.php .

    • Configure controluser 'a : create a user in MySQL, grant him a certain set of privileges, then add his name and password in config.inc.php :

       $cfg['Servers'][$i]['controluser'] = '<ИМЯ_ПОЛЬЗОВАТЕЛЯ>'; $cfg['Servers'][$i]['controlpass'] = '<ПАРОЛЬ>';
    • The fact is that through the console I can work with databases, but pma does not allow. - hidd
    • And the user also created in the configuration file. - hidd
    • and the user is not set to root , but the error still thinks that I am root - hidd

    I turned off the configuration storage, and then turned it back on, it helped.