Answers.Body: <p>Most likely your Craft install has some custom stored procedures in it.  I say custom because Craft doesn't use them by default and therefore doesn't require the necessary privileges to use them.</p>
  
  <p>You'd need to make sure the MySQL user account Craft is running as and the one you're using to import the database backup has the 
  <a href="https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html#priv_alter-routine" rel="nofollow noreferrer">ALTER ROUTINE</a> and <a href="https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html#priv_create-routine" rel="nofollow noreferrer">CREATE ROUTINE</a> privileges to properly use them.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-11-15T05:33:01.987Z
Answers.LastActivityDate: 2019-11-15T05:33:01.987Z
Answers.UserDisplayName: Brad Bell
Body: <p>I am trying to upload my DB using MySQL Workbench but am getting this error: </p>
  
  <pre><code>ERROR 1370 (42000) at line 4534: alter routine command denied to user 'detectalocal'@'%' for routine 'detectalocal.checkLicensesExpiration'
  </code></pre>
  
  <p>How do I troubleshoot this? My root account has all of the correct permissions. </p>
  
Tags: <craft3><mysql><mamp>
Title: ERROR 1370 (42000) alter routine command denied to user
ThreadText: # ERROR 1370 (42000) alter routine command denied to user
  
  (Asked by: username_0 on 2019-11-14)
  
  I am trying to upload my DB using MySQL Workbench but am getting this error:
  
  ```
  ERROR 1370 (42000) at line 4534: alter routine command denied to user 'detectalocal'@'%' for routine 'detectalocal.checkLicensesExpiration'
  
  ```
  
  How do I troubleshoot this? My root account has all of the correct permissions.
  
  **Tags:** craft3, mysql, mamp
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2019-11-15. Score: 1
  
  Most likely your Craft install has some custom stored procedures in it. I say custom because Craft doesn't use them by default and therefore doesn't require the necessary privileges to use them.
  
  You'd need to make sure the MySQL user account Craft is running as and the one you're using to import the database backup has the
  [ALTER ROUTINE](https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html#priv_alter-routine) and [CREATE ROUTINE](https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html#priv_create-routine) privileges to properly use them.
  
  
  ---
  
  