How to setup phpMyAdmin to use cookie authentication


Enter Your Query:
Use '%' for wildcards and quotes for "exact phrases"


Top Level » MySQL / MariaDB » phpMyAdmin

How to setup phpMyAdmin to use cookie authenticationLast Modified: Oct 3, 2019, 5:34 pm
This guide will describe how to setup phpMyAdmin to use a cookie/session based login system.
The advantage of the cookie based logins is that you can get an exact mysql error as to why you can't login (if you can't login).

Edit:
/var/www/html/phpMyAdmin/config.inc.php

Change:

$cfg['blowfish_secret'] = '';

to

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


and change:

$cfg['Servers'][$i]['auth_type']     = 'http';    // Authentication method (config, http or cookie based)?

to:

$cfg['Servers'][$i]['auth_type']     = 'cookie';    // Authentication method (config, http or cookie based)?

Close all browsers and try to connect again.

NOTE

You may want to instead simply enable the one-click single-signon for phpMyAdmin which enables cookies by default:
One-Click login to RoundCube and phpMyAdmin
 
Related Helpfiles
Using custom configs for PhpMyAdmin, SquirrelMail and Roundcube
I cannot login to phpMyAdmin

© 2018 JBMC Software, Suite 173  3-11 Bellerose Drive, St Albert, AB  T8N 1P7  Canada.  Mon-Fri 9AM-5PM MST