Magento 1.x – Fix Access denied error when importing an enterprise DB

If you are working with an enterprise DB, you can see the following error:

ERROR 1227 (42000) at line XXXX: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

To fix it, we will need to perform the following steps:

  • You will get an output something like this:
  • Get from the previous output, the user and the host.
  • With this information, we are going to proceed to search, replace, and create a new dump (it will take a few seconds):
  • After this, just import the newly generated file and you shouldn’t have any more issues.