Home> Database> phpMyAdmin> body text

How phpmyadmin solves the problem of control user connection failure

藏色散人
Release: 2021-07-09 17:11:31
forward
2550 people have browsed it

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'] =
Copy after login

Delete the thing after the equal sign and change it to:

$cfg['Servers'][$i]['controluser'] = ‘root’; $cfg['Servers'][$i]['controlpass'] = ’123456′;
Copy after login

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’;
Copy after login

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
Copy after login

By reading the code inside, I found that there are two guys in

/etc/phpmyadmin/config.inc.php
Copy after login

, $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'] =
Copy after login

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!

Related labels:
source:csdn.net
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!