community.aegirproject.org
Aegir MySQL non-root permissions
The Drupal group here is interested in using Aegir to manage some of the sites, but the DBA group won’t allow a MySQL root user. They’re okay with database create and user create permissions, just not full-blown root access. I’ve tried to find documentation on what exact SQL permissions are required for the MySQL user but I can't find anything other than root references. Does anyone know the exact list of minimum required permissions (SELECT, INSERT, UPDATE, DELETE, CREATE DATABASE, BACKUP DATABASE, CREATE USER, ...)?
At the very least, does anyone know why GRANT ALL PRIVILEGES is required (other than "to make administrative tasks such as creating new databases, and granting and revoking access to those databases for sites", which could be achieved with explicit CREATE DATABASE, CREATE USER, etc. rights)?
Thanks in advance!