Database: Ability to restore with SUPER privileges at Admin Level

Version 1.5


Relating to this error: Access denied; you need (at least one of) the SUPER privilege(s) for this operation DA can now restore your databases with SUPER privileges via the Admin Level. By default, this feature is disable and the mysql restore will run as the User with basic mysql privileges (but no SUPER): restore_database_as_admin=0 However, if you enable this feature by adding: restore_database_as_admin=1 to your directadmin.conf and restart DA, any restore done via: Admin Level -> Admin Backup/Transfers will then run as root using the da_admin user/pass, which has SUPER privileges. Note that it's less safe to run as root, but because the .sql files are chowned to the User at restore time, and the --defaults-extra-file is not readable by the User, a single use with access to both is required. Since only Admin accounts can do this via their own tar.gz files in a safe place (which they must trust), it's less of an issue.

Interested to try DirectAdmin? Get a 30-day Free Trial!