Why doesn't it work??

[tymbee]

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??????

[Kailash Badu]

UPDATE mysql.user SET Password=PASSWORD<"mypassword"> WHERE User="root";

Is that how your query exactly looks like?

It's supposed to be like this:
UPDATE mysql.user SET Password='mypassword' WHERE User='root';

[tmapm]

And if you use the password function, it'll be surrounded by parenthesis.

ie.

UPDATE mysql.user SET Password=password('mypassword') WHERE User='root';

[tymbee]

Is that how your query exactly looks like?

Thanks much for the response.

Yes-- that's exactly the way it was entered in the tutorial.

But going back to try the again with what's been posted here, I now get the "Enter password:" prompt, but ENTER just causes the window to close.

Apparently somehow what I did last night-- even though I was getting constant errors at everything I tried (and ENTER was working) set a password that I don't know.

Back to square one. Now what? Is there any way to blow out whatever it's looking for now and start over??

[tymbee]

Forgot the MySQL service had been set to start manually. Guess it would help to turn it on? Sheesh...

Working now. After many years working with Cold Fusion scripts, this PHP/MySQL stuff is new...