{"id":6724,"date":"2019-09-30T08:52:44","date_gmt":"2019-09-30T08:52:44","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=6724"},"modified":"2021-11-16T09:58:40","modified_gmt":"2021-11-16T09:58:40","slug":"error-phpmyadmin-not-accessible-on-network-using-ip-address-but-localhost-in-ubuntu","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/error-phpmyadmin-not-accessible-on-network-using-ip-address-but-localhost-in-ubuntu\/","title":{"rendered":"Error &#8211; phpmyadmin not accessible on network using ip address but localhost in ubuntu"},"content":{"rendered":"\n<p><strong>Error<\/strong><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>Access forbidden!<br> New XAMPP security concept:<br> Access to the requested object is only available from the local network.<br> This setting can be configured in the file &#8220;httpd-xampp.conf&#8221;.<\/p><\/blockquote>\n\n\n\n<p><strong>Step 1 &#8211; First validate if phpmyadmin is running and accessible locally.<\/strong><br> curl http:\/\/localhost\/phpmyadmin\/<\/p>\n\n\n\n<p><strong>Step 2 &#8211; Locate httpd-xampp.conf in your Server<\/strong><\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">root@ip<span class=\"hljs-number\">-172<\/span><span class=\"hljs-number\">-31<\/span><span class=\"hljs-number\">-20<\/span><span class=\"hljs-number\">-213<\/span>:\/opt\/lampp<span class=\"hljs-comment\"># cd \/opt\/lampp<\/span>\nroot@ip<span class=\"hljs-number\">-172<\/span><span class=\"hljs-number\">-31<\/span><span class=\"hljs-number\">-20<\/span><span class=\"hljs-number\">-213<\/span>:\/opt\/lampp<span class=\"hljs-comment\"># find . -name httpd-xampp.conf<\/span>\n.\/phpmyadmin\/httpd-xampp.conf\n.\/etc\/extra\/httpd-xampp.conf<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p><strong>Step 3 &#8211; Modify httpd-xampp.conf with required permission.<\/strong><\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">vi .\/etc\/extra\/httpd-xampp.conf\n\n<span class=\"hljs-comment\"># since XAMPP 1.4.3<\/span>\n&lt;Directory <span class=\"hljs-string\">\"\/opt\/lampp\/phpmyadmin\"<\/span>&gt;\nAllowOverride AuthConfig Limit\nOrder deny,allow\nAllow from all\nAllow from ::<span class=\"hljs-number\">1<\/span> <span class=\"hljs-number\">127.0<\/span><span class=\"hljs-number\">.0<\/span><span class=\"hljs-number\">.0<\/span>\/<span class=\"hljs-number\">8<\/span> <span class=\"hljs-number\">0.0<\/span><span class=\"hljs-number\">.0<\/span><span class=\"hljs-number\">.0<\/span> \\\nfc00::\/<span class=\"hljs-number\">7<\/span> <span class=\"hljs-number\">10.0<\/span><span class=\"hljs-number\">.0<\/span><span class=\"hljs-number\">.0<\/span>\/<span class=\"hljs-number\">8<\/span> <span class=\"hljs-number\">172.16<\/span><span class=\"hljs-number\">.0<\/span><span class=\"hljs-number\">.0<\/span>\/<span class=\"hljs-number\">12<\/span> <span class=\"hljs-number\">192.168<\/span><span class=\"hljs-number\">.0<\/span><span class=\"hljs-number\">.0<\/span>\/<span class=\"hljs-number\">16<\/span> \\\nfe80::\/<span class=\"hljs-number\">10<\/span> <span class=\"hljs-number\">169.254<\/span><span class=\"hljs-number\">.0<\/span><span class=\"hljs-number\">.0<\/span>\/<span class=\"hljs-number\">16<\/span>\nErrorDocument <span class=\"hljs-number\">403<\/span> \/error\/XAMPP_FORBIDDEN.html.<span class=\"hljs-keyword\">var<\/span>\n<span class=\"hljs-keyword\">Require<\/span> all granted\n&lt;\/Directory&gt;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"693\" height=\"513\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2019\/09\/ubuntu-xampp-localhost-network-accessible.jpg\" alt=\"\" class=\"wp-image-6726\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2019\/09\/ubuntu-xampp-localhost-network-accessible.jpg 693w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2019\/09\/ubuntu-xampp-localhost-network-accessible-300x222.jpg 300w\" sizes=\"auto, (max-width: 693px) 100vw, 693px\" \/><\/figure>\n\n\n\n<p><strong>Step 4 &#8211; Restart XAMPP<\/strong><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>sudo \/opt\/lampp\/lampp stop<br> sudo \/opt\/lampp\/lampp start<\/p><\/blockquote>\n\n\n\n<p><strong>Step 5 &#8211; Vlaidate in browsers.<\/strong><br> http:\/\/13.33.33.233\/phpmyadmin<\/p>\n\n\n\n<script src=\"https:\/\/gist.github.com\/devops-school\/fe2b0b751f8f3a2d72abf3d963838528.js\"><\/script>\n\n\n\n<p><strong>Error &#8211; 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.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"373\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2021\/01\/phpmyadmin-error-hy000-1045-1024x373.jpg\" alt=\"\" class=\"wp-image-20221\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2021\/01\/phpmyadmin-error-hy000-1045-1024x373.jpg 1024w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2021\/01\/phpmyadmin-error-hy000-1045-300x109.jpg 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2021\/01\/phpmyadmin-error-hy000-1045-768x280.jpg 768w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2021\/01\/phpmyadmin-error-hy000-1045.jpg 1154w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Solution<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"399\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2021\/01\/phpMyAdmin-tried-1024x399.jpg\" alt=\"\" class=\"wp-image-20223\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2021\/01\/phpMyAdmin-tried-1024x399.jpg 1024w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2021\/01\/phpMyAdmin-tried-300x117.jpg 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2021\/01\/phpMyAdmin-tried-768x300.jpg 768w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2021\/01\/phpMyAdmin-tried.jpg 1110w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n<div class=\"epyt-gallery\" data-currpage=\"1\" id=\"epyt_gallery_57485\"><iframe loading=\"lazy\"  id=\"_ytid_78773\"  width=\"760\" height=\"427\"  data-origwidth=\"760\" data-origheight=\"427\" src=\"https:\/\/www.youtube.com\/embed\/?enablejsapi=1&#038;autoplay=0&#038;cc_load_policy=0&#038;cc_lang_pref=&#038;iv_load_policy=1&#038;loop=0&#038;rel=1&#038;fs=1&#038;playsinline=0&#038;autohide=2&#038;theme=dark&#038;color=red&#038;controls=1&#038;disablekb=0&#038;\" class=\"__youtube_prefs__  no-lazyload\" title=\"YouTube player\"  data-epytgalleryid=\"epyt_gallery_57485\"  allow=\"fullscreen; accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen data-no-lazy=\"1\" data-skipgform_ajax_framebjll=\"\"><\/iframe><div class=\"epyt-gallery-list\"><div>Sorry, there was a YouTube error.<\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Error Access forbidden! New XAMPP security concept: Access to the requested object is only available from the local network. This setting can be configured in the file &#8220;httpd-xampp.conf&#8221;. Step 1&#8230; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[5150],"tags":[],"class_list":["post-6724","post","type-post","status-publish","format-standard","hentry","category-php"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/6724","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=6724"}],"version-history":[{"count":6,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/6724\/revisions"}],"predecessor-version":[{"id":25429,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/6724\/revisions\/25429"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=6724"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=6724"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=6724"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}