GRANT <SELECT&|INSERT&|DELETE&|UPDATE&|...etc|ALL PRIVILEGES> <database>.<table> TO <user>@'<host>' IDENTIFIED BY '<password> <with grant option>;
<database>.<table> = *.* will give access to everything, <database>.* will give access to all in that database, of course if you specify <database> then it will appear in the db table of the mysql database. If you specify <table> it will show in tables_priv. Note: On occasion I took notice that if I set up a grant, then set up another grant to a different database, with a different password, then the original permission entries password got changed too. You shouldn't have to refresh anything as far as I know. If you use insert or update to do privilege set up, then you should be calling FLUSH PRIVILEGES; -----Original Message----- From: Søren Neigaard [mailto:[EMAIL PROTECTED]] Sent: Monday, February 18, 2002 12:08 PM To: Henning Sprang Cc: [EMAIL PROTECTED] Subject: Re[2]: Am I asking the wrong question? Monday, February 18, 2002, 5:51:38 PM, Henning wrote: HS> sometimes you need to choose a good subject, but i don't know what your HS> original subject was... Yes maybe that actually was the reason :) HS> what exacly you don't understand? the following message is just a HS> special problem, not a question about understanding the permission system. HS> From this excerpt one cannot see if you really the right permissions, HS> at least it says that user homebrew has generally no permissions which HS> go over the full database. HS> To see if there are correct permissions check the db table ind Database HS> MySQL - there you find Database specififc persmissions for each user. Yes in db the homebrew user did not have any permissions, so I change them manually, and now it all works. But why? Should I not be able to set those permissions with GRANT? HS> Another thing that could be (but i am not sure if that applies) that you HS> need to relaod the database sometimes after granting something to a user HS> or adding a new user, i am not sure, but you can give it a try. Yes I needed that too, I stopped and started it. Can I "reload" it with some command? HS> ps: i would not send original passwords to such a list - one should HS> always black out things like that... Point taken :) -- Med venlig hilsen/Best regards, Søren Neigaard mailto:[EMAIL PROTECTED] --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
