set login enable for phpmyadmin

mysql, php, phpmyadmin

Solution

You can follow the steps shown below:

Step 1: Goto `phpMyAdmin` and find `Config.inc.php` file

Step 2: Find the line

$cfg ['Servers'] [$a] ['auth_type'] = 'config';

in `config.inc.php` file.

Step 3: Change the word `config` to `cookie` like so

$cfg ['Servers'][$a]['auth_type'] = 'cookie';

in `config.inc.php` file and Save the changes.

Note: your default database name is `root`.

Step 4: Now open browser and type `localhost/phpmyadmin`. Enter username is `root`. password is null means empty. you don’t type anything leave blank and press GO button.

Step 5: Now you can see the change password link. please click on that link.

Note: notice under `phpMyAdmin` title, log out icon is visible.

Step 6: Set your phpMyAdmin password and retype again and press the GO button.

Problem

I want to enable the login page for phpmyadmin before entering into in directlt. For that in my config.inc.php I modified the line ``` $cfg['Servers'][$i]['AllowNoPassword'] = true; to $cfg['Servers'][$i]['AllowNoPassword'] = false; ``` After changed I caught access denied error as I want to enable login for phpmyadmin

Original source