By Bsmithwbtv on
Hello
So I've had this problem for quite awhile now (/Applications/MAMP/Library/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect). I'm trying to start up my website & can't start until I access my Mysql files in MAMP. I've tried going into index.php & changing the proot password although I don't think I'm doing that right? please help!!
Comments
MAMP
You will need to use the Terminal App and follow the directions at:
http://canuckamerica.blogspot.com/2008/01/reseting-your-mysql-password-i...
A list of some of the Drupal sites I have designed and/or developed can be viewed at motioncity.com
Unfortunately this doesn't
Unfortunately this doesn't work either, accessing my terminal just gives me an error report the same as if im trying to log on in MAMP
,
Do you just have a red dot next to MySql? Maybe try this: http://twob.net/journal/fix-for-mamp-mysql/ I notice that MAMP and MySql error out a lot more on my laptop.
If this is not the case and it is truly just the root password, I think you will have to google around about resetting the password.
A list of some of the Drupal sites I have designed and/or developed can be viewed at motioncity.com
No red dots both are green, I
No red dots both are green, I think it's the root password to, but I've changed the password from root to another, I changed it back to root, I've changed it in almost every file in applications>mamp>bin>etc.... I've done the killall-9.. once or twice and still no results.
I appreciate your help very much, but It's coming down to the wire and I don't know what to do. I've spent 2 days googling every blog/forum on this problem and every suggestion has not worked for me. I tried to re-install MAMP but I need to buy version Mac OS X 10.6.6 on my computer or it won't install. Unfortunately that would end up being a work expense that my boss isn't to happy to do & wants to see if theirs anyway to get around it. I seriously have never encountered something so frustrating as this.
If it were me -- I would move
If it were me -- I would move on to just developing the site on the server on the Internet. I develop half my sites that way. It makes collaborating and demoing issues much easier.
If you still wanted to try and use MAMP I guess you could consider creating a new user on your Mac and start up from that user. And see if that allows you to configure the system again.
By the way, I have never heard of anyone editing the files in MAMP directly. My understanding is that these changes are to be done through terminal.
Also, I assume you have tried using your Mac's password instead at some point. (I doubt this is the issue.) Beyond those suggestions I am of no help.
Good Luck
A list of some of the Drupal sites I have designed and/or developed can be viewed at motioncity.com
I may not be using the right
I may not be using the right terms either, what I meant to say is that I've gone into /Applications/MAMP/bin/phpMyAdmin-X.X.X/config.inc.php & changed the password their next I went to /Applications/MAMP/bin/mamp/index.php & changed the password in/Applications/MAMP/bin/stopMysql.sh, people who were having the same problems as me were told to change their passwords in these files as this may fix the solution.
I'm not web designer by trade & I was told that Drupal is alot easier at designing a website for the inexperienced. While designing the site I did learn alot & with this finished site I'm just trying to get it online now. We have a domain name and our webhost is lunar pages. & I downloaded an FTP program filezilla.
I guess my question is what files & how do I get those drupal files into the public.html folder in my FTP program. Lunar Pages Tec support said I need to access my MySQL files, so that why I've been trying to fix this MAMP problem because I am told to believe they reside somewhere in their.
Like I said I'm not a web designer, but I'm appreciating the advice your giving me. As most other web designers I know aren't familiar with drupal.
mamp
This problem isn't really a Drupal issue. This is a problem with MAMP.
I'm confused because you first said you were trying to start your site, but now it sounds like you are ready to upload your site. If the second one is true, you just need to get to your database. Can you get to the start page? Either visit
localhost:8888/MAMP/?language=English
or click on the "Open Start Page" button.
If so, you can click on the top menu "PHPmyAdmin". On the next page, click on the database you are using. Click on "Export" go to the bottom of the page, check "save File" and click "Go" From there, you can upload all your files and create a new database and db user and upload this one into it.
If not, I am afraid I cannot help you and you'll need to find a MAMP expert or someone that might advise on how to get the database out of there.
A list of some of the Drupal sites I have designed and/or developed can be viewed at motioncity.com
It may sound stupid, but just
It may sound stupid, but just check, double-check, and triple-check that you have all your DB settings correct in settings.php. (database, username, password, host, etc... in the $database array declaration)
I thought I was spot on, got the same error. Checked it again, it looked right, still error. Checked it a third time and found one character off. Fixing that got rid of the error.
cheers.