Hello.
Please send us an ouput of the following statement, which you should perform in the middle of your test case: show grants for current_user(); Can you find, if your grants change? Can you reproduce a problem on the latest release (4.1.9 now)? schlubediwup <[EMAIL PROTECTED]> wrote: > 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 > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
