Title: Private database Last modified: August 21, 2016 --- # Private database * [skip8it](https://wordpress.org/support/users/skip8it/) * (@skip8it) * [11 years, 9 months ago](https://wordpress.org/support/topic/private-database/) * Hello,, I was wondering, if anyone knew of a way to have a private database that is editable from the front end,, I have created a mysql database only to find out that everyone shares it, It has to be private for each user, and editable for that user. and I dont want to have to create a new database for every person who joins my site Viewing 9 replies - 1 through 9 (of 9 total) * [Spence "The Evil Genius" Forman](https://wordpress.org/support/users/labzip/) * (@labzip) * [11 years, 9 months ago](https://wordpress.org/support/topic/private-database/#post-5046130) * Why do you need a full private database for ‘each’ user? * [catacaustic](https://wordpress.org/support/users/catacaustic/) * (@catacaustic) * [11 years, 9 months ago](https://wordpress.org/support/topic/private-database/#post-5046159) * The way to do that is to create a new database user for each new user that you need, and grant them permissions over only the tables that they need to have access to. Then you run whatever queires are needed with that database using that database user, and they won’t be allowed to access anything that they are not authorised to see. * Thread Starter [skip8it](https://wordpress.org/support/users/skip8it/) * (@skip8it) * [11 years, 9 months ago](https://wordpress.org/support/topic/private-database/#post-5046258) * Thank you catacaustic,, im gonna give it a shot * Thread Starter [skip8it](https://wordpress.org/support/users/skip8it/) * (@skip8it) * [11 years, 9 months ago](https://wordpress.org/support/topic/private-database/#post-5046322) * @ Spence “the evil genius” forman, my website will have a database, to hold personal private info for each user that joins. (hopefully millions) the users are responsible for imputing their information. and they have their own private area where the database table will be * I don’t want to create a new database for each users that joins if I dont have to. I also don’t want to create a new user every time someone joins. * Ideally I would like to create one blank database and when a user joins, he or she, gets a blank database for them to start populating. it will be in their own private area of course * [catacaustic](https://wordpress.org/support/users/catacaustic/) * (@catacaustic) * [11 years, 9 months ago](https://wordpress.org/support/topic/private-database/#post-5046327) * > I don’t want to create a new database for each users that joins * > I would like to create one blank database and when a user joins, he or she, > gets a blank database for them to start populating * Those statements together just don’t make sense. You can’t give someone a blank database, but not create a database for them. I don’t think you mean that quite the way that you said it, so I’ll try to work with what you’re really looking for. * Without knowing exactly what you want to end up with, you have two choices: * First, create a new table for each user when they join,login, are approved. This will let them have their own “blank slate” so to speak. The only hard part about this is keeping track of the table names, but you can use user ID’s to work with that, so it’s not too hard to do. * Second, you could create a single table, and have a foreign key set up so that each record in that table is attributed to a user. Personally I’d dol it this way as having many tables can make the database slow, and will cetainly make it a lot harder to manage. It also can be just as fast if you get the indexes right which isn’t that hard. All you need ot do is get your queries to work with only records that are set for that user, so that’s one extra line in a `WHERE` clause. * Thread Starter [skip8it](https://wordpress.org/support/users/skip8it/) * (@skip8it) * [11 years, 9 months ago](https://wordpress.org/support/topic/private-database/#post-5046328) * Thanks again, catacaustic,, let me give that a shot… * Thread Starter [skip8it](https://wordpress.org/support/users/skip8it/) * (@skip8it) * [11 years, 9 months ago](https://wordpress.org/support/topic/private-database/#post-5046334) * @ catacaustic,, I haven’t tried it yet, but last night I thought it would be so much easier to manage, in this particular situation, to use a spreadsheet, if wordpress would allow front end editing ? * [catacaustic](https://wordpress.org/support/users/catacaustic/) * (@catacaustic) * [11 years, 9 months ago](https://wordpress.org/support/topic/private-database/#post-5046336) * Not really. If you can find a way to integrate a spreadsheet into your site, maybe it would be OK, but then you’d still need to create a new spreadsheet for every new user. Also, spreadsheets don’t offer the same sort of functionality and security that a decent PHP-MySQL system does where you can make sure that the users can only do what they are allowed to do. * What I suggest is that after 5 days of thinking about this, just go and try it. Put something together and see how it works,. If it does what you want, keep going with it. If it doesn’t, learn from that and try something else. The only way to see if any solution is going ot suit you is to actually try it for yourself. * Thread Starter [skip8it](https://wordpress.org/support/users/skip8it/) * (@skip8it) * [11 years, 9 months ago](https://wordpress.org/support/topic/private-database/#post-5046337) * Man,, thanks, dude,,, I agree Viewing 9 replies - 1 through 9 (of 9 total) The topic ‘Private database’ is closed to new replies. ## Tags * [private](https://wordpress.org/support/topic-tag/private/) * In: [Everything else WordPress](https://wordpress.org/support/forum/miscellaneous/) * 9 replies * 3 participants * Last reply from: [skip8it](https://wordpress.org/support/users/skip8it/) * Last activity: [11 years, 9 months ago](https://wordpress.org/support/topic/private-database/#post-5046337) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics