1

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.

0

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 and CREATE ROUTINE privileges to properly use them.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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