[PHP] MySQL PRIVILEGES problem

[Manu Verhaegen]

Dear all,

I have the following problem :
I want change te root password for mysql and we receive the following error message
    ERROR 1064: parse error near 'FLUSH PRIVILEGES' at line 1


I login to my MySQL server and type the following commands
    shell> mysql -u root mysql
    mysql> UPDATE user SET Password=PASSWORD('new_password') where user='root';
    mysql> FLUSH PRIVILEGES;
    ERROR 1064: parse error near 'FLUSH PRIVILEGES' at line 1


thanks in advance.