Cancel access from a remote IP address

Question

Today this problem arose, and I could not solve it. MySQL Server 5.1.67

As the mysql root user, I created the database, the user and granted all privileges from the remote IP

mysql> grant all privileges to test . * up to 'jane'@'56.44.3.24' identified by password;

mysql> privileges flush;

Jane now comes from another IP 33.2.67.3, so I need to remove access from my old IP address and allow access to her new IP address. In tests, I tried the following, but Jane can still access her old IP address, the script was recreated on several virtual machines using private IP addresses.

mysql> revoke all privileges on test . * up to 'jane'@'56.44.3.24' identified by password;

Is this the correct syntax? What am I missing?

Thank you in advance

Kevin

Answer 1

Check out the MySQL link for REVOKE: http://dev.mysql.com/doc/refman/5.0/en/revoke.html . You want something like:

 REVOKE ALL PRIVILEGES ON test.* FROM 'jane'@'56.44.3.24';