I am just a beginner so it can be that it is a very stupid problem. I am using easyphp on my windows XP. I can't log in MYSQL with my root user. The only way to log in is with:

mysqld --skip-grant-tables&
mysql mysql
update user set password=password('abc123') where user='root';
quit
mysqld halt.

If i do this I can log in with the password abc123, but when i restart the computer I can't log in anymore and I have to update the password of the root again. Also when i try to change the permissions of users or I want to add a user there is a fould like this:

Fout

SQL-query :

GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , DROP , RELOAD , SHUTDOWN , PROCESS , FILE , REFERENCES , INDEX , ALTER , SHOW DATABASES , SUPER , CREATE TEMPORARY TABLES , LOCK TABLES , EXECUTE , REPLICATION CLIENT ON * . * TO "Pekka"@ "localhost"IDENTIFIED BY "******"WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;

MySQL retourneerde:

#1047 - Unknown command


Does somebody know what I have done wrong?