How to prevent a specific user from exporting a DB?

Posted on 2012-09-07
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

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

    Author Comment

    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

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Both Easy and Powerful How easy is PHP? (  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikiped…
    Creating and Managing Databases with phpMyAdmin in cPanel.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now