Answers.Body: <p>Some permissions won't be granted when you use 'GRANT ALL' before the database has been created. Rerunning your GRANT ALL should fix the problem.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-11-15T14:36:16.953Z
Answers.LastActivityDate: 2016-11-15T14:36:16.953Z
Answers.UserDisplayName: Alan Dixon
Answers.Body: <p>The user does not have the permissions to alter and create routines (functions). This should fix it:</p>
  
  <pre><code>GRANT CREATE ROUTINE, ALTER ROUTINE ON civicrm.* TO civicrm;
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-11-15T14:35:12.520Z
Answers.Text: This is probably correct, but you should address the question's claim to have already granted all.
Answers.UserDisplayName: Alan Dixon
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-11-15T14:08:14.830Z
Answers.LastActivityDate: 2016-11-15T14:08:14.830Z
Answers.UserDisplayName: naomi
Body: <p>I have installed civicrm 4.7 on drupal 7. Installing of extension failed with error:</p>
  
  <pre><code>DROP FUNCTION IF EXISTS civicrm_strip_non_numeric [nativecode=1370 ** alter routine command denied to user 'civicrm'@'localhost' for routine 'civicrm.civicrm_strip_non_numeric']
  </code></pre>
  
  <p>I have grant all to the database, named civicrm.</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-11-15T17:32:04.537Z
Comments.Text: Which extension are you installing, and how did you try to install it -- from the Manage Extensions screen or manually by putting the files in your extension directory?
Comments.UserDisplayName: Allen Hutchison
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-11-16T08:14:03.550Z
Comments.Text: Thanks for the answers. I have already tried the "GRANT ALL" command before. It did not fix the error. Also, i have tried the civicrm_dbtools, but it isn't support the version ("FATAL: Don't recognize version 4.7.12").
Comments.UserDisplayName: Thomas
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-11-16T08:35:28.620Z
Comments.Text: Okay, I gave the persmissions with "GRANT ALL" again and it works.
  Thank you very much :-)
Comments.UserDisplayName: Thomas
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-11-16T15:38:41.640Z
Comments.Text: I installed CiviSepa, which is not from the public extension directory and put it to the extension directory
Comments.UserDisplayName: Thomas
Tags: <extension><installation><mysql>
Title: "alter routine command denied to user" error when installing extensions?
ThreadText: # "alter routine command denied to user" error when installing extensions?
  
  (Asked by: username_0 on 2016-11-15)
  
  I have installed civicrm 4.7 on drupal 7. Installing of extension failed with error:
  
  ```
  DROP FUNCTION IF EXISTS civicrm_strip_non_numeric [nativecode=1370 ** alter routine command denied to user 'civicrm'@'localhost' for routine 'civicrm.civicrm_strip_non_numeric']
  
  ```
  
  I have grant all to the database, named civicrm.
  
  **Tags:** extension, installation, mysql
  
  > **Comments:**
  > **username_1**: Which extension are you installing, and how did you try to install it -- from the Manage Extensions screen or manually by putting the files in your extension directory?  
  > **username_0**: Thanks for the answers. I have already tried the "GRANT ALL" command before. It did not fix the error. Also, i have tried the civicrm_dbtools, but it isn't support the version ("FATAL: Don't recognize version 4.7.12").  
  > **username_0**: Okay, I gave the persmissions with "GRANT ALL" again and it works. Thank you very much :-)  
  > **username_0**: I installed CiviSepa, which is not from the public extension directory and put it to the extension directory  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2016-11-15. Score: 2 | Accepted answer
  
  Some permissions won't be granted when you use 'GRANT ALL' before the database has been created. Rerunning your GRANT ALL should fix the problem.
  
  
  ---
  
  ### Answer by username_3 on 2016-11-15. Score: 3
  
  The user does not have the permissions to alter and create routines (functions). This should fix it:
  
  ```
  GRANT CREATE ROUTINE, ALTER ROUTINE ON civicrm.* TO civicrm;
  
  ```
  
  > **Comments:**
  > **username_2**: This is probably correct, but you should address the question's claim to have already granted all.  
  
  ---
  
  