pernah ngalamin hal ini “PhpMyAdmin “Error #1227- Access Denied, you need (at least one of) the super privilege(s) for this operation” .. contoh kasus..ane instal simdesa, selalu ada pesan eror tersebut .
berikut ada solusi mudah agar bisa terupload sqlnya di phpmyadmin cpanel.
berikut ada solusi mudah agar bisa terupload sqlnya di phpmyadmin cpanel.
buka file sql cari “Definer=’root@localhost”
hilangkan , save file dan import lagi..selamat mencoba
versi londo nya..
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.
thanks to :
https://hemantnemade.wordpress.com/2013/07/12/fixphpmyadmin-error-1227-access-denied-you-need-at-least-one-of-the-super-privileges-for-this-operation/
