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

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

Have you ever find or get this error message for your mysql for windows base ( XAMPP ) when you try to change mysql root password ? I experienced by my self on my xampp server test that i install on windows xp, in few days ago.

After i installed my xampp server, i never change the password, and then i try to change mysql root password, and what the hell doing... i can't access phpmyadmin.

Finally one of many student at "mbahgoogle" (indonesian people called google search enginre), give me the solution.

Bellow the solution :

Look for the name of config file ( config.inc.php ) at your mysql folder ( C:\xampplite\phpMyAdmin )

 
After you get it, find the text bellow :

* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'http'; /* Authentication method (config, http or cookie based) */
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

And change the text with this :

* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'http'; /* Authentication method (config, http or cookie based) */
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'rootpasswd';
$cfg['Servers'][$i]['AllowNoPassword'] = false;

Note : the greendblod text is the text you must be change.

Important Note : Before you change everythings for your server config, make sure that your server service is turn off.  Like mysql service, apache service.

And after that make sure all service was running.

Oke, have a nice try.

Motto :

Dont worry if  you get some wrong in your life, everything in our life must be TRY and get some erorr.

So always keep TRY & ERROR