#1227 – Access denied; you need (at least one of) the SUPER privilege(s) for this operation

Welcome to the first post of 2016 🙂

This is a micropost about that annoying error #1227 – Access denied; you need (at least one of) the SUPER privilege(s) for this operation.

I encountered this error while I was trying to import a .sql export file (exported from my working localhost machine) into a database on a shared hosting account, and solution to this is super easy if you know the source of the problem.

So, when you export a .sql file from your local MySQL database you will have some lines where it starts by creating a definer. Something like this:

CREATE DEFINER = ‘root_user’@localhost

Where ‘root_user’ is the administrator in your local MySQL Database (your development machine). In order to be able to import this exported .sql file all you need to do is find and replace all the occurences of the above piece of string with an empty string “”. Now try importing the file again. It should work this time.

Hope this helps.
Fight for human rights – Human Rights Watch,
Serdar

Leave a Reply

Your email address will not be published. Required fields are marked *