Unable to import MySQL/MariaDB dump using Import Dump feature in Plesk: ERROR 1227 (42000) at line 1421: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

Symptoms

• Unable to import the MySQL/MariaDB dump via Subscriptions > example.com > Databases > Import Dump:

  Unable to import the john_doe_database dump:
  Unable to restore database 'john_doe_database'
  mysql: [Warning] Using a password on the command line interface can be insecure.
  ERROR 1227 (42000) at line 1421: Access denied; you need (at least one of) the SUPER privilege(s) for this operation
  (Error code 22)

• The MySQL/MariaDB CREATE procedure together with the DEFINER directive is used in the dump several times for different users:

  /*!50003 CREATE */ /*!50017 DEFINER=`John Doe`@% */ /*!50003 Some code */;;
  /*!50003 CREATE */ /*!50017 DEFINER=`Sarah Kerrigan`@% */ /*!50003 Some code */;;
  /*!50003 CREATE */ /*!50017 DEFINER=`James Raynor`@% */ /*!50003 Some code */;;

• Each user defined in the DEFINER directive in the MySQL/MariaDB dump have no SUPER privilege in the Tools & Settings > Database Servers > MySQL/MariaDB > User accounts > John Doe > Edit privileges > Administration list.

Cause

Resolution