Can anyone confirm that phpMyAdmin AllowNoPassword works with MySQL databases?
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;