{"id":8412,"date":"2020-10-10T06:13:23","date_gmt":"2020-10-10T06:13:23","guid":{"rendered":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?p=8412"},"modified":"2025-05-30T13:06:32","modified_gmt":"2025-05-30T12:06:32","slug":"how-to-solve-the-password-is-forbidden-phpmyadmin-login-error","status":"publish","type":"post","link":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-solve-the-password-is-forbidden-phpmyadmin-login-error\/","title":{"rendered":"How to Solve the \u201cPassword is Forbidden\u201d PhpMyAdmin Login Error?"},"content":{"rendered":"<p>On a development server, at least once this situation occurs when the MySQL won\u2019t set up with a root password.<\/p>\n<h3>Preflight Check<\/h3>\n<ul>\n<li>Login without a password is not allowed by configuration (see <strong>AllowNoPassword<\/strong>).<\/li>\n<li>Here we will be using Ubuntu 15.04 server, and logged in as root.<\/li>\n<\/ul>\n<h3>The Error<\/h3>\n<p>You will get an error as <strong>\u201cLogin without a password is forbidden by configuration (see AllowNoPassword)\u201d<\/strong> as shown below:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10459\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/10\/Error-Login-without-a-password-is-forbidden-by-configuration-see-AllowNoPassword-SOLVED-01-min.png\" alt=\"\" width=\"406\" height=\"64\" \/><\/p>\n<h3>The Solution<\/h3>\n<p>You can easily enable the ability to manage MySQL via phpMyAdmin (when the root login has no password). It is as easy as changing two lines in the configuration file.<\/p>\n<p>Let\u2019s set the <strong>AllowNoPassword<\/strong> variable, included in phpMyAdmin\u2019s configuration file, to <strong>TRUE<\/strong>. On an Ubuntu 18.04 LTS server, modify the below file:<\/p>\n<pre class=\"lang:default decode:true \">vim \/etc\/phpmyadmin\/config.inc.php<\/pre>\n<p>Type in a forward slash<strong> \u201c\/\u201d<\/strong> to start searching of the file. Type in <strong>\u201cAllow\u201d<\/strong> which will display the below line:<\/p>\n<pre class=\"lang:default decode:true \">\/\/ $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;<\/pre>\n<p>Now, uncomment that line. For this, just remove the two forward slashes <strong>\u201c\/\/\u201d<\/strong> at the start of the line. Also note that there are two instances of this line in the configuration file.<\/p>\n<p>Ensure that you uncomment both!<\/p>\n<p>Next, exit and save the file with the below command:<\/p>\n<pre class=\"lang:default decode:true \">:wq<\/pre>\n<h3>Conclusion<\/h3>\n<p>After making this change, and later re-adding a password to phpMyAdmin, you can any time go back in and re-comment these lines if you want to disable this setting. You can easily modify configuration settings like these to behave in the way you want because Linux addresses almost all files as flat files.<\/p>\n<div class=\"kb-wisdom-wrapr kb-wisdom-bulb kb-wisdom-wrapr-green\">\n<div class=\"kb-wisdom-col kb-wisdom-col-icon\">\n<div class=\"kb-wisdom-icon\">\n<div><\/div>\n<\/div>\n<\/div>\n<div class=\"kb-wisdom-col kb-wisdom-col-content\">\n<p><strong>Also Read<\/strong><\/p>\n<p><a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/a-complete-guide-to-using-phpmyadmin\/\" target=\"_blank\" rel=\"noopener\"><strong>A Complete Guide To Using phpMyAdmin<\/strong><\/a><br \/>\n<a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-can-i-run-sql-queries-in-phpmyadmin\/\" target=\"_blank\" rel=\"noopener\"><strong>How can I run SQL queries in phpMyAdmin?<\/strong><\/a><\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>On a development server, at least once this situation occurs when the MySQL won\u2019t set up with a root password. Preflight Check Login without a password is not allowed by configuration (see AllowNoPassword). Here we will be using Ubuntu 15.04 server, and logged in as root. The Error You will get an error as \u201cLogin [&hellip;]<\/p>\n","protected":false},"author":16,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[925],"tags":[616,1653,1652,1654],"class_list":["post-8412","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-phpmyadmin","tag-phpmyadmin","tag-phpmyadmin-error","tag-phpmyadmin-login-error","tag-phpmyadmin-password-is-forbidden"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Solve the \u201cPassword is Forbidden\u201d phpMyAdmin Login Error?<\/title>\n<meta name=\"description\" content=\"The article reveals the solution to \u201cPassword is Forbidden\u201d phpMyAdmin login error.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-solve-the-password-is-forbidden-phpmyadmin-login-error\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Solve the \u201cPassword is Forbidden\u201d phpMyAdmin Login Error?\" \/>\n<meta property=\"og:description\" content=\"The article reveals the solution to \u201cPassword is Forbidden\u201d phpMyAdmin login error.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-solve-the-password-is-forbidden-phpmyadmin-login-error\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2020-10-10T06:13:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-30T12:06:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/04\/submit_code_lp.png\" \/>\n\t<meta property=\"og:image:width\" content=\"968\" \/>\n\t<meta property=\"og:image:height\" content=\"215\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Pallavi Godse\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Pallavi Godse\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-solve-the-password-is-forbidden-phpmyadmin-login-error\/\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-solve-the-password-is-forbidden-phpmyadmin-login-error\/\",\"name\":\"How to Solve the \u201cPassword is Forbidden\u201d phpMyAdmin Login Error?\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-solve-the-password-is-forbidden-phpmyadmin-login-error\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-solve-the-password-is-forbidden-phpmyadmin-login-error\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/10\/Error-Login-without-a-password-is-forbidden-by-configuration-see-AllowNoPassword-SOLVED-01-min.png\",\"datePublished\":\"2020-10-10T06:13:23+00:00\",\"dateModified\":\"2025-05-30T12:06:32+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945\"},\"description\":\"The article reveals the solution to \u201cPassword is Forbidden\u201d phpMyAdmin login error.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-solve-the-password-is-forbidden-phpmyadmin-login-error\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-solve-the-password-is-forbidden-phpmyadmin-login-error\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-solve-the-password-is-forbidden-phpmyadmin-login-error\/#primaryimage\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/04\/submit_code_lp.png\",\"contentUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/04\/submit_code_lp.png\",\"width\":968,\"height\":215},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-solve-the-password-is-forbidden-phpmyadmin-login-error\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Solve the \u201cPassword is Forbidden\u201d PhpMyAdmin Login Error?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945\",\"name\":\"Pallavi Godse\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eefc9695ea2b2c6e143c9c9919701aaa?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eefc9695ea2b2c6e143c9c9919701aaa?s=96&d=blank&r=g\",\"caption\":\"Pallavi Godse\"},\"description\":\"Pallavi is a Digital Marketing Executive at MilesWeb and has an experience of over 4 years in content development. She is interested in writing engaging content on business, technology, web hosting and other topics related to information technology.\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/pallavi\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Solve the \u201cPassword is Forbidden\u201d phpMyAdmin Login Error?","description":"The article reveals the solution to \u201cPassword is Forbidden\u201d phpMyAdmin login error.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-solve-the-password-is-forbidden-phpmyadmin-login-error\/","og_locale":"en_GB","og_type":"article","og_title":"How to Solve the \u201cPassword is Forbidden\u201d phpMyAdmin Login Error?","og_description":"The article reveals the solution to \u201cPassword is Forbidden\u201d phpMyAdmin login error.","og_url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-solve-the-password-is-forbidden-phpmyadmin-login-error\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2020-10-10T06:13:23+00:00","article_modified_time":"2025-05-30T12:06:32+00:00","og_image":[{"width":968,"height":215,"url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/04\/submit_code_lp.png","type":"image\/png"}],"author":"Pallavi Godse","twitter_misc":{"Written by":"Pallavi Godse","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-solve-the-password-is-forbidden-phpmyadmin-login-error\/","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-solve-the-password-is-forbidden-phpmyadmin-login-error\/","name":"How to Solve the \u201cPassword is Forbidden\u201d phpMyAdmin Login Error?","isPartOf":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-solve-the-password-is-forbidden-phpmyadmin-login-error\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-solve-the-password-is-forbidden-phpmyadmin-login-error\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/10\/Error-Login-without-a-password-is-forbidden-by-configuration-see-AllowNoPassword-SOLVED-01-min.png","datePublished":"2020-10-10T06:13:23+00:00","dateModified":"2025-05-30T12:06:32+00:00","author":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945"},"description":"The article reveals the solution to \u201cPassword is Forbidden\u201d phpMyAdmin login error.","breadcrumb":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-solve-the-password-is-forbidden-phpmyadmin-login-error\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-solve-the-password-is-forbidden-phpmyadmin-login-error\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-solve-the-password-is-forbidden-phpmyadmin-login-error\/#primaryimage","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/04\/submit_code_lp.png","contentUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/04\/submit_code_lp.png","width":968,"height":215},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-solve-the-password-is-forbidden-phpmyadmin-login-error\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"How to Solve the \u201cPassword is Forbidden\u201d PhpMyAdmin Login Error?"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945","name":"Pallavi Godse","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/eefc9695ea2b2c6e143c9c9919701aaa?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eefc9695ea2b2c6e143c9c9919701aaa?s=96&d=blank&r=g","caption":"Pallavi Godse"},"description":"Pallavi is a Digital Marketing Executive at MilesWeb and has an experience of over 4 years in content development. She is interested in writing engaging content on business, technology, web hosting and other topics related to information technology.","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/pallavi\/"}]}},"views":512,"_links":{"self":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/8412","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=8412"}],"version-history":[{"count":1,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/8412\/revisions"}],"predecessor-version":[{"id":8415,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/8412\/revisions\/8415"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=8412"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=8412"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=8412"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}