mysql drop revoke user from specific host ?
 

i want to remove specifi permission entries for a user to connect from specific hosts on my network, i dont want to do a revoke all, but when i try the revoke statement below, the mysql.user table still shows an entry for this host im trying to remove.

revoke all privileges on *.* from 'root3345'@'192.175.2.102' identified by 'somepass';


help ?

after i remove this and a few others, ill then do a grant for 192.175.2.% so that any this user can connect from any host on my network