xampp localhost phpmyadmin Access denied for user 'root'@'localhost' (using password: YES)

try these step

  1. Open config.inc.php file in the phpmyadmin directory

  2. Find line 21: $cfg['Servers'][$i]['password'] = ''

  3. Change it to: $cfg['Servers'][$i]['password'] = 'your_password';

  4. Restart XAMPP

here is full description with image


After spending so much time what i came know is.

Just use this setting-> Open config.inc.php file in the phpmyadmin directory

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;  
$cfg['Lang'] = '';

You should have one user with @localhost host name. Now phpmyadmin will ask you for password. if you provide correct password,You will be able to login.


Don't change anything , put as it was there , just open your xampp and try to access mysql from shell cd c://xampp/mysql/bin after this write mysql and click enter it will open your databases