By jmclaine on

Hi, I'm using MAMP to develop my drupal 6 site before going online. I've got drupal up and running, meaning I've created my first database and also created an adminsitrator for the "site." But I cannot seem to change the orginal database password assigned by MySQL without losing access.

I used the command,

/Applications/MAMP/Library/bin/mysqladmin -u root -p password

to changed the mySQL password and I even changed the password in both drupal/sites/default/settings.php and /Applications/MAMP/bin/phpMyAdmin/config.inc.php files.

The faq for MAMP says you have to change the password with the above MySQL command as well as in the config.inc.php file, and any other scripts running under MAMP, but what other scripts would it be referring to?

Any help is greatly appreciated.

⋅ Categories: Drupal 6.x

Comments

Anonymous’s picture

Anonymous (not verified) commented

Don't know if you are still having this problem, but I spent the morning figuring this out, so I figured I'd post to threads about it.

I found this on another forum, living-e AG:

Here's a list of files you need to edit:

/Applications/MAMP/bin/phpMyAdmin-X.X.X/config.inc.php
/Applications/MAMP/bin/mamp/index.php
/Applications/MAMP/bin/stopMysql.sh (if you don't change this one you can have zombie mysqld's running after you thought you stopped the server)

Smag’s picture

Smag commented

Linclark: I changed the password values in the files you listed. I shut down MAMP, restarted PHP and MySQL, and then opened the MAMP "start page" and sure enough, I got the "everything's working" page that signaled that the new MySQL password was being used by the Mamp site. However, when I clicked on PhpMyAdmin in the MAMP site navigation I got an error "could not log into MySQL server, check host, username, password." I opened the config.inc.php file again to doublecheck that the new MySQL password was correct. It was. I saved, tried the whole thing again. Still error.

Then I changed the auth_type to http, and this time, when I went to PhpMyAdmin, I was prompted to enter the MySQL username and password (twice, once for each frame). So, I think I'll use cookie as the auth_type, and then I won't have to login each time.

Thanks again.