What does the "TRIGGER command denied" error mean?

When trying to create a View, Routine or Procedure for your database from within PHPMyAdmin, you may encounter an error similar to the following:

#1142 - TRIGGER command denied to user '_sso_XXXXX'@'1.2.3.4' for table 'my_table' 

This error relates to how you sign in to PHPMyAdmin and the permissions that are granted to that user. 

If you sign in to the database through My20i using single-sign-on (or SSO for short), the system creates a temporary user to access and navigate through your database. 

This is because we do not store any passwords in plain text. As such, the details to sign in as the actual MySQL user are not available for the UI to use.

The temporary user that it creates, _sso_XXXX, does not have the necessary permissions to create Views, Routines or Procedures, and as such is unsuitable for setting these up. 

Instead, you will need to visit PHPMyAdmin manually, and login using your MySQL hostname/username/password combination. 

Once you’ve signed in with these details, you will have the necessary grants to add what you need to your database.