setting up mysql - last hurdle

ctam · #1 (**permalink**) 08-11-04, 12:58

I'm new to this and am trying to set up mysql etc. on my own pc following the tutorial at http://www.sitepoint.com/article/php...installation/8 but can't quite get it.
The final thing I have to do is complete the following 3 lines:

Code:

mysql>SET PASSWORD FOR root@localhost=PASSWORD("new password");
Query OK, 0 rows affected (0.00 sec)
mysql>SET PASSWORD FOR root@"%"=PASSWORD("new password");
Query OK, 0 rows affected (0.00 sec)
mysql>FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

and I get the first line to work fine but on the second line I get a message:

Quote:

Error 1133: Can't find any matching row in the user table

I'm confident I've entered it all correcly!
What can i do?
Thanks,
Craig.