Diana, Wednesday, January 23, 2002, 7:33:35 PM, you wrote:
DS> Maybe you did not execute FLUSH PRIVILEGES or run mysqladmin DS> flush-privileges to tell the server to reload the grant tables. DS> Until this, your changes will not take effect. There is no need to run "mysqladmin reload" or "FLUSH PRIVILEGES" if you use GRANT. These are needed only if you change the privileges tables (mysql.*) manually. >> I have an existing database containing 28 tables, and I want to add a user >> to >> that database. I want this user to have SELECT, INSERT and UPDATE >> privileges on >> every table in the database, and DELETE privileges on ONLY 6 of those 28 >> tables. >> So I go about it with the following commands: [problem skip] -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ 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
