Liferay PaaS - DB user doesn't have super privileges for the database service

Note: please note that Liferay has renamed its Liferay Experience Could offerings to Liferay SaaS (formerly LXC) and Liferay PaaS (formerly LXC-SM).

Issue

• Liferay PaaS backup service will throw:
  

  ERROR 1227 (42000) at line XX: Access denied; you need (at least one of) the SUPER privilege(s) for this operation 

  Where, on XX line, the below SQL command is present:
  

  CREATE DEFINER = `dbadmin` @ `localhost` PROCEDURE `getData` () 

Environment

• Liferay PaaS

Resolution

• Google Cloud SQL (underlying Liferay PaaS) does not allow add SUPER privilege to users.

  As a solution:

  - You should remove all DEFINE declarations, e.g. (DEFINER = `dbadmin` @` localhost`) from the dump file, or
  - Replace from DEFINER = `dbadmin` @` localhost` to DEFINER = `dxpcloud` @` %`

Additional Information

• https://cloud.google.com/sql/docs/mysql/users#root-user