<style>/*<link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=3287335696284421365&zx=026231ed-3583-46dd-87a1-682b316ca0a1' media='none' onload='if(media!='all')media='all'' rel='stylesheet'/><noscript><link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=3287335696284421365&zx=026231ed-3583-46dd-87a1-682b316ca0a1' rel='stylesheet'/></noscript>
<meta name='google-adsense-platform-account' content='ca-host-pub-1556223355139109'/>
<meta name='google-adsense-platform-domain' content='blogspot.com'/>

<!-- data-ad-client=ca-pub-7589726709582392 -->

</head><body>*/</style>

mysqli::query(): (HY000/1034): Index for table 'global_priv' is corrupt; try to repair it

Darma Riduan

Apr 1, 2021

Ketika membuka localhost/phpmyadmin saya menemukan kesalahan seperti foto diatas, setelah saya telusuri ternyata hal ini terjadi karena adanya upgrade untuk Server MySQL dan harus melakukan Pembaharuan seperti memperbaiki hak istimewa tabel, memperbaiki nama tabel dan database, mengupgrade tabel, dan flush. Solusi dari hal ini iyalah dengan mengupdate MySQL dengan cara berikut :

Jalankan Web Server XAMPP
Buka Folder \ xampp \ mysql \ bin
Jalankan mysql_upgrade.exe

Jika hal diatas tidak kamu lakukan maka setiap kamu membuka localhost/phpmyadmin maka kesalahan seperti diatas akan muncul dan menganggumu walaupun bisa kamu ignore all.

Unknown 4 November 2021 pukul 10.07

Thanks you🙏🙏🙏

Reply
Agus 18 Januari 2022 pukul 10.35

cara di atas berhasil gan, terima kasih

Reply
Darma Riduan 18 Januari 2022 pukul 12.14

iya sama sama, Alhamdulillah kalau work

Reply
RICO 26 Juli 2022 pukul 10.47

terimaksi

Reply
Melinia Suci Ramadhani 7 Januari 2023 pukul 17.09

Alhamdulillah sudah bisa, terimakasih ya kak
- Darma Riduan 7 Januari 2023 pukul 17.25
  
  iya sama sama
Reply
Randi M Rachman 13 Februari 2023 pukul 15.08

Thanks bang, work 100% 👌

Reply
Aditya Ramdhan 19 Maret 2023 pukul 20.51

thanks bang

Reply
Graphiteeee 23 Juli 2023 pukul 21.23

Makasii bgt buat caranya
- Darma Riduan 23 Juli 2023 pukul 23.18
  
  iya sama sama
Reply
Hilman Fadillah 24 Juli 2023 pukul 12.57

Terimakasih membantu banget

Reply

Add Comment

