How to set super-user privileges in CiviCRM for MySQL? CiviCRM requesting for multilanguage support
You need to ask your hosting provider to give the database user the permission to create triggers and views. You only need super privileges if you're on an old version of mysql. Since you say you're on shared hosting they may not want to give those privileges, but try asking.