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'@'max.here.com' identified by 'XXXXX';
most people forget the quote '' on the user 'root' or otherwise..
u have too usually to flush privileges after this command.