LinkUp/PHP-MySQL-Backup — Issue #2: Verify that database user has all appropriate permissions
Author: ecaron
Created: 2011-11-22 23:40:20+00:00
State: open

At present, we require each database user to have all these permissions:
* SELECT
* REFERENCES
* SHOW DATABASES
* CREATE TEMPORARY TABLES
* LOCK TABLES
* SHOW VIEW

I'm not 100% all of these are necessary (some, like "CREATE TEMPORARY TABLES", might not be needed at all. Others, like "LOCK TABLES", could probably have a work-around flag to mysqldump if they aren't available.)

At the very least, we should out-of-the-box make sure that all these methods are available against the current host/database being accessed and if not error appropriately.