Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have created a read only MySQL user but this user have an option to export the database through phpmyadmin. How can I disable the options Export and Import?

share|improve this question
If the users can run a SELECT they can always export the data. There is absolutely no way you can prevent that. They would need write privileges to import it though. – a_horse_with_no_name Mar 14 '13 at 17:41

I believe phpMyAdmin uses plain SELECTs and INSERTs to import and export the database.

I don't think you will be able to prevent import/export. I don't remember PhpMyAdmin having options to disable those features.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.