phpMyAdmin: secret passphrase?

Question

I am using MAMP and every time I login to phpMyAdmin, I am getting the following error/warning message:

the configuration file now needs a secret passphrase (blowfish_secret).

I have not messed around with any of this settings before. Can someone please clarify this error.

Here is the info on my db server:

Server: Localhost via UNIX socket Server type: MySQL Server version: 5.5.34 - Source distribution Protocol version: 10

Answer 1

The configuration file now needs a secret passphrase (blowfish_secret).

You’ll see this error after every installation of phpmyadmin.

To resolve this issue, just open config.inc.php ( or rename config.sample.inc.php to config.inc.php if you haven’t done so yet ) and change this line

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

to

$cfg['blowfish_secret'] = 'y[/qlva{kNheGD5hfzFLrNoS-ZX\zQ/';

To generate new blowfish secret, simply hit this https://phpsolved.com/phpmyadmin-blowfish-secret-generator/?g=5d94be5065c70

Answer 2

Actually, that's only a "secret string" like "my personal secret". Look here.

Answer 3

This might help, https://wiki.archlinux.org/index.php/PhpMyAdmin#Add_blowfish_secret_passphrase

If you see the following error message at the bottom of the page when you first log in to /phpmyadmin (using a previously setup MySQL username and password) :

ERROR: The configuration file now needs a secret passphrase (blowfish_secret)  

You need to add a blowfish password to the phpMyAdmin's config file. Edit /etc/webapps/phpmyadmin/config.inc.php and insert a random blowfish "password" in the line

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

It should now look something like this:

$cfg['blowfish_secret'] = 'qtdRoGmbc9{8IZr323xYcSN]0s)r$9b_JUnb{~Xz'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */  

This all assumes you've already properly created the config file,

cp config.sample.inc.php config.inc.php