Page 1 of 1

MySql Database Restriction

Posted: Tue Apr 10, 2007 7:33 am
by dharprog
Hi

I have a problem that is. I have semi dedicated server in which i have created several domains. I give the each domain to each developer. But when it comes to Database how can i restrict one database to another to the Developers. I mean a developer have to see only one database among several. How can i make or give specific database address to them. When i give to him the access of Cpanel they can see all the databases contained in that when they click on the phpMyadmin in Mysql Database Management in Cpanel.

How can i do this? please can anybody help me that would be very appreciable.

Thank You very much.

Posted: Tue Apr 10, 2007 8:11 am
by feyd
They shouldn't need access to phpMyAdmin, if they do, I wouldn't consider them skilled.

Each database can be given a specific user for them to use that has all the rights they should need.

Posted: Tue Apr 10, 2007 8:55 am
by Oren
feyd wrote:They shouldn't need access to phpMyAdmin, if they do, I wouldn't consider them skilled.
Really? Why?

I disagree. It saves you time while you develop. For example, if you have some query that doesn't work, you can check only the query itself with phpMyAdmin so you can tell whether the problem is the query itself or maybe something in your code - something in you PHP code that executes sql commands. With phpMyAdmin you can test the query independent from your application's implementation.

Posted: Tue Apr 10, 2007 9:14 am
by feyd
They shouldn't need it installed on a production server. At most, only on their local development machine.

I, myself, use the command line for MySQL unless I'm forced to use something else.

Posted: Tue Apr 10, 2007 9:20 am
by Oren
feyd wrote:They shouldn't need it installed on a production server.
No, they shouldn't, but what if they were forced for whatever reason to develop the application on a specific server with specific configurations?

Posted: Tue Apr 10, 2007 11:16 am
by dharprog
Hi

How can make a specific address for specific database to a specific user or developer?

Thank YOu.

Posted: Tue Apr 10, 2007 12:14 pm
by Begby
dharprog wrote:Hi

How can make a specific address for specific database to a specific user or developer?

Thank YOu.
I think you are missing a few key words in your question as it's not making sense

:?: :?:

Posted: Tue Apr 10, 2007 3:29 pm
by feyd
What does a specific configuration have to do with setting up a MySQL database?



CPanel allows you to associate users with any number of databases that you've had it create. Give the developers the credentials to log in as a unique user for all the databases they may need access to.

Posted: Tue Apr 10, 2007 5:07 pm
by RobertGonzalez
Using your admin tool of choice (phpMyAdmin, SQLYog, MySQL Administrator) create users for the database server. Give them a password and remember it. Create a database for them, then assign their user permission on that database only. Regardless of how many databases are on the database server, they will only see the ones they have been given permission to.