xampp localhost phpmyadmin Access denied for user 'root'@'localhost' (using password: YES)
try these step
Open config.inc.php file in the phpmyadmin directory
Find line 21:
$cfg['Servers'][$i]['password'] = ''
Change it to:
$cfg['Servers'][$i]['password'] = 'your_password';
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