Link to home
Start Free TrialLog in
Avatar of xcomiii
xcomiii

asked on

How to prevent a specific user from exporting a DB?

I have a CentOS 6.3 sever with normal LAMP and phpMyAdmin installed.
Is there anyway to disable the right for a mysql user to backup the database?

More specific, I want to disable a mysql user from downloading the entire DB that he has access to, without removing other rights? The user has now full access to the DB.

mysql version is 5.5.21
ASKER CERTIFIED SOLUTION
Avatar of kyodai
kyodai

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
Avatar of xcomiii
xcomiii

ASKER

Interesting, this user only have access to the mySQL from the phpMyAdmin, the user does not have shell access. So I wonder if there any way to remove the right so that the user cannot dump the DB from phpMyAdmin ? And yes, the user is a very novice user :)