Can anyone confirm that phpMyAdmin AllowNoPassword works with MySQL databases?

php mysql apache passwords phpmyadmin

diggersworld · May 6, 2011 · Viewed 151.3k times · Source

I have a version of phpMyAdmin located on my local Apache server.

I am trying to login without a password however phpMyAdmin keeps throwing the warning:

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

However in my config.php file for phpMyAdmin I have set:

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

So I don't know why the message is still appearing.

Answer

Copy config.sample.inc.php to config.inc.php.

In most cases you will find the config file
- on linux: /etc/phpmyadmin/config.inc.php
- on mac: /Library/WebServer/Documents/phpmyadmin/config.inc.php
If you are trying to log in as root, you should have the following lines in your config:

$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['AllowNoPassword'] = true;