phpMyAdmin Login Error: [SOLVED]

Reading Time: < 1 minute

This error relates to logging into phpMyAdmin, an open source tool used for the administration of MySQL.

Once in awhile, perhaps on a Development server, MySQL won’t be setup with a root password. The aforementioned configuration is generally thought of as against best practices however, if it is what you’re dealing with, then it could also interfere with phpMyAdmin.

Pre-Flight Check

  • These instructions are intended specifically for solving the error: Login without a password is forbidden by configuration (see AllowNoPassword).
  • I’ll be working from a Liquid Web Self Managed Ubuntu 15.04 server, and I’ll be logged in as root.

The Error

The error will read “Login without a password is forbidden by configuration (see AllowNoPassword)” as shown below.

Error Login without a password is forbidden by configuration (see AllowNoPassword) [SOLVED]

The Solution

Enabling the ability to manage MySQL via phpMyAdmin (when the root login is passwordless) is as easy as changing one line in a configuration file.

We’ll set the AllowNoPassword variable, located in phpMyAdmin’s configuration file, to TRUE. On an Ubuntu 15.04 server edit the following file:

vim /etc/phpmyadmin/

For a refresher on editing files with vim see: New User Tutorial: Overview of the Vim Text Editor

Find the line:

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

Uncomment that line; you’ll remove the //.

There are two instances of this line in the configuration file… be SURE to uncomment both of them!

Exit and save the file with the command


Refer a friend and get a $50 hosting credit!