MySQL Tutorial - Change MySQL Password change in XAMPP Phpmyadmin

Question

Change MySQL Password change in XAMPP Phpmyadmin

Answer 1

1. Open your phpMyadmin dashboard
    Go to user accounts.
    On the user section Get the root user and click [ Edit privileges ].
    In the top section you will find change password button [ click on it ].
    Make a good pass and fill 2 password field.
    Now hit the Go button.

2. Now open your xampp dir ( c:/xampp ) -->

3. To phpMyadmin dir [C:\xampp\phpMyAdmin]

        open [ config.inc.php ] file with any text editor.

4. find 

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

line and replace 'config' to ‘cookie’.

5. go to 

[ $cfg['Servers'][$i]['AllowNoPassword'] = true; ] 

this line change ‘true’ to ‘false’.

last : Save the file.