3

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?

András Váczi
31.8k13 gold badges103 silver badges152 bronze badges
asked Oct 15, 2012 at 8:31
1
  • 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. Commented Mar 14, 2013 at 17:41

1 Answer 1

1

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.

Hannah Vernon ♦
71.1k22 gold badges178 silver badges324 bronze badges
answered Oct 15, 2012 at 13:54

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.