(phpMyAdmin error) Login without a password is forbidden by configuration (see Allownopassword) in Ubuntu

Source: Internet
Author: User
Tags phpmyadmin

1.Go to/etc/phpmyadmin/config.inc.php and open it your favorite editor.

2.Search for below line of code

$cfg [' Servers '] [$i] [' allownopassword '] = TRUE;   

Code lines would be looks like:-

if (!  Empty (//more code here/* Uncomment the following to enable logging on to passwordless accounts, * after taking not E of the associated security risks. *  //$cfg [' Servers '] [$i] [' allownopassword '] = TRUE;  $i + +;}    

and uncomment the //$cfg [' Servers '] [$i] [' allownopassword '] = TRUE; (Just remove "//" from start) to make login in phpMyAdmin with password

$cfg [' Servers '] [$i] [TRUE;  

Note:-if you are using older version of PHP then could be there was another same line of code so you need to uncomment also These lines like

if (! Empty ( $dbname)) { //other configuration options< Span class= "indent" >  $cfg [ ' Servers '][ $i][< Span class= "string" > ' Allownopassword '] = true;  $i + +;} //another code found Here $cfg [ Span class= "string" > ' Servers '][ $i][ ' Allownopassword '] = true;                

3.Save your file and do try to login your phpMyAdmin without password. If you still has issue try to restart your Apache services by following command. For more how to restart Apache Ubuntu

Su doservice apache2 Restart

4.If still facing issue you need reinstall MySQL again by running following command through terminal. How do I install MySQL?

Su doapt-get install mysql-server mysql-common mysql-client 

and run your phpmyadmin and login without password now you do have the fixed error login without a password is fo Rbidden by configuration (see Allownopassword) in Ubuntu.

(phpmyadmin error) Login without a password is forbidden by configuration (see Allownopassword) in Ubuntu

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.