<input type="hidden" id="_wpnonce" name="_wpnonce" value="554d87a88e" /><input type="hidden" name="_wp_http_referer" value="/blog/wp-json/wp/v2/posts/3013" /><input type="hidden" id="_wpnonce" name="_wpnonce" value="554d87a88e" /><input type="hidden" name="_wp_http_referer" value="/blog/wp-json/wp/v2/posts/3013" />{"id":3013,"date":"2015-01-15T22:43:11","date_gmt":"2015-01-15T11:43:11","guid":{"rendered":"https:\/\/www.businesslegions.com\/blog\/?p=3013"},"modified":"2015-05-25T15:50:53","modified_gmt":"2015-05-25T05:50:53","slug":"setup-phpmyadmin-prompt-login-password","status":"publish","type":"post","link":"https:\/\/www.businesslegions.com\/blog\/2015\/01\/15\/setup-phpmyadmin-prompt-login-password\/","title":{"rendered":"How to setup phpMyAdmin to prompt for login and password"},"content":{"rendered":"<!--CusAds0--><p>By default, phpMyAdmin on WAMP automatically logs in using the root user account. To make this more secure you it is best to use an authentication method to prompt for the username and password. To do this follow these steps:<\/p>\n<p>Edit the config.inc.php file located in C:\\wamp\\apps\/phpmyadmin3.5.1<\/p>\n<p>Look for the line that has auth type and change it the value from config to http as shown below<\/p>\n<p><a href=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2015\/01\/phpMyAdmin-authentication.png?strip=all&w=2560\"><img decoding=\"async\" class=\"alignnone size-medium wp-image-3027\" src=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2015\/01\/phpMyAdmin-authentication-300x181.png?strip=all\" alt=\"phpMyAdmin authentication\" width=\"300\" height=\"181\" srcset=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2015\/01\/phpMyAdmin-authentication-300x181.png?strip=all 300w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2015\/01\/phpMyAdmin-authentication.png?strip=all 415w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2015\/01\/phpMyAdmin-authentication.png?strip=all&amp;w=83 83w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2015\/01\/phpMyAdmin-authentication.png?strip=all&amp;w=166 166w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2015\/01\/phpMyAdmin-authentication.png?strip=all&amp;w=249 249w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p><!--CusAds0-->\n<p>Save the file and then restart WAMP services<\/p>\n<p>Try going to your phpmyadmin page by browsing\u00a0to http:\/\/localhost\/phpmyadmin<\/p>\n<p>You will be prompted to enter a username and password as shown below<\/p>\n<p><a href=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2015\/01\/phpMyAdmin-login.png?strip=all&w=2560\"><img decoding=\"async\" class=\"alignnone size-medium wp-image-3028\" src=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2015\/01\/phpMyAdmin-login-300x206.png?strip=all\" alt=\"phpMyAdmin login\" width=\"300\" height=\"206\" srcset=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2015\/01\/phpMyAdmin-login-300x206.png?strip=all 300w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2015\/01\/phpMyAdmin-login.png?strip=all 513w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2015\/01\/phpMyAdmin-login.png?strip=all&amp;w=102 102w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2015\/01\/phpMyAdmin-login.png?strip=all&amp;w=205 205w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2015\/01\/phpMyAdmin-login.png?strip=all&amp;w=410 410w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<div class=\"lt-box\" style=\"border:1px solid #1d6a9e\"><div class=\"lt-box-title\" style=\"background-color:#2485C6;border-top:1px solid #a7cee8;text-shadow:1px 1px 0 #0b283b\">DO YOU LIKE WHAT YOU'VE READ?<\/div><div class=\"lt-box-content\">Join our subscription list and receive our content right in your mailbox. If you like to receive some Great deals our Freebies then subscribe now!\r\n\r\n<p><div class=\"tnp tnp-subscription \">\n<form method=\"post\" action=\"https:\/\/www.businesslegions.com\/blog\/wp-admin\/admin-ajax.php?action=tnp&amp;na=s\">\n<input type=\"hidden\" name=\"nlang\" value=\"\">\n<div class=\"tnp-field tnp-field-firstname\"><label for=\"tnp-1\">Name<\/label>\n<input class=\"tnp-name\" type=\"text\" name=\"nn\" id=\"tnp-1\" value=\"\" placeholder=\"\"><\/div>\n<div class=\"tnp-field tnp-field-email\"><label for=\"tnp-2\">Email<\/label>\n<input class=\"tnp-email\" type=\"email\" name=\"ne\" id=\"tnp-2\" value=\"\" placeholder=\"\" required><\/div>\n<div class=\"tnp-field tnp-field-button\" style=\"text-align: left\"><input class=\"tnp-submit\" type=\"submit\" value=\"Subscribe\" style=\"\">\n<\/div>\n<\/form>\n<\/div>\n<\/p>\r\n\r\n<\/div><\/div><!--CusAds0-->\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>By default, phpMyAdmin on WAMP automatically logs in using the root user account. To make this more secure you it is best to use an authentication method to prompt for the username and password. To do this follow these steps: Edit the config.inc.php file located in C:\\wamp\\apps\/phpmyadmin3.5.1 Look for the line that has auth type [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3028,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,1043],"tags":[215,1560,593,213],"class_list":["post-3013","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology","category-websites","tag-login","tag-phpmyadmin","tag-setup","tag-username"],"_links":{"self":[{"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/posts\/3013","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/comments?post=3013"}],"version-history":[{"count":3,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/posts\/3013\/revisions"}],"predecessor-version":[{"id":3441,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/posts\/3013\/revisions\/3441"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/media\/3028"}],"wp:attachment":[{"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/media?parent=3013"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/categories?post=3013"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/tags?post=3013"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}