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

"Definer='root@localhost"

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

Advertisements
9 Comments
  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 🙂

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: