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;
inconfig.inc.php
. -
Configure
controluser
‘a : create a user in MySQL, grant him a specific set of privileges, then add his username and password toconfig.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.