I have read the manual about GRANT/REVOKE syntax. I have set up several
queries that worked to grant privileges, but then I sent this query to the
MySQL server:
REVOKE ALL PRIVILEGES ON *.* FROM 'testuser'@'xxx.xxx.xxx.xxx'
testruser is a user that has an entry in the user table, as well as several
entries in the tables_priv table. (Yes, the IP addresses match) After this
query is run, the entry is still in the user table, and all the entries are
still in the tables_priv table. Am I missing something, or is this not
working as expected?
MySQL 3.23.38
Thanks!
j----- k-----
--
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
