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'@'220.127.116.11' identified by 'somepass';
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