Answers.Body: <p>RESOLVED thanks to help from Hershel:
  <a href="https://civicrm.stackexchange.com/questions/20369/unable-to-enable-civicase-definer-v-invoker-problem-maybe">Unable to enable CiviCase - Definer v Invoker problem maybe</a></p>
  
  <p>The solution was to enable remote connections for the specific MySQL database.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-08-07T00:59:10.860Z
Answers.LastActivityDate: 2019-08-07T00:59:10.860Z
Answers.UserDisplayName: Andrew Himes
Answers.Body: <p>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.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-08-05T21:10:24.300Z
Answers.LastActivityDate: 2019-08-05T21:10:24.300Z
Answers.UserDisplayName: Demerit
Body: <p>When I try to enable CiviCase I get a white screen of death and the following msg:</p>
  
  <p>"A fatal error was triggered: Could not create the MySQL views for CiviCase. Your mysql user needs to have the 'CREATE VIEW' permission"</p>
  
  <p>I cannot find any way to add this permission in PhpAdmin. What should I do?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-08-05T21:09:46.963Z
Comments.Text: According to my Control Panel, the MySQL user for the database already has 'CREATE VIEW' permission.
Comments.UserDisplayName: Andrew Himes
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-08-05T21:11:22.173Z
Comments.Text: 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.
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-08-05T21:17:52.860Z
Comments.Text: See also https://civicrm.stackexchange.com/questions/20369/unable-to-enable-civicase-definer-v-invoker-problem-maybe where the problem was a mismatched user domain.
Comments.UserDisplayName: Demerit
Tags: <civicase><mysql>
Title: Unable to enable CiviCase
ThreadText: # Unable to enable CiviCase
  
  (Asked by: username_0 on 2019-08-05)
  
  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?
  
  **Tags:** civicase, mysql
  
  > **Comments:**
  > **username_0**: According to my Control Panel, the MySQL user for the database already has 'CREATE VIEW' permission.  
  > **username_1**: 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.  
  > **username_1**: See also https://civicrm.stackexchange.com/questions/20369/unable-to-enable-civicase-definer-v-invoker-problem-maybe where the problem was a mismatched user domain.  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_0 on 2019-08-07. Score: 3
  
  RESOLVED thanks to help from Hershel:
  [Unable to enable CiviCase - Definer v Invoker problem maybe](https://civicrm.stackexchange.com/questions/20369/unable-to-enable-civicase-definer-v-invoker-problem-maybe)
  
  The solution was to enable remote connections for the specific MySQL database.
  
  
  ---
  
  ### Answer by username_1 on 2019-08-05. Score: 0
  
  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.
  
  
  ---
  
  