Posted by rotnme on November 15, 2010 at 5:44am
Can anyone shed some light on how to get rid of this error message?
Error message:
Checking MySQL databases failed
Enter password:
/Applications/MAMP/Library/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect
driving me insane. thanks.........
Comments
password
I don't know a) where you're seeing this error, b) what process is generating this output or c) whether the process is triggered (automatic) or manual, but it sounds like the stored password for your root account for that process is incorrect.
error
I start MAMP and all loads as it should, start page loads and says that all is working. Then another small window opens with that message. All seems to be working as it should, I just can't figure out how to make this go away. I went thru all the password locations and all seems as it should be.
Enter password:
/Applications/MAMP/Library/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect
I go to applications/mamp/library/bin/mysqlcheck, it opens in terminal but I am unable to edit. Tried opening with textwrangler, textedit, no luck. Frustrating.
OK
So it's a little more clear to me now. Firstly, mysqlcheck is either a script or a binary; you're not meant to load it directly into a text editor; you call it from a shell. Something's calling it from a script, as I read it here: http://drupal.org/node/49710 MAMP loads the web page with tabs to various MAMP applications. It sounds like you might have changed your password for your mysql root account? If so, you will need to update your phpmyadmin config, as this page describes http://drupal.org/node/49710. You'll see someone had a problem similar to yours, search the page for "mysqlcheck" to start that part of the thread. You can update your phpmyadmin password at: /Applications/MAMP/bin/phpMyAdmin-X.X.X/config.inc.php (x equals whatever version you're running)
but that's just my guess.
This is crazy........ I've
This is crazy........ I've followed everything to the letter, have changed passwords everywhere and am still getting this message. What's interesting, when I go to what the error message says, applications/mamp/library/bin/mysqlcheck, it opens in text edit but its all jibberish, if this were legible perhaps I could find the problem? Tried to copy and paste but it won't go thru.
˛∫æ
˛∫æ
It's not crazy
I addressed that specifically, did you read my post?
/bin = binary. You should
/bin = binary. You should not try to modify it in any way.
I think the default use and password for MAMP is u: root and p: root. How you've managed to alter it without MAMP knowing about the change is a mystery to me. There are config files inside the MAMP folder that may be revealing, but it won't be a simple task. You may have to reinstall it (backup your code and data!).
Ken Winters