Jump to content

[SOLVED] MySQL DB for each user


rtpmatt

Recommended Posts

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

Link to comment
https://forums.phpfreaks.com/topic/56685-solved-mysql-db-for-each-user/
Share on other sites

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';

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.