Sunday, March 9, 2008

Mysql 5.x Adding New users.

I tried to create a new user with the mysql admin tool on windows (version 5.x) but ot no avail. Is there a bug with domain servers ? the message was '...dataset has changed..refresh your result set..'.. Although I had no-one opened. I wonder...

Anyway I used the good old method of starting the command line and adding the user manually..

GRANT ALL PRIVILEGES ON *.* TO 'root'@'' identified by 'XXXXX';

most people forget the quote '' on the user 'root' or otherwise..

u have too usually to flush privileges after this command.

No comments: