Once in a while, perhaps on a Development server, MySQL will not be set up 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.
This error relates to logging into phpMyAdmin, an open source tool used for the administration of MySQL.
- 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 will read "Login without a password is forbidden by configuration (see AllowNoPassword)" as shown below.
Enabling the ability to manage MySQL via PhpMyAdmin (when the root login has no password) is as easy as changing two lines in the configuration file.
We will set the AllowNoPassword variable, located in PhpMyAdmin's configuration file, to TRUE. On an Ubuntu 18.04 LTS server, edit the following file.
For a refresher on editing files with vim see: New User Tutorial: Overview of the Vim Text Editor
Next, type in a forward slash "/" to begin a search of the file. Type in "Allow" which will show the following line.
// $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
Now, uncomment that line. To accomplish this, simply remove the two forward slashes "//" at the beginning of the line. It should be noted that there are two instances of this line in the configuration file.
Be SURE to uncomment both!
Then, exit and save the file using the following command,
Once you have made this change, and later re-added a password to PhpMyAdmin, you can always go back in and re-comment these lines to disable this setting. Because of the way Linux addresses most all files as "flat files", configuration settings like these can be easily modified to behave in the way you want!
Talk To An Expert!
We pride ourselves on being The Most Helpful Humans In Hosting™!
Our Support Team is full of experienced Linux technicians and talented System administrators who have intimate knowledge of multiple web hosting technologies, especially those discussed in this article.
Should you have any questions regarding this information, we are always available to answer any inquiries about issues related to this article, 24 hours a day, 7 days a week 365 days a year.
If you are a Fully Managed VPS server, Cloud Dedicated, VMWare Private Cloud, Private Parent server, Managed Cloud Servers, or a Dedicated server owner and you are uncomfortable with performing any of the steps outlined, we can be reached via phone @800.580.4985, a chat or support ticket to assisting you with this process.
Our Sales and Support teams are available 24 hours by phone or e-mail to assist.