Link to home
Start Free TrialLog in
Avatar of Alex
AlexFlag for Greece

asked on

How to give access only to phpMyAdmin

I have a website with 2 databases. I want to give to a colleague, access only to phpMyAdmin.

I don't want to let him log in into plesk and afterwards open the webadmin. I have to protect my personal sensitive data, the other db etc.
Avatar of Kalpan
Kalpan
Flag of India image

Create user and grant privileges to as their needs...it will only let them access the database.

http://business.bt.com/help/documents/pdf/PHPMyAdmin_UserGuide.pdf
is phpadmin in a seperate folder that the db etc if so put his login in htaccess in that folder and not in th other one with the db etc
Other solution will install phpmyadmin in domain webspace for eg like this

 https://<server>/phpMyAdmin

So it will be directly accessible .


Regards.
Abhijit
usually you will access it by typing

http://localhost/phpmyadmin

Most servers are localhost but you need to find out what your server is referenced by. Once you create an account for the new user(s) and set their permissions very tight, they can get into the database and view stuff but can not make any changes. you can limit their use to a single table if you like and limit exactly what they are allowed to do. If they try anything else, they will get a permission denied error.
ASKER CERTIFIED SOLUTION
Avatar of Beverley Portlock
Beverley Portlock
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial