I can't seem to remove rights for a remote root connection. Below you can see that the rights are present before and after the successful revoke command. Any ideas? I am using the correct command.
mysql> show grants for root@'192.168.1.103';
+------------------------------------------------------+
| Grants for root@192.168.1.103 |
+--------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'root'@'192.168.1.103' IDENTIFIED BY PASSWORD '091618a251aaff69' |
+----------------------------------------------+
1 row in set (0.00 sec)
mysql> revoke all on *.* from root@'192.168.1.103' identified by password '091618a251aaff69';
Query OK, 0 rows affected (0.00 sec)
mysql> show grants for root@'192.168.1.103';
+----------------------------------------------------------------------------------------+
| Grants for root@192.168.1.103 |
+----------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'root'@'192.168.1.103' IDENTIFIED BY PASSWORD '091618a251aaff69' |
+----------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> revoke all on *.* from root@'192.168.1.103' identified by password '091618a251aaff69';
Query OK, 0 rows affected (0.00 sec)
mysql> show grants for root@'192.168.1.103';
+----------------------------------------------------------------------------------------+
| Grants for root@192.168.1.103 |
+----------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'root'@'192.168.1.103' IDENTIFIED BY PASSWORD '091618a251aaff69' |
+----------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql>
