Frustrating... I expect the error's mine, but I can't see it.
I followed Kevin Yank's instructions exactly on the Lynda.com PHP tutorial. Everything went exactly as shown, UNTIL I got to the very last item: setting a password.
When at the prompt, I typed (even using the same simple password):
UPDATE mysql.user SET Password=PASSWORD<"mypassword"> WHERE User="root";
I only get:
ERROR 1064 <43000>: you have an error in your SQL syntax: check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE User="root"' at line 1
What am I not doing right??????