{"id":386,"date":"2018-01-06T14:56:59","date_gmt":"2018-01-06T14:56:59","guid":{"rendered":"https:\/\/mellowhost.com\/blog\/?p=386"},"modified":"2018-01-06T15:06:13","modified_gmt":"2018-01-06T15:06:13","slug":"phpmyadmin-coming-blank-in-cpanel","status":"publish","type":"post","link":"https:\/\/mellowhost.com\/blog\/phpmyadmin-coming-blank-in-cpanel.html","title":{"rendered":"phpMyAdmin Coming Blank in Cpanel"},"content":{"rendered":"<p>One of the customer reported an issue related to phpMyAdmin earlier today. He was getting a blank page of phpmyadmin that only says &#8220;Welcome to phpMyAdmin&#8221;<\/p>\n<p><a href=\"https:\/\/mellowhost.com\/blog\/phpmyadmin-coming-blank-in-cpanel.html\/fireshot-capture-009-http___erp-com-bd_2082_cpsess9125961174_3rdparty_phpmyadmin_index-php\" rel=\"attachment wp-att-387\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-387\" src=\"https:\/\/mellowhost.com\/blog\/wp-content\/uploads\/sites\/3\/2018\/01\/FireShot-Capture-009-http___erp.com_.bd_2082_cpsess9125961174_3rdparty_phpMyAdmin_index.php_.png\" alt=\"\" width=\"631\" height=\"383\" srcset=\"https:\/\/mellowhost.com\/blog\/wp-content\/uploads\/sites\/3\/2018\/01\/FireShot-Capture-009-http___erp.com_.bd_2082_cpsess9125961174_3rdparty_phpMyAdmin_index.php_.png 631w, https:\/\/mellowhost.com\/blog\/wp-content\/uploads\/sites\/3\/2018\/01\/FireShot-Capture-009-http___erp.com_.bd_2082_cpsess9125961174_3rdparty_phpMyAdmin_index.php_-300x182.png 300w\" sizes=\"(max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 984px) 61vw, (max-width: 1362px) 45vw, 600px\" \/><\/a><\/p>\n<p>Once I hoped into the ssh and checked the cpanel error log file located under<\/p>\n<p><code>\/usr\/local\/cpanel\/logs\/error_log<\/code><\/p>\n<p>I observed the following error:<\/p>\n<p><code>PHP Fatal error: require_once(): Failed opening required '.\/libraries\/display_select_lang.lib.php' (include_path='\/usr\/local\/cpanel\/3rdparty\/php\/56\/lib\/php:.') in \/usr\/local\/cpanel\/base\/3rdparty\/phpMyAdmin\/libraries\/plugins\/auth\/AuthenticationCpanel.php on line 147<\/code><\/p>\n<p>The error was peculiar because display_select_lang.lib.php wasn&#8217;t available in any other cpanel phpmyadmin source files I searched. Then I realized &#8220;AuthenticationCpanel.php&#8221; mentions the error which usually because Cpanel Authentication wasn&#8217;t done properly with the MySQL. Cpanel pass wasn&#8217;t synced with the MySQL.<\/p>\n<p>Going to WHM &gt;&gt; Password Modification &gt;&gt; If you select the user and WHM shows you the &#8216;Sync with MySQL Password&#8217; option, that means the MySQL password is outdated to cpanel and requires syncing (NB: If the password doesn&#8217;t require syncing, this option won&#8217;t be there). You can reset the pass and check the option to Sync the new pass with MySQL. That should restore your phpmyadmin.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>One of the customer reported an issue related to phpMyAdmin earlier today. He was getting a blank page of phpmyadmin that only says &#8220;Welcome to phpMyAdmin&#8221; Once I hoped into the ssh and checked the cpanel error log file located under \/usr\/local\/cpanel\/logs\/error_log I observed the following error: PHP Fatal error: require_once(): Failed opening required &#8216;.\/libraries\/display_select_lang.lib.php&#8217; &hellip; <a href=\"https:\/\/mellowhost.com\/blog\/phpmyadmin-coming-blank-in-cpanel.html\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;phpMyAdmin Coming Blank in Cpanel&#8221;<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[6,12,14,21,150,26],"tags":[209,210,92],"_links":{"self":[{"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/posts\/386"}],"collection":[{"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/comments?post=386"}],"version-history":[{"count":5,"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/posts\/386\/revisions"}],"predecessor-version":[{"id":392,"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/posts\/386\/revisions\/392"}],"wp:attachment":[{"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/media?parent=386"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/categories?post=386"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/tags?post=386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}