Home mysql Error while specifying connection for controluser in config

Error while specifying connection for controluser in config

Author

Date

Category

Error

I ask the MySQL guru for help. This error is generated by pma.
What to do?


Answer 1, authority 100%

In the screenshots, the error is “Access denied for user root (using password: NO) ” and appears “controluser “.

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

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

  • Turn off configuration repository: $ cfg ['Servers'] [$ i] ['pmadb'] = null; in config.inc.php .

  • Configure controluser ‘a : create a user in MySQL, grant him a specific set of privileges, then add his username and password to config.inc.php :

    $ cfg ['Servers'] [$ i] ['controluser'] = '& lt; USERNAME & gt;';
    $ cfg ['Servers'] [$ i] ['controlpass'] = '& lt; PASSWORD & gt;';
    

Answer 2, authority 14%

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

Programmers, Start Your Engines!

Why spend time searching for the correct question and then entering your answer when you can find it in a second? That's what CompuTicket is all about! Here you'll find thousands of questions and answers from hundreds of computer languages.

Recent questions