Hi Stephen,
Stephen Liu wrote:
Hi folks,
OpenBSD 4.0 x86_64
Mysql
Postfix_2.4.3
After running following command;
mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON test.* TO
'vmailuser'@'localhost' IDENTIFIED BY 'password123';
Query OK, 0 rows affected (0.00 sec)
I found I made a mistake to run it. I need to revoke the GRANT given to
vmailuser to test database.
I found on;
13.5.1.5. REVOKE Syntax
http://dev.mysql.com/doc/refman/5.0/en/revoke.html
The syntax;
REVOKE ALL PRIVILEGES, GRANT OPTION FROM user [, user]
but can't resolve whether retaining the 1st 'user'
and
replace [, user] with [, vmailuser]???
To undo this GRANT, run
REVOKE SELECT, INSERT, UPDATE, DELETE ON test.* FROM 'vmailuser'@'localhost';
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]