Can anyone confirm that phpMyAdmin AllowNoPassword works with MySQL databases?
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.
-
Copy
config.sample.inc.php
toconfig.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
- on linux:
-
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;
According to this: https://www.simplified.guide/phpmyadmin/enable-login-without-password
This $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
should be added twice in /etc/phpmyadmin/config.inc.php
if (!empty($dbname)) {
// other configuration options
$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
// it should be placed before the following line
$i++;
}
// other configuration options
$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
I tested the statement:
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = true;
It did not work out for me.
Instead
$cfg['Servers'][$i]['AllowNoPassword'] = true;
worked.
Thanks!