<style>/*
<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/3102550-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AOuZoY6t-BFRRDLlwO7nrXb98sklcVj01A:1746085889656';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d3287335696284421365','//www.freehost.id/2021/04/mysqliquery-hy0001034-index-for-table.html','3287335696284421365');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '3287335696284421365', 'title': 'FREEHOST', 'url': 'https://www.freehost.id/2021/04/mysqliquery-hy0001034-index-for-table.html', 'canonicalUrl': 'https://www.freehost.id/2021/04/mysqliquery-hy0001034-index-for-table.html', 'homepageUrl': 'https://www.freehost.id/', 'searchUrl': 'https://www.freehost.id/search', 'canonicalHomepageUrl': 'https://www.freehost.id/', 'blogspotFaviconUrl': 'https://www.freehost.id/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': '', 'encoding': 'UTF-8', 'locale': 'id', 'localeUnderscoreDelimited': 'id', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22FREEHOST - Atom\x22 href\x3d\x22https://www.freehost.id/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22FREEHOST - RSS\x22 href\x3d\x22https://www.freehost.id/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22FREEHOST - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/3287335696284421365/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22FREEHOST - Atom\x22 href\x3d\x22https://www.freehost.id/feeds/8353260440827167440/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseClientId': 'ca-pub-7589726709582392', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': false, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/f41918035ef7fb14', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Dapatkan link', 'key': 'link', 'shareMessage': 'Dapatkan link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Bagikan ke Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'Bagikan ke X', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Bagikan ke Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27id\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': true, 'jumpLinkMessage': 'Read more \xbb', 'pageType': 'item', 'postId': '8353260440827167440', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgITAegZoCMWac9otZ5VaQE6vkD2Y5bJyGUL1GmXfSkXkEcU1hQROHoB6d03iohwi7I7gYEZLCt0NNvpY1kiOrcI4jeKi6_fuTMAZTiVWDztMMP1ozvM_WTBmhS2IfBvZpdFHlND--bQDJm6NozAevuthQUJ13awwt9vrWW6GB8_nnrxXHUB2JVJoq2i_k/s72-c/global-priv.png', 'postImageUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgITAegZoCMWac9otZ5VaQE6vkD2Y5bJyGUL1GmXfSkXkEcU1hQROHoB6d03iohwi7I7gYEZLCt0NNvpY1kiOrcI4jeKi6_fuTMAZTiVWDztMMP1ozvM_WTBmhS2IfBvZpdFHlND--bQDJm6NozAevuthQUJ13awwt9vrWW6GB8_nnrxXHUB2JVJoq2i_k/s16000/global-priv.png', 'pageName': 'mysqli::query(): (HY000/1034): Index for table \x27global_priv\x27 is corrupt; try to repair it', 'pageTitle': 'FREEHOST: mysqli::query(): (HY000/1034): Index for table \x27global_priv\x27 is corrupt; try to repair it', 'metaDescription': ''}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Tautan disalin ke papan klip!', 'ok': 'Oke', 'postLink': 'Tautan Pos'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Khusus', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'mysqli::query(): (HY000/1034): Index for table \x27global_priv\x27 is corrupt; try to repair it', 'description': 'web hosting gratis, download aplikasi php gratis', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgITAegZoCMWac9otZ5VaQE6vkD2Y5bJyGUL1GmXfSkXkEcU1hQROHoB6d03iohwi7I7gYEZLCt0NNvpY1kiOrcI4jeKi6_fuTMAZTiVWDztMMP1ozvM_WTBmhS2IfBvZpdFHlND--bQDJm6NozAevuthQUJ13awwt9vrWW6GB8_nnrxXHUB2JVJoq2i_k/s16000/global-priv.png', 'url': 'https://www.freehost.id/2021/04/mysqliquery-hy0001034-index-for-table.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 8353260440827167440}}, {'name': 'widgets', 'data': [{'title': 'Upload Image', 'type': 'Image', 'sectionId': 'upload-image', 'id': 'Image10'}, {'title': 'Logo', 'type': 'HTML', 'sectionId': 'header-main', 'id': 'HTML10'}, {'title': 'Icons, Dark, Search', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList10'}, {'title': 'Menu', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList11'}, {'title': 'ExtraMenu', 'type': 'LinkList', 'sectionId': 'extra-menu', 'id': 'LinkList15'}, {'title': '#Popular Weeky', 'type': 'PopularPosts', 'sectionId': 'special-home', 'id': 'PopularPosts11', 'posts': [{'title': 'ADMS iclock (Automatic Data Master Server) Fingerprint', 'id': 1823966933594457941}, {'title': 'Base URL Dinamis Codeigniter 3', 'id': 7756229592464552346}, {'title': 'error #1273 - Unknown collation: \x27utf8mb4_0900_ai_ci\x27', 'id': 6839654495222480861}, {'title': 'Cara Menampilkan Jumlah Pembaca Di Setiap Postingan Blog', 'id': 6926253372606732627}, {'title': 'Visual Basic 2010 Full Version', 'id': 1948000218728640610}]}, {'title': '#Advertisement', 'type': 'HTML', 'sectionId': 'special-home', 'id': 'HTML25'}, {'title': '#Advertisement', 'type': 'HTML', 'sectionId': 'special-categories', 'id': 'HTML11'}, {'title': '#Advertisement', 'type': 'HTML', 'sectionId': 'before-blog', 'id': 'HTML3'}, {'title': '#Advertisement', 'type': 'HTML', 'sectionId': 'before-post', 'id': 'HTML12'}, {'title': 'Postingan Blog', 'type': 'Blog', 'sectionId': 'blog-post', 'id': 'Blog1', 'posts': [{'id': '8353260440827167440', 'title': 'mysqli::query(): (HY000/1034): Index for table \x27global_priv\x27 is corrupt; try to repair it', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgITAegZoCMWac9otZ5VaQE6vkD2Y5bJyGUL1GmXfSkXkEcU1hQROHoB6d03iohwi7I7gYEZLCt0NNvpY1kiOrcI4jeKi6_fuTMAZTiVWDztMMP1ozvM_WTBmhS2IfBvZpdFHlND--bQDJm6NozAevuthQUJ13awwt9vrWW6GB8_nnrxXHUB2JVJoq2i_k/s16000/global-priv.png', 'showInlineAds': false}], 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'author', 'label': 'Diposting oleh'}, {'name': 'timestamp', 'label': 'MMM d, yyyy'}, {'name': 'comments', 'label': 'Comment'}, {'name': 'share', 'label': ''}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': 'Labels:'}]}], 'allBylineItems': [{'name': 'author', 'label': 'Diposting oleh'}, {'name': 'timestamp', 'label': 'MMM d, yyyy'}, {'name': 'comments', 'label': 'Comment'}, {'name': 'share', 'label': ''}, {'name': 'labels', 'label': 'Labels:'}]}, {'title': '#Advertisement', 'type': 'HTML', 'sectionId': 'ads-post', 'id': 'HTML13'}, {'title': '#Advertisement', 'type': 'HTML', 'sectionId': 'ads-post', 'id': 'HTML14'}, {'title': '#You may also like', 'type': 'HTML', 'sectionId': 'ads-post', 'id': 'HTML15'}, {'title': '#Advertisement', 'type': 'HTML', 'sectionId': 'ads-post', 'id': 'HTML16'}, {'title': '#Advertisement', 'type': 'HTML', 'sectionId': 'ads-post', 'id': 'HTML17'}, {'title': '#Advertisement', 'type': 'HTML', 'sectionId': 'after-blog', 'id': 'HTML2'}, {'title': 'Popular Posts', 'type': 'PopularPosts', 'sectionId': 'sidebar-static', 'id': 'PopularPosts10', 'posts': [{'title': 'ADMS iclock (Automatic Data Master Server) Fingerprint', 'id': 1823966933594457941}, {'title': 'Base URL Dinamis Codeigniter 3', 'id': 7756229592464552346}, {'title': 'error #1273 - Unknown collation: \x27utf8mb4_0900_ai_ci\x27', 'id': 6839654495222480861}, {'title': 'Cara Menampilkan Jumlah Pembaca Di Setiap Postingan Blog', 'id': 6926253372606732627}, {'title': 'Visual Basic 2010 Full Version', 'id': 1948000218728640610}]}, {'title': '#Advertisement', 'type': 'HTML', 'sectionId': 'sidebar-static', 'id': 'HTML1'}, {'title': 'Categories', 'type': 'Label', 'sectionId': 'sidebar-static', 'id': 'Label10'}, {'title': 'Hashtag', 'type': 'Label', 'sectionId': 'sidebar-static', 'id': 'Label11'}, {'title': '#Recent Post', 'type': 'HTML', 'sectionId': 'sidebar-static', 'id': 'HTML19'}, {'title': '', 'type': 'HTML', 'sectionId': 'sidebar-static', 'id': 'HTML5'}, {'title': '', 'type': 'HTML', 'sectionId': 'sidebar-static', 'id': 'HTML4'}, {'title': '#Advertisement', 'type': 'HTML', 'sectionId': 'sidebar-sticky', 'id': 'HTML20'}, {'title': 'About Us', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML21'}, {'title': 'Learn More', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList13'}, {'title': 'Follow Us', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList14'}, {'title': 'Newsletter', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML22'}, {'title': 'Copyright', 'type': 'HTML', 'sectionId': 'copyright', 'id': 'HTML23'}, {'title': 'SVG Icons', 'type': 'HTML', 'sectionId': 'jet-options', 'id': 'HTML27'}, {'title': 'License Key', 'type': 'HTML', 'sectionId': 'jet-options', 'id': 'HTML28'}]}]);
_WidgetManager._RegisterWidget('_ImageView', new _WidgetInfo('Image10', 'upload-image', document.getElementById('Image10'), {'resize': false}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML10', 'header-main', document.getElementById('HTML10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList10', 'header-main', document.getElementById('LinkList10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList11', 'header-main', document.getElementById('LinkList11'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList15', 'extra-menu', document.getElementById('LinkList15'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts11', 'special-home', document.getElementById('PopularPosts11'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML25', 'special-home', document.getElementById('HTML25'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML11', 'special-categories', document.getElementById('HTML11'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML3', 'before-blog', document.getElementById('HTML3'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML12', 'before-post', document.getElementById('HTML12'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'blog-post', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/2952873794-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/3681588378-lightbox_bundle.css'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML13', 'ads-post', document.getElementById('HTML13'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML14', 'ads-post', document.getElementById('HTML14'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML15', 'ads-post', document.getElementById('HTML15'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML16', 'ads-post', document.getElementById('HTML16'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML17', 'ads-post', document.getElementById('HTML17'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML2', 'after-blog', document.getElementById('HTML2'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts10', 'sidebar-static', document.getElementById('PopularPosts10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML1', 'sidebar-static', document.getElementById('HTML1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label10', 'sidebar-static', document.getElementById('Label10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label11', 'sidebar-static', document.getElementById('Label11'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML19', 'sidebar-static', document.getElementById('HTML19'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML5', 'sidebar-static', document.getElementById('HTML5'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML4', 'sidebar-static', document.getElementById('HTML4'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML20', 'sidebar-sticky', document.getElementById('HTML20'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML21', 'footer-widget', document.getElementById('HTML21'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList13', 'footer-widget', document.getElementById('LinkList13'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList14', 'footer-widget', document.getElementById('LinkList14'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML22', 'footer-widget', document.getElementById('HTML22'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML23', 'copyright', document.getElementById('HTML23'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML27', 'jet-options', document.getElementById('HTML27'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML28', 'jet-options', document.getElementById('HTML28'), {}, 'displayModeFull'));
</script>
</body>*/</style>

Popular Posts

ADMS iclock (Automatic Data Master Server) Fingerprint

Base URL Dinamis Codeigniter 3

error #1273 - Unknown collation: 'utf8mb4_0900_ai_ci'

Cara Menampilkan Jumlah Pembaca Di Setiap Postingan Blog

Visual Basic 2010 Full Version

Categories

Hashtag