Hi, I want to grant all permissions to a user on mysql database. I have logged on as administrator to the computer (i.e not on a domain). Computer is windows xp pro.
I know the following works for granting on an IP address
GRANT ALL ON mydatabase.* TO 'root'@'18.104.22.168';
GRANT ALL ON mydatabase.* TO 'root'@'administrator';
that didn't work though.