Database import fails: CREATE DATABASE line

Overview Restoring a database backup within the control panel, mysqli CLI, or phpMyAdmin may fail with the following message: #1044 – Access denied for user ‘myuser’@’localhost’ to database ‘mynewdb’ Cause A CREATE DATABASE query is issued during database import that cannot succeed due to limited permissions. All databases must be created within the control panel to…

Stored procedure creation fails

Overview During a database import, a stored procedure may be included in the backup. Although the backup is complete, restoring it within phpMyAdmin, the control panel, or mysql CLI fails with a similar error: #1227 – Access denied; you need (at least one of) the SUPER privilege(s) for this operation Cause Included in the procedure definition is…