IKLAN

Theme images by kelvinjay. Powered by Blogger.

Tutorial

HEBOH

Kuliner

Youtube Tutorial

Games

Lowongan Kerja

OpenSource

» » Cara Memperbaiki Status 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 :
https://hemantnemade.wordpress.com/2013/07/12/fixphpmyadmin-error-1227-access-denied-you-need-at-least-one-of-the-super-privileges-for-this-operation/

«
Next
Newer Post
»
Previous
Older Post