Mysql password help

[nuwanpra]

Hi,

I was following a Video tutorial and successfully installed WAMP.

As advice on tutorial I tried to set a password for user 'root'. But I couldn't do it using MySql console. It was giving a error message saying there is a syntax error. (where user='root')

So I tried to do it using phpmyadmin. and manually created the password of root.

Now I cant connect to any thing as normal.

phpmyadmin says:#1130 - Host 'localhost' is not allowed to connect to this MySQL server

Can anyone help me?

If I reinstall WAMP, will it work?

 

[bhupendra2895]

Are you able to login in mysql console?
Also post the query you ran in phpmyadmin.It will be helpful for resolution of this problem.Of course reinstall can fix this, but I don't recommend fixing problems in this way because we won't be able to know how to resolve this error when this problem will occur again.

 

[nuwanpra]

No I'm unable to log in from Mysql console too.

I actually didn't run a query in phpmyadmin. What I did is manually browsed to mysql db and to user table then typed the password in both password fields of root and 127.0.0.1. Then I clicked on GO.