I have installed WampServer 2.0 to begin learning PHP on my Windows machine. During configuration, I setup the local host password with no problems. When attempting to set the password for other connections, I was given an error. This is all very new to me, just a beginner.

I ran this command from the mysql prompt:

SET PASSWORD FOR root@"%"=PASSWORD("password");
and it returned this error:

ERROR 1133 (42000): Can't find any matching row in the user table.
Any help would be appreciated.

Kind regards,
Alex Stanford

Edit: Just realized this probably belongs in the MySQL forum. Sorry about that.