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