MySql Database Restriction

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
dharprog
Forum Contributor
Posts: 126
Joined: Fri Oct 27, 2006 12:20 am

MySql Database Restriction

Post 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.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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.
User avatar
Oren
DevNet Resident
Posts: 1640
Joined: Fri Apr 07, 2006 5:13 am
Location: Israel

Post 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.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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.
User avatar
Oren
DevNet Resident
Posts: 1640
Joined: Fri Apr 07, 2006 5:13 am
Location: Israel

Post 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?
User avatar
dharprog
Forum Contributor
Posts: 126
Joined: Fri Oct 27, 2006 12:20 am

Post by dharprog »

Hi

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

Thank YOu.
Begby
Forum Regular
Posts: 575
Joined: Wed Dec 13, 2006 10:28 am

Post 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

:?: :?:
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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.
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post 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.
Post Reply