How to install phpMyAdmin on Ubuntu or Debian

By  •  phpMyAdmin

phpMyAdmin is readily available in apt's repository thus can easily be installed from the command line. Installing phpMyAdmin via apt will also install Apache along with PHP and all …
Read More

phpMyAdmin configuration file

By  •  phpMyAdmin

phpMyAdmin configuration is normally stored in and the location of the file varies depending on the distribution.

The table below lists some of the possible locations.

Platform / Distribution Location
Ubuntu / Debian /etc/phpmyadmin/
RedHat / CentOS /etc/phpMyAdmin/
Web download {base installation directory}/

If the does not exist or if specific configuration is absent from the file, default values are used instead.

How to login without password in phpMyAdmin

By  •  phpMyAdmin

You will get the below error when logging in to phpMyAdmin without password even if your actual MySQL account itself is passwordless. This 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 passwordless MySQL login in phpMyAdmin, you’ll need to set AllowNoPassword option in phpMyAdmin‘s configuration to TRUE.

To enable the option, uncomment or add the following line;

$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;

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

// other configuration options
$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;