Sign In
Create Account
Follow Us on Twitter
Subscribe on Youtube
Hi there ppl. I come here for one short but maybe not that simple question.
I want to develop an online IDE for php, html, javascript, mysql, so i can use it on an intranet. The ide is not the problem, i'm on it. I'm gonna make like a login page and create users, that will also create a folder for that user to develop their pages... The problem comes now, i need to provie them the phpmyadmin service, so that they can create or upload database and stuff.. How do i make it possible to use to multiple users, without them seeing each others database?. I was thinking maybe there's a program to use like a hosting service... Any suggestions would be nice... Thanks..
2
Divide phpmyadmin..?
Started by
Guest_GerarD_91_*
, Sep 08 2011 07:38 PM
3 replies to this topic
Back to top|
|
|
#2
Posted 08 September 2011 - 08:51 PM
Alexander
-
- Moderators
-
- 4,118 posts
It's Science!
- Location:Vancouver, Eh! Cleverness: 200
Your first step would be to grant each new user rights to create or destroy a database, and that introduces the problem aforementioned. You will need to isolate what you are granting them permission on, and the most reasonable way is to restrict their access to a subset of databases, such as their name, and then a wildcard.
i.e.
This would consequently only allow me to modify databases, such as alexander_wordpress, alexander_settings and not read or write others.
Having to check for collision on user names and database names, is paramount to prevent one user from accessing another (such as user! and user& where &! are stripped off, if that is what you are doing.)
i.e.
CREATE USER 'alexander'@'localhost' IDENTIFIED BY 'abc_password'; grant all on `alexander\_%`.* to 'alexander'@`localhost`;
This would consequently only allow me to modify databases, such as alexander_wordpress, alexander_settings and not read or write others.
Having to check for collision on user names and database names, is paramount to prevent one user from accessing another (such as user! and user& where &! are stripped off, if that is what you are doing.)
Be sure to read the updated FAQ! || Health is achieved through the same 10,000 steps.
If a suggested code/method fails, informing us is less important than telling us why or what errors occurred.
If a suggested code/method fails, informing us is less important than telling us why or what errors occurred.
#3
Posted 09 September 2011 - 04:26 AM
Vaielab
-
- Members
-
- 547 posts
Programming God
You have an options in the config files of phpmyadmin to do so.
You will create a username and say wich database he have access.
Alan Doyle ยป Configuring phpMyAdmin for multiple users you will find explications here
But you should also use Alexander method for more security
You will create a username and say wich database he have access.
Alan Doyle ยป Configuring phpMyAdmin for multiple users you will find explications here
But you should also use Alexander method for more security
#4
Guest_GerarD_91_*
Posted 09 September 2011 - 06:14 AM
Guest_GerarD_91_*
Guest_GerarD_91_*
-
- Guests
Those are really good ideas... I guess i'll try both and see the one that comes better... Thanks for that fast reply :p
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users
