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
> my_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
Hi Per
What version of mysql are you using as server?
Tschau
Christian