You need to take a look at the database called mysql. In it you have: culumns_priv db func host tables_priv user
as tables. Use the "GRANT" command to set the USERS, or you can also do an insert statement like so: insert into mysql.tables_priv VALUES ('10.129.29.%','ai','httpd','pop_materials','gevery2@localhost','','Select,I nsert,Update,Delete','') and that will give the user httpd the Select,Insert,Update,Delete priveleges on that particular table. DB's is a bit different, but look at your output from USE mysql; DESC db; commands. -----Original Message----- From: Intercession Tech Support [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 3:09 PM To: [EMAIL PROTECTED] Subject: User/database permissions This is going to be a very basic question, so please excuse me. I have a MySQL server running, but when I added users I inadvertently gave them all permissions to everything. They can all access every one else's databases and make what ever changes they want and even delete. How do I lock it down where they only have rights to their own? I don't even know how to view what users are there, much less change their rights. I've been looking in the documentation online, but it seems to assume that I know more than I do. Thank you in advance. -MWhitaker --------------------------------------------------------------------- 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