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?

  • 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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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