When I try to enable CiviCase I get a white screen of death and the following msg:

"A fatal error was triggered: Could not create the MySQL views for CiviCase. Your mysql user needs to have the 'CREATE VIEW' permission"

I cannot find any way to add this permission in PhpAdmin. What should I do?

  • According to my Control Panel, the MySQL user for the database already has 'CREATE VIEW' permission. – Andrew Himes Aug 5 '19 at 21:09
  • Oh just saw this. Is it user@localhost - the part after the @ might be significant and needs to match. Also try running a simple test Create View command manually in phpmyadmin and see what error you get. – Demerit Aug 5 '19 at 21:11
  • See also civicrm.stackexchange.com/questions/20369/… where the problem was a mismatched user domain. – Demerit Aug 5 '19 at 21:17

RESOLVED thanks to help from Hershel: Unable to enable CiviCase - Definer v Invoker problem maybe

The solution was to enable remote connections for the specific MySQL database.

| improve this answer | |

You'll need to look in your hosting control panel or ask your hosting provider. The mysql user account may not be allowed to have this permission in your hosting setup.

| improve this answer | |

Not the answer you're looking for? Browse other questions tagged or ask your own question.