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

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.

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 :

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