Appendix A - Changed Root Password And Now I'M Locked Out

[keriah]

Following the (Mac) steps in the Annex A PDF:  

 

I installed MAMP and it was working fine.  On p. A9 I did steps 1-4 to assign a password to the root user via phpMyAdmin.  (The one difference I noted was that at Step 2 there was a "Users" tab rather than one reading "Privileges".)  I clicked to "Edit privileges" for root and typed/confirmed a password (as in Figure C on p A9) and clicked 'Go'.  I got a confirmation of the change.  

 

I then changed the password value in the config.inc.php file in the phpMyAdmin directory, per Step 5, using Textwrangler to edit the one line where the password value is coded.  I saved that file.

 

I stopped both servers using MAMP.  I started both servers.  Clicking on the "Open start page" button fails with this:  Error: Could not connect to MySQL server!  And the additional detail:

 

Error message:

 

/Applications/MAMP/Library/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect

 

I have Quit everything; I have shut down my system and restarted.  I'm still getting this error when I use MAMP.

 

I can edit the config.inc.php to set it back to the default password value, but I'm still locked out because the change in steps 1-4 did work.

[indigetal]

Shouldn't  be an issue, just follow the instructions here as well.

[keriah]

After a bit of research I see that I have (at least) 2 PHP installations on my system.  There is one that I can start/stop and view via MAMP, and there is another that executes when I run the scripts per the book.  So, my best guess is that I wasn't getting the values for 'root' changed in all places.