Re: Error #1064 SQL syntax at line 1 - strange characters

[Josh Goldberg]

I'm getting the same error for a different reason.

mysql> use mysql
UPDATE user
SET Password PASSWORD ('password')
WHERE user 'root';

Trying to set the password on mysql database.

I took out the semicolon after ('password')
but it still keeps showing up in this post.



Edited 2 time(s). Last edit at 09/05/2011 02:54AM by Josh Goldberg.