Changing MySQL password in Xampp

new_gist_file

I. First disable grant tables
stop the MySQL service through Administrator tools, Services.
Modify the my.ini configuration file (assuming default paths) located in C:\xampp\mysql\bin

In the SERVER SECTION, under [mysqld], add the following line:
skip-grant-tables

... so that you have
# SERVER SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this 
# file.
#
[mysqld]

skip-grant-tables

-- SERVER SECTION MAY LOOK DIFFERENT --

Start the service again and you should be able to log into your database without a password.

BUT if you want continue and change root password:

1. in command line go to C:\xampp2\mysql\bin
2. run mysql.exe -u root -p
3. when asked for password press eneter(means no passwrd)
4. To make sure user root doesn't have password please type
UPDATE mysql.user SET Password=PASSWORD('') WHERE User='root';

6. OPTIONAL if you chioose to use password (SET Password=PASSWORD('your_password_here'))
Then you will have to change password in phpMyAdmin (STEP 7)
7. C:\xampp\phpMyAdmin\config.inc.php
$cfg['Servers'][$i]['password']='root';

8. delete skip-grant-tables from  my.ini configuration file located in C:\xampp\mysql\bin