title: Revoke access from remote IP
body: <p>This issue came up at work today and I have not been able to resolve it.
  MySQL server 5.1.67</p>
  
  <p>As mysql root user I have created a DB, user and granted all privileges from a remote IP</p>
  
  <p>mysql> grant all privileges on <code>test</code>.* to 'jane'@'56.44.3.24' identified by 'password' ;</p>
  
  <p>mysql> flush privileges ;</p>
  
  <p>Jane is now coming in from a different IP 33.2.67.3 so I need to remove access from her old IP and allow access from her new IP. In tests I have tried the following but jane can still access from her old IP, scenario recreated on a couple of VM's using private IP's.</p>
  
  <p>mysql> revoke all privileges on <code>test</code>.* to 'jane'@'56.44.3.24' identified by 'password' ;</p>
  
  <p>Is this the correct syntax? What am I missing?</p>
  
  <p>Thanks in advance</p>
  
  <p>Kevin</p>