2 solutions to the phpmyadmin configuration file now requiring a top-secret short password (blowfish_secret)

2 solutions to the phpmyadmin configuration file now requiring a top-secret short password (blowfish_secret)_PHP Tutorial

WBOY

Release： 2016-07-13 10:30:15

Original

1302 people have browsed it

There are two solutions: (it is recommended to use the second one)

1. Configure config.inc.php under phpmyadmin and change the cookie to http

Copy the code The code is as follows:

vi / usr/share/phpmyadmin/config.inc.php
[...]
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie ';
[...]

Open the browser and enter the management address. A login window will pop up. Enter your username and password.

But it’s very unaccustomed, and after entering the management interface, it will pop up again when you choose to log out, making it seem like you need a password to log out.

2. Compare the configuration of ubuntu's phpmyadmin. There is such a configuration in ubuntu's config.inc.php

Copy the code The code is as follows:

// Load secret generated on postinst
include('/var/lib/phpmyadmin/blowfish_secret.inc.php');

Check /var/lib/phpmyadmin/blowfish_secret.inc.php again, there is only one sentence

Copy the code The code is as follows:

$cfg['blowfish_secret'] = 'w1HM7AxcX5aQvutjVOyGdepy';

Then the "$cfg['blowfish_secret'] =" statement in phpmyadmin installed under CentOS is in config.inc.php

Copy code Code As follows:

vim /usr/share/phpmyadmin/config.inc.php

Find

Copy the code The code is as follows :

$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

Add any character after =

Copy code The code is as follows:

$cfg['blowfish_secret'] = 'pooy'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

pooy is a character I randomly added

Restart httpd and open the management page

This is what I am accustomed to, but when I enter root and password again, the system prompts me that the password for root@localhost is wrong: error 'Access denied for user 'root'@'localhost' (using password: NO), and I always cannot enter. Go, so I cleared the browser’s cookies, and then entered normally