phpmyadmin configuration files now require a secret short password (blowfish_Two Solutions for secret

  • 2021-06-28 09:00:05
  • OfStack


There are two solutions: (the second is recommended)

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

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

Then open the browser to enter the administrative address, and a login window will pop up, enter the user name and password, and can be.

However, it is very uncomfortable, and after entering the management interface, when you choose to sign out, it will pop up again, making people feel like you want a password to sign out.

2. Comparing the phpmyadmin configuration of ubuntu, there is one such configuration in ubuntu's config.inc.php

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

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

<?php
$cfg['blowfish_secret'] = 'w1HM7AxcX5aQvutjVOyGdepy';

Then "$cfg['blowfish_in phpmyadmin installed under CentOS"secret'] ='statement in config.inc.php

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

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

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

pooy is a character I add at will

Restart httpd to open the administration page

Still this look habit, but enter root and password again, the system prompts meroot@localhostPassword error: error'Access denied for user'root'@'localhost'(using password: NO), always can't get in, so clean up the browser's cookie, and then enter normally


Related articles: