Skip to content

[FIX]PhpMyAdmin “Error #1227- Access Denied, you need (at least one of) the super privilege(s) for this operation”

July 12, 2013

Above errors comes when you upload/import database on hosting environments using phpmyadmin.

To Resolve this error you need to open your “Database Name.sql” file in any editor and find/search below line


Remove this line from .sql file, save it and try to import it. It will import successfully.

  1. kaushal permalink

    My Code is following:-

    CREATE ALGORITHM=UNDEFINED DEFINER=`tycheinf_desinew`@`localhost` SQL SECURITY DEFINER VIEW `view_name` AS select `c`.`id` AS `id`,`c`.`category` AS `category`,`c`.`ordering` AS `ordering`,`c`.`published` AS `published`,`c`.`parent` AS `parent`,(select count(`p`.`id`) from `khwld_jblance_project` `p` where find_in_set(`c`.`id`,`p`.`id_category`)) AS `thecount` from `khwld_jblance_category` `c` order by (select count(`p`.`id`) from `khwld_jblance_project` `p` where find_in_set(`c`.`id`,`p`.`id_category`)) desc;

    I have import this file then i get error #1227 – Access denied; you need (at least one of) the SUPER privilege(s) for this operation .
    Please let me know you have any solutions.

  2. Delete ” DEFINER=`tycheinf_desinew`@`localhost` “

  3. ohhh be… thanks…

  4. really very thanks john 🙂

  5. Muchas gracias

  6. fred ali permalink

    thanks alot …great work

  7. Suriya permalink

    Thank you

  8. krishna permalink

    thank you

  9. madhu kumar permalink

    Thank you..awesome answer…u made my day 🙂

  10. David permalink

    Thank youu soo soo much!!! You took me out of frustration and made my day 🙂 Good luck!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: