WampServer

I have just add a password into root@localhost, and MySql stops allowing me to login

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

I have edited my.ini by adding password = MySetPassword (without ' ' )

After restart the service, still no go.

How can I remove the password or get the login screen?


Version of Operating system? - Windows 8.1 64bit
Version of Wamp Server installed? - Wamp 2.5 64bit
Version of Apache you are running? 2.4.9
Version of MySQL you are running? 5.6.17
Version of PHP you are running? 5.5.12

What colour is your WampManager icon? ( the in the system tray )
Green

hosts file content:
127.0.0.1 localhost

I found the solution to clear the password.

Login MySql console
then type the following:

mysql> SET PASSWORD FOR
-> root@localhost = OLD_PASSWORD('') ;

then hit ENTER

it will prompt

Query OK, 1 row affected (0.01 sec)

the Password will be removed.