List:General Discussion« Previous MessageNext Message »
From:Al Sparks Date:April 11 2007 8:23pm
Subject:Revoking Privileges
View as plain text  
The version I'm using is:
  Your MySQL connection id is 6 to server version: 4.1.22

I log on as root.  I then:

mysql> show grants for 'WP_INT_BASEBALL'@'localhost';
+------------------------------------------------------------------------------------------------------------------------+
| Grants for WP_INT_BASEBALL@localhost                                                    
                              |
+------------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'WP_INT_BASEBALL'@'localhost' IDENTIFIED BY PASSWORD
'*37638FAC6D9ED84696E9504AC8EA4495EA97A908' |
| GRANT ALL PRIVILEGES ON `WP_INT_BASEBALL`.* TO 'WP_INT_BASEBALL'@'localhost'            
                              |
+------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql> REVOKE USAGE ON *.* FROM 'WP_INT_BASEBALL'@'localhost' IDENTIFIED BY PASSWORD
> '*37638FAC6D9ED84696E9504AC8EA4495EA97A908';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

When I do another SHOW GRANTS:

mysql> show grants for 'WP_INT_BASEBALL'@'localhost';
+------------------------------------------------------------------------------------------------------------------------+
| Grants for WP_INT_BASEBALL@localhost                                                    
                              |
+------------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'WP_INT_BASEBALL'@'localhost' IDENTIFIED BY PASSWORD
'*37638FAC6D9ED84696E9504AC8EA4495EA97A908' |
| GRANT ALL PRIVILEGES ON `WP_INT_BASEBALL`.* TO 'WP_INT_BASEBALL'@'localhost'            
                              |
+------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

So what am I doing wrong?  Why isn't that gone?
    === Al



Thread
Revoking PrivilegesAl Sparks11 Apr
  • Re: Revoking PrivilegesBaron Schwartz12 Apr