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

#1045 - Access denied for user 'root'@'localhost' (using password: YES) 

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

change :
$cfg['Servers'][$i]['auth_type'] = 'http';
to
$cfg['Servers'][$i]['auth_type'] = 'cookie';

Reset Password Root phpmyadmin

1. D:\xampp\apache\conf\extra\httpd-xampp.conf
2. Change AllowOverride AuthConfig TO AllowOverride all
   Alias /phpmyadmin "D:/xampp/xampp/phpMyAdmin/"
      
           AllowOverride AuthConfig
           #AllowOverride all
           Order allow,deny
           Allow from all
      
3. Change in D:\xampp\phpMyAdmin\config.inc.php cookie to config
   // $cfg['Servers'][$i]['auth_type']     = 'config';    // Authentication method (config, http or cookie based)?
   $cfg['Servers'][$i]['auth_type']     = 'cookie';    // Authentication method (config, http or cookie based)?

Forbidden You don't have permission to access /phpmyadmin on this server.

Forbidden  You don't have permission to access /phpmyadmin on this server.
If you have problem like that, change in folder of apache / in file httpd.conf
Change from :

  Order Deny,Allow
  Deny from all
  Allow from 127.0.0.1


Become :

 Options Indexes FollowSymLinks MultiViews
    AllowOverride all
        Order Deny,Allow
        Allow from all


example :

    Options Indexes FollowSymLinks MultiViews
    AllowOverride all
        Order Deny,Allow
        Allow from all

phpmyadmin login forbidden

Q: Login without a password is forbidden by configuration (see AllowNoPassword) when using phpmyadmin login A: Change file config.inc.php

Display phpmyadmin

// ---------------------- this is file config.inc.php -----------------------
// ---------------- locate c:/wampp/apps/phpmyadmin3.2.0.1/ -----------------------

Alias /phpmyadmin "c:/wamp/apps/phpmyadmin3.2.0.1/"

# to give access to phpmyadmin from outside
# replace the lines
#
# Order Deny,Allow
# Deny from all
# Allow from 127.0.0.1
#
# by
#
# Order Allow,Deny
# Allow from all
#


Options Indexes FollowSymLinks MultiViews
AllowOverride all
Order Deny,Allow
Deny from all
#Allow from 172.30.118.130
Allow from all




// ---------------------- this is file phpmyadmin.conf -----------------------
// ---------------- locate c:/wampp/alias/phpmyadmin.conf -----------------------

/* Servers configuration */
$i = 0;

/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
#$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

/* End of servers configuration */

$cfg['DefaultLang'] = 'en-utf-8';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

?>PHP

Create password phpmyadmin

1. change the file config.inc.php (c:\xampp\phpmyadmin\

from
$cfg['Servers'][$i]['auth_type'] = 'config';
to
$cfg['Servers'][$i]['auth_type'] = 'cookie';

2. change password phpmyadmin from menu phpmyadmin
3. replace new password in config.php in c:\xampp\htdocs