rtpmatt Posted June 22, 2007 Share Posted June 22, 2007 I have a LAMP server, and i would like to allow a few of my friends to use it. I'm wondering if there is an easy way to allow each user to have access to their own database, or at least only show them what they have added to the DB. I just don't want users poking around each others things. I hope this makes sense. thanks for any help you can provide. -matt Quote Link to comment https://forums.phpfreaks.com/topic/56685-solved-mysql-db-for-each-user/ Share on other sites More sharing options...
Wildbug Posted June 22, 2007 Share Posted June 22, 2007 Yep. MySQL privilege system User account management GRANT syntax MySQL has a very fine-grained security model; you can limit users to a single column of a table in a database, if you want. Of course, you probably don't want that. It's easy to create a database for a user and limit user access between databases. It's all in the information above. GRANT ALL ON friends_db.* TO my_friend IDENTIFIED BY 'a password'; Quote Link to comment https://forums.phpfreaks.com/topic/56685-solved-mysql-db-for-each-user/#findComment-280126 Share on other sites More sharing options...
rtpmatt Posted June 22, 2007 Author Share Posted June 22, 2007 swell, im looking at it now! Quote Link to comment https://forums.phpfreaks.com/topic/56685-solved-mysql-db-for-each-user/#findComment-280467 Share on other sites More sharing options...
rtpmatt Posted June 22, 2007 Author Share Posted June 22, 2007 worked like a charm, thanks a ton! -matt Quote Link to comment https://forums.phpfreaks.com/topic/56685-solved-mysql-db-for-each-user/#findComment-280487 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.