Revoke privileges from user issue!
Hi,
I've been trying to figure out how to revoke grants from a user called tempaccess...
I've tried to revoke all privileges.
And separate privileges as wel with no luck.
And flushed privileges too.
However - I can remove via the SQL Administrator - but the Command line show that the user still has grants!?!
What can i be missing here?
#############################################################
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 46
Server version: 5.1.39-community MySQL Community Server (GPL)
#############################################################
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use mysql;
Database changed
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| xxx |
| test |
+--------------------+
4 rows in set (0.00 sec)
mysql> use xxxi;
Database changed
mysql> SHOW GRANTS FOR tempaccess@"%";
+-------------------------------------------------------------------------------
----------------------------+
| Grants for tempaccess@%
|
+-------------------------------------------------------------------------------
----------------------------+
| GRANT USAGE ON *.* TO 'tempaccess'@'%' IDENTIFIED BY PASSWORD '*2802BB99546BDE
1C380E3C3C5DEA5C0507CE9A63' |
+-------------------------------------------------------------------------------
----------------------------+
1 row in set (0.00 sec)
mysql> REVOKE INSERT,UPDATE,DELETE ON *.* FROM tempaccess@%;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '%' at
line 1
mysql> REVOKE INSERT,UPDATE,DELETE ON *.* FROM tempaccess@'%';
Query OK, 0 rows affected (0.05 sec)
mysql> REVOKE INSERT,UPDATE,DELETE ON *.* FROM tempaccess@"%";
Query OK, 0 rows affected (0.02 sec)
mysql> REVOKE INSERT,UPDATE,DELETE ON xxx.* FROM tempaccess@"%";
ERROR 1141 (42000): There is no such grant defined for user 'tempaccess' on host
'%'
mysql> REVOKE INSERT,UPDATE,DELETE ON xxx.* FROM tempaccess@"localhost";
ERROR 1141 (42000): There is no such grant defined for user 'tempaccess' on host
'localhost'
mysql> REVOKE INSERT,UPDATE,DELETE ON xxx.* FROM tempaccess@"192.168.1.11";
ERROR 1141 (42000): There is no such grant defined for user 'tempaccess' on host
'192.168.1.11'
mysql> REVOKE INSERT,UPDATE,DELETE ON xxx.* FROM tempaccess@'%';
ERROR 1141 (42000): There is no such grant defined for user 'tempaccess' on host
'%'
Any ideas are greatly appreciated.
Thx.
-SP