Phpmyadmin Error The configuration file now needs a secret passphrase blowfish secret

1. Error:

Phpmyadmin Error The configuration file now needs a secret passphrase blowfish secret

2. Solution:

2a. Create blowfish secret

[root@Centos6 conf.d]# mkdir -p /var/lib/phpmyadmin/
[root@Centos6 conf.d]# vi /var/lib/phpmyadmin/blowfish_secret.inc.php[root@Centos6 conf.d]# vi /var/lib/phpmyadmin/blowfish_secret.inc.php
$cfg[‘blowfish_secret’] = ‘dfd3kjGj12dfT27665Z’;
[root@Centos6 conf.d]#

2b. Copy that  blowfish_secret to /usr/share/phpmyadmin/config.inc.php

vim /usr/share/phpmyadmin/config.inc.php
<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
* phpMyAdmin sample configuration, you can use it as base for
* manual configuration. For easier setup you can use scripts/setup.php
*
* All directives are explained in Documentation.html and on phpMyAdmin
* wiki <http://wiki.phpmyadmin.net>.
*
* @version $Id$
/*
* This is needed for cookie based authentication to encrypt password in
* cookie
*/
$cfg[‘blowfish_secret’] = ‘dfd3kjGj12dfT27665Z‘; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! *//*
* Servers configuration
*/
$i = 0;/*
* First server
*/
$i++;
/* Authentication type */
$cfg[‘Servers’][$i][‘auth_type’] = ‘cookie’;
/* Server parameters */
$cfg[‘Servers’][$i][‘host’] = ‘localhost’;
$cfg[‘Servers’][$i][‘connect_type’] = ‘tcp’;
$cfg[‘Servers’][$i][‘compress’] = false;
/* Select mysqli if your server has it */
$cfg[‘Servers’][$i][‘extension’] = ‘mysql’;
/* User for advanced features */
// $cfg[‘Servers’][$i][‘controluser’] = ‘pma’;
// $cfg[‘Servers’][$i][‘controlpass’] = ‘pmapass’;……………………………………..

2c. Restart Httpd service

[root@Centos6 conf.d]# /etc/init.d/httpd restart
Stopping httpd: [ OK ]
Starting httpd:httpd: apr_sockaddr_info_get() failed for Centos6.3
httpd: Could not reliably determine the server’s fully qualified domain name, using 127.0.0.1 for ServerName
[ OK ]
[root@Centos6 conf.d]#
[root@Centos6 conf.d]#

Now you can access to myphpadmin without error. http://x.x.x.x/phpmyadmin/

That’s fixed. Thanks for using IThelpblog.com

Tags:  ,

Leave a reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>