Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


How to prevent a specific user from exporting a DB?

Posted on 2012-09-07
Medium Priority
Last Modified: 2012-09-28
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
Question by:xcomiii
LVL 11

Accepted Solution

kyodai earned 1500 total points
ID: 38375517
No, there is no realistic way to do this. Either a user has rights on that table or DB - then he/she can also export everything, or simply no rights on that DB. Even if you disable access rights or remove MySQL dump the user could easily script his own dump by simply reading out all records if the user is not a complete idiot. SO easy answer - no it's unfortunately not possible.

Author Comment

ID: 38375706
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 :)

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question