How to block the MySQL export option

Question

I searched here and googled for this answer but had no success.

I need to block the export option from a user at my MySQL database, is there a way to do it? I already blocked the update and edit options.

What are you trying to do? Is this from some kind of write-only logging setup, or will users need to be able to read data? — Zoredache, Jan 10 '12 at 22:25
Hello, users will be permited to read the data, but not allowed to dump the data. — digoferra, Jan 18 '12 at 16:47

score 1 · Accepted Answer · edited Apr 13 '17 at 12:14

1

And Google did not reveal the MySQL documentation about that topic? My Google did: http://dev.mysql.com/doc/refman/5.6/en/privilege-system.html

edited Apr 13 '17 at 12:14

Community

answered Jan 10 '12 at 21:33

mailq

I searched it, but did not found any instruction to deny dump...the other options I did! – digoferra Jan 10 '12 at 21:39
1

Love "The solution is the opposite of Minimum permissions for a user to perform a mysqldump?" – ceejayoz Jan 10 '12 at 21:41
Thanks, I´m portuguese and some words in english to search is difficult to me. – digoferra Jan 10 '12 at 22:58

1 Answers1