Solved: “Login without a password is forbidden by configuration (see AllowNoPassword)” in PhpMyAdmin

September 14, 2020 Liquid Web

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.

In this video, we demonstrate how to solve the “Login without a password is forbidden by configuration (see AllowNoPassword)” in PhpMyAdmin.

Commands used:
vim /etc/phpmyadmin/config.inc.php
// $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
(Uncomment both lines, then)
:wq

Video by: Justin Palmer

About the Author

Liquid Web

Liquid Web powers online content, commerce, and potential for SMB entrepreneurs and the designers, developers and digital agencies who create for them. Sign up for our <a href="https://www.liquidweb.com/blog">newsletter</a> to stay up to date with our latest content.

More Content by Liquid Web
Previous Video
How to Solve the VSFTPD 500 OOPS Error
How to Solve the VSFTPD 500 OOPS Error

In this video, we demonstrate how to solve the error: 500 OOPS: vsftpd: refusing to run with writable root ...

Next Video
What is the Difference Between Liquid Web Cloud Servers and VPS Hosting?
What is the Difference Between Liquid Web Cloud Servers and VPS Hosting?

Unsure whether to choose between Cloud Server or VPS Hosting? If you need a turnkey, full cloud VM environm...

Learn What Qualities to Look for in Your Next Host in Our New Guide!

Download Now