: Allow Link access to only one database I have a hosting account where we have multiple domains hosted and many of them have their own database. Coming to question, Can I share access to

@Rambettina238

PHPMyAdmin is a general MySQL client program. It prompts for a username and password which are used to access the database server directly. i.e. the database credentials and the credentials you enter into PHPMyAdmin are the same.

To achieve what you want, create a new user for the database server and grant them privileges only on the database you want them to have access to.

For example:

CREATE USER 'myguest'@'localhost' IDENTIFIED BY 'theirpass';
GRANT ALL ON theirdatabase.* TO 'myguest'@'localhost';


This does require that you have sufficient access to create new users in your database. That is unlikely to be the case if you have a shared hosting account (in which case you are out of luck).

Vote Up Vote Down

@Shanna517

My Opinion



I'm pretty sure you can add phpMyAdmin or search for another admin interface which has access to use specified commands in your
databases by creating it in your website directory.



Example

I've made something similar when I had a game server where the admins could add/remove credits, items and others from users accounts, so you can create a similar system for your needs, it's also a better solution for your security when an admin can edit certain tables and rows and not drop all your tables.

What you should be aware of

Altought if you are going for such a solution you have to password protect it and be aware of XSS attacks and other injections in it because it can be sloppy especially if you use admin interface from the internet and not going for a custom one, people put shells in this features in at least 40% of the cases.

The easy way to go for it

phpMyAdmin is a trusted feature, you can add it in your website directory and only share the user and password for the current site with your staff members, I recommend using custom solution because everybody having access to phpMyAdmin can also drop tables, modify rows etc..

Vote Up Vote Down

@Eichhorn148

i'm not sure, that you have such privileges, but your hoster has them 100%. To achieve what you want, In your hosting account should be created another one user, and he gets an access only to the database you allow. If you are able to create a user - do it, if not, ask your hoster.

Vote Up Vote Down