How phpmyadmin solves the problem of control user connection failure

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!