Error 1227 happens when your user of database doesn’t have enough privileges to show your website perfectly. If you need to migrate mysql database to a new hosting server and therefore you need to import your mysql database into your new hosting server. At this point you may face error that says “Access denied; you need (at least one of) the SUPER privilege(s) for this operation”. Then, here is very simple steps which will help you to fix your error 1227 easily:
Step 1: You have to open that sql file using notepad ++ and press ctrl+F and write down the word “definer” and press “Find Next” button.
Step 2: Now see this words: DEFINER=`emoncoder_emon`@`localhost` (you will see different user name instead of ’emoncoder_emon’) and Copy this word.
Step 3: Now Press Ctrl+F and open replace option, paste the copied items keep keep replace with option blank and press “Replace All” button.
Step 4: Now the word mentioned in under “Find what” option will have removed from the entire database file. Now Press “Save” button.
Step 5: Now Select the database again of your phpmyadmin, press “Check all” button
Step 6: Select “Drop” button and Press “Go”.
Step 7: After pressing drop button, you will be asked just like the following image and here Press “Yes”.
Step 8: Now database is cleaned and now select the database again and press “Import” button
Step 9: Now Press ‘Browse’ and select updated file from your computer.
Step 10: Press “Go” button
Step 11: you are done! enjoy..