I need to download a database given to me with select-only permissions to import it at my localhost for editing.
How can I do that?
How about disabling authentication temporarily and doing a mysqldump?
Now, move the mysqldump file to your local machine and run this
Give it a Try!