PHPMyAdmin Config for Auto Login and AllowNoPassword Login

In this short post, I am putting two configurations for PHPMyadmin one that allows you to auto login and another that helps you to login with blank password.

PhpMyAdmin Blank Password Login (AllowNoPassword)

If you haven;t set any password for your mysql and you try to login to your PHPMyAdmin with a blank password you would receive the following error.

Login without a password is forbidden by configuration (see AllowNoPassword)

To fix this and be able to login to PHPMyAdmin without entering the password. Copy the file named config.sample.inc.php to config.inc.php and change the following property to true.

**For the usual phpmyadmin installation, config.sample.inc.php file is usually located at /etc/phpmyadmin/config.inc.php

$cfg['Servers'][$i]['AllowNoPassword'] = true;

Auto Login to PHPMyadmin

If you are looking for the ability to be able to auto login into PHPMyAdmin without entering the username and password then you need make following changes into the config.inc.php file

Change the auth_type property to config instead of cookie.
Provide the username and password

Here is how the configuration file looks

$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'password';

Related Articles

If you like our content, please consider buying me a coffee.

Thank you for your support!

Buy me a coffeeBuy me a coffee

Leave a reply:

Your email address will not be published.

Site Footer