<style>/*<link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=4900839063825898872&zx=73dae6bc-162c-4ab6-ae78-589f4046299b' media='none' onload='if(media!='all')media='all'' rel='stylesheet'/><noscript><link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=4900839063825898872&zx=73dae6bc-162c-4ab6-ae78-589f4046299b' 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-2315440650188067 -->

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

Cara Mengatasi Access Danied di phpMyAdmin XAMPP

3 Feb, 2021

Cara Mengatasi Access Danied di phpMyAdmin XAMPP

Cara Mengatasi Access Danied di phpMyAdmin XAMPP - Pada kesempatan kali ini saya akan memberikan tutorial mengatasi access danied di phpmyadmin xampp yang mungkin bisa anda terapkan sendiri. Langsung saja simak permasalahan xampp yang sekarang hadapi ini sudah saya coba dan berhasil mengatasi error tersebut.

Notifikasi Error XAMPP di phpMyAdmin

MySQL said:

Cannot connect: invalid settings.
mysqli_real_connect(): (HY000/1130): Host 'localhost' is not allowed to connect to this MariaDB server
Connection for controluser as defined in your configuration failed.
mysqli_real_connect(): (HY000/1130): Host 'localhost' is not allowed to connect to this MariaDB server
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

Silahkan anda mengikuti berapa langkah dibawah ini agar tidak terjadi error lagi dan bisa membuka phpMyAdmin XAMPP.

Baca Juga: Cara Download dan Install XAMPP di Windows

Cara Mengatasi Access Danied di phpMyAdmin

Berikut langkah-langkah untuk mengatasi tidak bisa membuka / mengakses phpMyAdmin dengan sangat mudah dan cepat.

1. Buka aplikasi xampp kamu dan akan muncul seperti gambar dibawah ini, kemudian silahkan klik Config dimodule MySQL.

Cara Mengatasi Access Danied di phpMyAdmin XAMPP yang Sudah Saya Buktikan

2. Kemudian silahkan klik Config dan klik my.ini dan akan otomatis membuka notepad.

Cara Mengatasi Access Danied di phpMyAdmin XAMPP yang Sudah Saya Buktikan

3. Dan akan membuka tab baru, dan cari kode: [mysqld] dan copykan kata berikut: skip-grant-tables dibawahnya.

Cara Mengatasi Access Danied di phpMyAdmin XAMPP yang Sudah Saya Buktikan

4. Jika sudah klik save dan klik start kembali, dan lihat hasilnya.

Video Mengatasi Access Danied di phpMyAdmin

Baca Juga: Cara Membuat Database XAMPP dengan CMD (COMMAND PROMPT)

Kesimpulan

Itulah tadi Cara Mengatasi Access Danied di phpMyAdmin XAMPP yang Sudah Saya Buktikan, semoga masalah di xampp anda berhasil. Jika phpMyAdmin anda masih error silahkan unistall atau update xampp ke versi terbaru.

Apabila ada penjelasan yang kurang jelas, anda bisa bertanya dikolom komentar. Saya akan berusaha menjawab sebisa mungkin.

Selamat membaca dan belajar :D

<style>/*
<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/984859869-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AOuZoY5201nMbRvORPjC5Fx_2WaKvlxi4w:1732362972216';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d4900839063825898872','//www.ansoriweb.com/2021/02/cara-mengatasi-access-danied-di.html','4900839063825898872');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '4900839063825898872', 'title': 'Ansori Web', 'url': 'https://www.ansoriweb.com/2021/02/cara-mengatasi-access-danied-di.html', 'canonicalUrl': 'https://www.ansoriweb.com/2021/02/cara-mengatasi-access-danied-di.html', 'homepageUrl': 'https://www.ansoriweb.com/', 'searchUrl': 'https://www.ansoriweb.com/search', 'canonicalHomepageUrl': 'https://www.ansoriweb.com/', 'blogspotFaviconUrl': 'https://www.ansoriweb.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': '', 'encoding': 'UTF-8', 'locale': 'en-GB', 'localeUnderscoreDelimited': 'en_gb', '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\x22Ansori Web - Atom\x22 href\x3d\x22https://www.ansoriweb.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Ansori Web - RSS\x22 href\x3d\x22https://www.ansoriweb.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Ansori Web - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/4900839063825898872/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Ansori Web - Atom\x22 href\x3d\x22https://www.ansoriweb.com/feeds/8310946246521129832/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseClientId': 'ca-pub-2315440650188067', '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/d78375fb222d99b3', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Get link', 'key': 'link', 'shareMessage': 'Get link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Share to Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'Share to X', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Share to 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: \x27en_GB\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': false, 'jumpLinkMessage': 'Read more', 'pageType': 'item', 'postId': '8310946246521129832', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgHkxtF_IY9-56BroyigEi6pAxHaEGoQtP0MYqCXZachyDNqPJNiFw5j7awZ8Iq_LX2IA4RKu34psVmA2vt2P8jKVab0k6MQ_WcE9u9K-jFG9ba-lrbhIQUYTXz9ann9C_L3YBUMiwHpDo/s72-w640-c-h480/Cara+Mengatasi+Access+Danied+di+phpMyAdmin+XAMPP.JPG', 'postImageUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgHkxtF_IY9-56BroyigEi6pAxHaEGoQtP0MYqCXZachyDNqPJNiFw5j7awZ8Iq_LX2IA4RKu34psVmA2vt2P8jKVab0k6MQ_WcE9u9K-jFG9ba-lrbhIQUYTXz9ann9C_L3YBUMiwHpDo/w640-h480/Cara+Mengatasi+Access+Danied+di+phpMyAdmin+XAMPP.JPG', 'pageName': 'Cara Mengatasi Access Danied di phpMyAdmin XAMPP', 'pageTitle': 'Ansori Web: Cara Mengatasi Access Danied di phpMyAdmin XAMPP', 'metaDescription': 'Cara Mengatasi Access Danied di phpMyAdmin XAMPP - Pada kesempatan kali ini saya akan memberikan tutorial mengatasi access danied di phpmyadmin xampp '}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Link copied to clipboard', 'ok': 'Ok', 'postLink': 'Post link'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Custom', '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': 'Cara Mengatasi Access Danied di phpMyAdmin XAMPP', 'description': 'Cara Mengatasi Access Danied di phpMyAdmin XAMPP - Pada kesempatan kali ini saya akan memberikan tutorial mengatasi access danied di phpmyadmin xampp ', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgHkxtF_IY9-56BroyigEi6pAxHaEGoQtP0MYqCXZachyDNqPJNiFw5j7awZ8Iq_LX2IA4RKu34psVmA2vt2P8jKVab0k6MQ_WcE9u9K-jFG9ba-lrbhIQUYTXz9ann9C_L3YBUMiwHpDo/w640-h480/Cara+Mengatasi+Access+Danied+di+phpMyAdmin+XAMPP.JPG', 'url': 'https://www.ansoriweb.com/2021/02/cara-mengatasi-access-danied-di.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 8310946246521129832}}, {'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': '', 'type': 'HTML', 'sectionId': 'before-blog', 'id': 'HTML1'}, {'title': 'Blog Posts', 'type': 'Blog', 'sectionId': 'blog-post', 'id': 'Blog1', 'posts': [{'id': '8310946246521129832', 'title': 'Cara Mengatasi Access Danied di phpMyAdmin XAMPP', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgHkxtF_IY9-56BroyigEi6pAxHaEGoQtP0MYqCXZachyDNqPJNiFw5j7awZ8Iq_LX2IA4RKu34psVmA2vt2P8jKVab0k6MQ_WcE9u9K-jFG9ba-lrbhIQUYTXz9ann9C_L3YBUMiwHpDo/w640-h480/Cara+Mengatasi+Access+Danied+di+phpMyAdmin+XAMPP.JPG', 'showInlineAds': false}], 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'timestamp', 'label': 'd MMM, yyyy'}, {'name': 'comments', 'label': 'Comment'}, {'name': 'share', 'label': ''}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': 'Label:'}]}], 'allBylineItems': [{'name': 'timestamp', 'label': 'd MMM, yyyy'}, {'name': 'comments', 'label': 'Comment'}, {'name': 'share', 'label': ''}, {'name': 'labels', 'label': 'Label:'}]}, {'title': 'Artikel Terbaru', 'type': 'PopularPosts', 'sectionId': 'sidebar-sticky', 'id': 'PopularPosts10', 'posts': [{'title': 'Cara Membuat Website Toko Online dengan HTML dan CSS', 'id': 1746737498142175375}, {'title': 'Cara Membuat Form Login dengan PHP MySQLi', 'id': 8270954124121348765}, {'title': 'Cara Membuat Web Sekolah dengan HTML dan CSS', 'id': 3100159028180373426}, {'title': '5 Daftar Situs Proxy Tercepat Gratis dan Berbayar yang Bisa Kamu Coba', 'id': 2136519434684121254}, {'title': 'Cara Mengatasi Alamat Blog Tidak Tersedia', 'id': 5989316185514140880}]}, {'title': 'Kontak Kerjasama', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML21'}, {'title': 'Halaman', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList13'}, {'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': 'HTML24'}]}]);
_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('_HTMLView', new _WidgetInfo('HTML1', 'before-blog', document.getElementById('HTML1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'blog-post', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/1575117483-lbx__en_gb.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/1964470060-lightbox_bundle.css'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts10', 'sidebar-sticky', document.getElementById('PopularPosts10'), {}, '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('_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('HTML24', 'jet-options', document.getElementById('HTML24'), {}, 'displayModeFull'));
</script>
</body>*/</style>