Database Privelages

[sroberts82]

Hi,
I wanted to make my MySQL server accessable remotely. At first I just wanted to get it working so I granted everything to every IP using:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'the_pw' WITH GRANT OPTION

Now I want to revoke first to get me back to where I don't allow remote connections at all and then just do the same thing as

GRANT ALL PRIVILEGES ON *.* TO 'root'@'the.ip.i.want' IDENTIFIED BY 'the_pw' WITH GRANT OPTION

I was playing around with REVOKE but couldn't get it to work.
Thanks in advance
Ste

[lostboy]

Did you try just regranting the privileges to the ip that you want?