Can Anyone Confirm That PhpMyAdmin AllowNoPassword Works With MySQL Databases?


Answer :

  1. 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
  2. If you are trying to log in as root, you should have the following lines in your config:

    cfg[Servers][cfg['Servers'][i]['user'] = 'root';
    cfg[Servers][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!


Comments

Popular posts from this blog

Are Regular VACUUM ANALYZE Still Recommended Under 9.1?

Can Feynman Diagrams Be Used To Represent Any Perturbation Theory?