Hi!
>>>>> "duo" == duo fu <[EMAIL PROTECTED]> writes: duo> Hi friends: duo> I try to grant privileges to a user named 'glen' but not succeed. Here is duo> the script: mysql> select * from user where User='glen'; duo> | localhost | glen |... mysql> grant all privileges on test.* to 'glen'@'localhost' identified by duo> 'tidbs1'; duo> ERROR 1133: Can't find any matching row in the user table I agree that the above is very strange. The above error means that MySQL could not find an entry with hostname=localhost and user='glen' in the privilege cache. Which MySQL version are you using ? Could you please check if the above command works after 'flush privileges'. If not, could you upload the mysql privilege tables (or a copy of the tables that shows this problem) to: ftp://support.mysql.com/pub/mysql/secret and we will try to repeat this. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com --------------------------------------------------------------------- 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
