Changing phpMyAdmin root password

To change the root password in phpMyAdmin follow these steps:

1. Log in to the database directly using command:
   

   mysql -h <your_hostname> -u root

2. Run the following SQL command:
   

   UPDATE mysql.user SET Password=PASSWORD('Your new Password') WHERE User='root';

3. Open the following file:
   

   <XAMPP_INSTALLATION_FODLER>\phpMyAdmin\config.inc.php

4. Change the following values:

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

   and
   

   $cfg['Servers'][$i]['password'] = '';
   to
   $cfg['Servers'][$i]['password'] = 'new_password';