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 [EMAIL PROTECTED]
|
+------------------------------------------------------------------------------------------------------------------------+
| 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 [EMAIL PROTECTED]
|
+------------------------------------------------------------------------------------------------------------------------+
| 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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
