Login without a password is forbidden by configuration (see AllowNoPassword) in ubuntu

Just upgraded ubuntu to 15.04 and checked my all config is as it is. Found all is ok Then i started my phpmyadmin and found error “Login without a password is forbidden by configuration (see AllowNoPassword)” in ubuntu. Before this i am just using as normal machine user “root” without password to access my phpmyadmin. Searched with same error keyword on google and found many helpful answers that have fixed my error, We just need to allow password less MySQL root login via phpMyAdmin, just need AllowNoPassword set to TRUE to fix error Login without a password is forbidden by configuration (see AllowNoPassword) in ubuntu.

Steps to solve Login without a password is forbidden by configuration (see AllowNoPassword) in ubuntu

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 will be looks like :- if (!empty($dbname)) { //More code here /* Uncomment the following to enable logging in to passwordless accounts, * after taking note of the associated security risks. */ // $cfg['Servers'][$i]['AllowNoPassword'] = TRUE; /* Advance to next server for rest of config */ $i++; }

And uncomment the //$cfg['Servers'][$i]['AllowNoPassword'] = TRUE; (just remove “//” from start) to make login in phpmyadmin with password /* Uncomment the following to enable logging in to passwordless accounts, * after taking note of the associated security risks. */ $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;

Note :- If you are using older version of php then may be there is another same line of code so you need to uncomment also these lines like. if (!empty($dbname)) { // other configuration options $cfg['Servers'][$i]['AllowNoPassword'] = TRUE; $i++; } // another code found here $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;

3. Save your file and done try to login your phpmyadmin without password. If you still have issue try to restart your apache services by following command.

4. If you still facing issue you need reinstall mysql again by running following command through terminal.

And run your phpmyadmin and login without password now you are done you have fixed error Login without a password is forbidden by configuration (see AllowNoPassword) in ubuntu.