Hi again mysql-listers
regarding the problem i mentionned this morning:
for a description check out my message of this morning.
in the meantime i have found out
1. how to reproduce the problem 2. how to work around the problem
1. how to reproduce:
DROP TABLE afir_accounts ; DROP TABLE afir_contacts ; DROP TABLE afir_knowledge ; DROP TABLE afir_tasks ; DROP TABLE afir_timer ; DELETE FROM participants WHERE ident = 'afir' ; DELETE FROM part_val WHERE ident = 'afir' ; REVOKE all ON afir_accounts FROM 'afir'@'myhost.tld' ; REVOKE all ON afir_contacts FROM 'afir'@'myhost.tld' ; REVOKE all ON afir_knowledge FROM 'afir'@'myhost.tld' ; REVOKE all ON afir_tasks FROM 'afir'@'myhost.tld' ; REVOKE all ON afir_timer FROM 'afir'@'myhost.tld' ; REVOKE all ON afir_files FROM 'afir'@'myhost.tld' ; REVOKE select ON participants FROM 'afir'@'myhost.tld' ; REVOKE select,update ON part_val FROM 'afir'@'myhost.tld' ; REVOKE GRANT OPTION ON *.* FROM 'afir'@'myhost.tld' ; DROP USER 'afir'@'myhost.tld';
you may substitute whatever string for "afir".
after such a sequence of commands the root-userid i described in my message earlier today cannot be used to access the mysql db anymore. you get the error message " host myhost.tld is not allowed to access this mysql server".
2. how to work around i just added
FLUSH PRIVILEGES ;
to the above sequence, and everything works well.
this command, however, according to mysql docu, should not be necessary after such a sequence of commands.
suomi
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
