phpMyAdmin: Login without a password is forbidden by configuration (see AllowNoPassword)

Development environments will not have a root password, generally. But phpMyAdmin has a setting that discourages password-less login. If you do so, you will get the below error.

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

If you still want to setup the password-less login, some people suggests following option. But it didn’t work for me.

phpMyAdmin Config Change

Edit config.inc.php. (Ensure you have a backup before you do so. Otherwise, you may corrupt the whole config file.)

$ sudo vi /etc/phpmyadmin/config.inc.php

You will find a line like this

// $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;

Uncomment this.

Still some of them say it works for their version and Operating system.

Creating a super user for phpMyAdmin

MySQL does not allow root user to login from phpMyAdmin. So you may create a super user for phpmyadmin using the following queries.

CREATE USER 'pmauser'@'localhost' IDENTIFIED WITH mysql_native_password BY '<your password>';
GRANT ALL PRIVILEGES ON . TO 'pmauser'@'localhost' WITH GRANT OPTION;
flush privileges

Feed in the username and password to phpMyAdmin. It worked for me.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top