DEV Community

Devtonight
Devtonight

Posted on • Updated on • Originally published at devtonight.com

How to fix phpMyAdmin “Login without a password is forbidden by configuration” error?

This is a security measure implemented by phpMyAdmin to block blank password logins. But we can easily disable it by changing the configuration file of phpMyAdmin. Enter the following command in the terminal, it will open the configuration file of phpMyAdmin with a terminal-based text editor, called Nano.

sudo nano /etc/phpmyadmin/config.inc.php
Enter fullscreen mode Exit fullscreen mode

Then, press Ctrl + w. Search for “AllowNoPassword” (without quotes). Then the cursor will be on the required line, uncomment that line by removing the // of that line. Now that line should be like this.

$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
Enter fullscreen mode Exit fullscreen mode

Press Ctrl + o and press the enter key to save the phpMyAdmin configuration file. Then press Ctrl + x to exit from the Nano text editor.

Go http://localhost/phpmyadmin and try again to log in. Perhaps, still, you might not be able to log in due to the default MySQL Unix Socket based authentication. You might get a new error called "mysqli_real_connect(): (HY000/1698): Access denied for user ‘root’@'localhost'. Under such a case, read how to fix mysqli_real_connect(): (HY000/1698): Access denied for user ‘root’@'localhost' error question which explains how to fix it.

Top comments (0)