How to Solve the “Password is Forbidden” phpMyAdmin Login Error?

[ad_1]

On a development server, at least once this situation occurs when the MySQL won’t set up with a root password.

Preflight Check

  • Login without a password is not allowed by configuration (see AllowNoPassword).
  • Here we will be using Ubuntu 15.04 server, and logged in as root.

The Error

You will get an error as “Login without a password is forbidden by configuration (see AllowNoPassword)” as shown below:

The Solution

You can easily enable the ability to manage MySQL via phpMyAdmin (when the root login has no password). It is as easy as changing two lines in the configuration file.

Let’s set the AllowNoPassword variable, included in phpMyAdmin’s configuration file, to TRUE. On an Ubuntu 18.04 LTS server, modify the below file: