Can anyone confirm that phpMyAdmin AllowNoPassword works with MySQL databases?
Copy
config.sample.inc.phptoconfig.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!