Per Zetterlund wrote:
> I have a trouble setting the root password in my newly installed MySQL.
> I do the "DELETE FROM user WHERE Host='localhost' AND User=";"
> That works and it says "1 line affected".
> Then I do the "C:\mysql\bin>mysqladmin reload" still OK.
> But then when I do the "C:\mysql\bin>mysqladmin -u root password
> it sais: "C:\MYSQL\BIN\MYSQLA~1.EXE: unable to change password; error:
> 'parse error near 'SQL_OPTION password='6d7b5e9c5c8b8baf'' at line 1' "
> Any ideas?
> -- Per
What version of mysql are you using as server?