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

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/config.inc.php

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 :wq.

Try a Free Cloud Server.

Trying a new server is a breeze, and it’ll be up and running in only a few minutes...

Be Sociable, Share!
Here's $75, Launch a New VPS Today. Find out why 30,000 customers have chosen our Best-in-Class Performance & 24x7 Heroic Support.