This article explainsphpmyadminHow to solve the problem of control user connection failure. I hope it will be helpful to friends in need!
phpmyadmin failed to control user connection, ultimate solution
1. The following are articles found on the Internet
Because I It was phpmyadmin installed using apt-get. After checking the configuration file, I found that config.inc.php under /usr/share/phpmyadmin actually maps to /etc/phpmyadmin/config.inc.php.
Open /etc/phpmyadmin/config.inc.php, according to the error message, find the code to control the user:
$cfg['Servers'][$i]['controluser'] = $cfg['Servers'][$i]['controlpass'] =
Delete the thing after the equal sign and change it to:
$cfg['Servers'][$i]['controluser'] = ‘root’; $cfg['Servers'][$i]['controlpass'] = ’123456′;
123456 For your root password, save and refresh the phpmyadmin page. The connection failed using the control user defined in the configuration file. problem solved.
Download an installation package corresponding to your phpmyadmin version from the Internet. I downloaded: phpMyAdmin-3.2.2-all-languages.zip, unzip the scripts/create_tables.sql file, log in to phpmyadmin, and create a new file named For the database of phpmyadmin, import the create_tables.sql file.
Then modify /etc/phpmyadmin/config.inc.php and change:
$cfg['Servers'][$i]['pmadb'] = ‘phpmyadmin’; $cfg['Servers'][$i]['bookmarktable'] = ‘pma_bookmark’; $cfg['Servers'][$i]['relation'] = ‘pma_relation’; $cfg['Servers'][$i]['table_info'] = ‘pma_table_info’; $cfg['Servers'][$i]['table_coords'] = ‘pma_table_coords’; $cfg['Servers'][$i]['pdf_pages'] = ‘pma_pdf_pages’; $cfg['Servers'][$i]['column_info'] = ‘pma_column_info’; $cfg['Servers'][$i]['history'] = ‘pma_history’; $cfg['Servers'][$i]['designer_coords'] = ‘pma_designer_coords’;
Finally, restart mysql and apache.
However, I have not solved it, so I will record it temporarily
2.Through my own exploration
Found that there are several paths to the config.inc.php file
Find several paths through sudo find / -name config.inc.php
Path
/usr/share/phpmyadmin/setup/frames/config.inc.php /var/www/html/wordpress/phpmyadmin/config.inc.php /var/www/html/wordpress/phpmyadmin/setup/frames/config.inc.php /var/lib/phpmyadmin/config.inc.php /etc/phpmyadmin/config.inc.php
By reading the code inside, I found that there are two guys in
/etc/phpmyadmin/config.inc.php
, $dbuser and $dbpass,
Change these two guys to connect to the database. Your account and password will be fine, but you also need to restart apache and mysql
3. To summarize
There are several doubts: why change
/etc/phpmyadmin/config.inc.php文件里面的 $cfg['Servers'][$i]['controluser'] = $cfg['Servers'][$i]['controlpass'] =
Two variables don’t work?
In fact, these two variables mean the configuration of the super administrator username and password
The actual ones that work are $dbuser, $dbpass.
The above is the detailed content of How phpmyadmin solves the problem of control user connection failure. For more information, please follow other related articles on the PHP Chinese website!