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