How to login without password in phpMyAdmin

phpMyAdmin is a popular administration tool for MySQL and MariaDB. It is normally configured to disable login without a password due to security reasons.

To enable login to MySQL / MariaDB with no password in phpMyAdmin, you’ll need to configure AllowNoPassword option in phpMyAdmin’s configuration.

  1. Make sure your MySQL or MariaDB user is given an empty password.
  2. Open phpMyAdmin configuration file config.inc.php using your preferred text editor. If it does not exist, copy config.sample.inc.php then rename it to config.inc.php.
  3. Search for AllowNoPassword options and set the value to true.
    1
    $cfg['Servers'][$i]['AllowNoPassword'] = true;
  4. Save and exit the text editor.
  5. Log in again without a password.

Note: Tested on phpMyAdmin 5.2.1