MySQL Forums
Forum List  »  PHP

'Login without a password is forbidden by configuration'
Posted by: r dopfel
Date: March 14, 2014 12:38PM

Hi.
Inside of phpMyAdmin, I chose the Radio Button: 'no password'.
Now I Cannot Login at All.
Error. 'Login without password forbidden by configuration' (see AllowNoPassword)
Error. #1045cannot login to MySQL server

This email looks long but what I did is really simple and mostly in between the ****.

I need some explanation of how phpMyAdmin, MySQL and apache are connected regarding passwords.

Main Issue. I locked myself out; I can no longer log into phpMyAdmin.

1.
Background.
I installed apache, MySQL and phpMyAdmin on my Macbookpro.
From the phpMyAdmin window I logged in like this.
User:root
Password:root

These settings were reflected in my config.inc.php file.
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'root';

2.
My Explanation of how I messed things up.
And how I Did Something That Has Now Confused My Understanding of which levels and which programs require passwords....

I was just beginning to use MySQL within phpMyAdmin.
I was looking under each tab. One was The 'Users' Tab.
There were a few users: 127.0.0.1, Localhost, etc. etc.
None of them had any passwords so I decided to set a password on localhost, since this is what I was using. Password:pass1234
****I do not know what I was thinking then.
****I should have wondered why this 'local host' User showed up w/o a password inside of phpMyAdmin.
Why ?
Because I Was Already Required to type:
Url. localhost/phpMyAdmin/
user:root
Password: root
for me to Even get Inside of phpMyAdmin.

3.
This is even more confusing.
a. I tested this password:pass1234
b. And at the entry URL localhost/phpMyAdmin/
User: root
Password:pass1234

And it Did allow me to login into phpMyAdmin.
S that lead me to believe these passwords were connected.
I am told this is not true.

4.
This was a Big Mistake setting this password.
I read that I should Not set the password here so I went back into the
****Same 'Users' tab and clicked the 'Radio Button' to be
'No Password.' ******for localhost.

I thought that meant when I went to login from the phpMyAdmin entry window that I would just be able to click 'go' without a password.

Since then I Cannot Login At All.
Error. 'Login without password forbidden by configuration' (see AllowNoPassword)
Error. #1045cannot login to MySQL server

I went to the site to reset passwords on unix systems.
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

It is Not Specific enough for me.
I understand how to type in commands.

I am Not certain Where exactly - which command prompt and in which directory I need to type these commands.

What is the name of the .pid file for instance.
The only one I can find is nameOfMyComputer.pid

QUESTION.
Can someone just give me the steps - the commands - from the beginning.
I go in thru 'terminal' on my Mac.

QUESTION.
Can someone explain why This Password 'inside'of phpMyAdmin is 'Not the same' as the password that I was using as 'root' ?


I really appreciate the help.
Thanks

Options: ReplyQuote


Subject
Written By
Posted
'Login without a password is forbidden by configuration'
March 14, 2014 12:38PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.