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