You will get the below error when logging in to phpMyAdmin without a password, even if your actual MySQL account itself is passwordless. It is because phpMyAdmin is normally configured to disable passwordless login due to security reasons.

Login without a password is forbidden by configuration (see AllowNoPassword)

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

Steps to allow no-password login to MySQL / MariaDB in phpMyAdmin:

  1. Make sure your MySQL or MariaDB user is passwordless and accessible by phpMyAdmin's system user.

    User root by default requires system's administrator privilege to log in.
    Related: How to connect to root MySQL account without sudo

  2. Open phpMyAdmin configuration file using your preferred text editor.
    $ sudo vi /etc/phpmyadmin/config.inc.php
  3. Search for ServersAllowNoPassword options and set the value to TRUE.
    $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;

    Remove // at the start of the line if exist to uncomment the option.

    Depending on distributions, there could be multiple occurrences of that particular line. Ubuntu for example has the following 2 lines;

    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;
  4. Save and exit the text editor.
  5. Log in again via phpMyAdmin without password.
Discuss the article:

Comment anonymously. Login not required.

Share!