Re: 'Login without a password is forbidden by configuration'

[Rick James]

I don't know where AllowNoPassword is coming from. Suggest searching for
phpadmin allownopassword

Meanwhile, if you can get in from "terminal" as root, then
GRANT ALL ON *.* TO foo@"::1" IDENTIFIED BY "bar" WITH GRANT OPTION;
GRANT ALL ON *.* TO foo@"localhost" IDENTIFIED BY "bar" WITH GRANT OPTION;
GRANT ALL ON *.* TO foo@"127.0.0.1" IDENTIFIED BY "bar" WITH GRANT OPTION;

That will let user "foo" get in and have full privileges, but only from the local machine.

For applications, you should create other logins and don't give them full access.