Hey all, we have a new subscriber here :)
I'm working on a MySQL permissions problem, and would welcome some
suggestions and/or comments, or to be pointed in the right direction. The
goals I have are:
a) Limit users to specific db's (no access to mysql.*/etc.)
b) Eliminate anony browsing of db's.. and ideally eliminate
ability to view a complete list of all db's.
First, I want to cut down anony privs.. (I honestly don't know what they are
set to be default, so this might not be neccesary.)
----------------
GRANT usage ON * TO ''@'localhost';
----------------
Next, we want to assign privileges to individual users on the database, but
make sure they can only access their OWN db's. For this:
----------------
GRANT create,delete,drop,index,insert,select,update ON users_db.* to
'user_name'@'localhost' identified by 'password';
----------------
Would anyone be able to let me know if this could/should work? (Don't have a
mysql server here to test this w/ at the moment, so your input would be
appreciated.)
If I'm way off on this, I'd really appreciate any pointers in the right
direction..
Thanks!
Ryan
---------------------------------------------------------------------
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
