WordPress.org

1. JohnKendrick
   Member
   Posted 1 month ago #

   I made the mistake of trying to tweak something in MAMP (running MAMP on a Mac Pro) tonight and lost contact with the database.

   When I reboot MAMP, I get the following message from Firefox: Checking MySQL database failed.

   And the attempt to boot MAMP, brings up the following error message:

   Error message:

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

   Since the password is 'root' and the script attempts to use the password 'YES', how could I fix this?

   Any help would be appreciated.

   John Kendrick

2. Shane G
   Member
   Posted 1 month ago #

   Hi,

   Make sure that you have assigned proper permissions to MySQL database user. Also added that user to the database user group. Reset and check the database configuration details with wp-config.php file.

   Thanks,

   Shane G.

3. JohnKendrick
   Member
   Posted 1 month ago #

   Thanks for the quick reply, Shane.

   My problem is that, given my status as a rank beginner, the only access I know I have to the MySQL database configuration is via the browser window when I boot up MAMP. And I'm denied access at precisely that point. And, if I understand that error message correctly, the my MAMP startup script uses the password 'YES' when it should be using 'root'.

   You suggest I check the wp-config.php file. I can see it but have no way to know what the php means.

   Is there a specific piece of text I should, for instance, change a 'YES' to a 'root?'

   John

4. jeffr0
   Member
   Posted 1 month ago #

   Look for something like this in wp-config.php

   /** MySQL database password */
   define('DB_PASSWORD', '');

   change it to
   

   /** MySQL database password */
   define('DB_PASSWORD', 'YES');

5. JohnKendrick
   Member
   Posted 1 month ago #

   Tried it but it didn't work. Something else is going on. Is there a password file in the MAMP application folders?

6. JohnKendrick
   Member
   Posted 1 month ago #

   I've now concluded that my problem above is in MAMP and is a consequence of a misstep when I was installing Joomla. I did something to block access to MySQL. I have no idea what.

   So I've decided the next best strategy is to reinstall MAMP. I would like to save all my Word Press files work, if possible, however. The problem is that some of the WordPress work is in the MAMP folder.

   1. At the moment, both the main set of files are in a WordPress older in the sites secton outside the MAMP folder. Thus, they are not in the htdocs folder. So no problem there.

   2. However, I see in the 'db' folder in the MAMP folder, another folder labeled 'mysql'. It, in turn, contains WordPress related files for my work. I would love to be able to save them and replace them here once I complete a reinstall of MAMP.

   3. So my questions:
   a. Is that overall strategy--reinstall MAMP--likely to solve my problem?
   b. Can I copy the MAMP/db/mysql/wordpress materials out prior to the reinstall, and then replace the contents of that reinstalled folder with my old materials. And expect them to work?

   Any help is much appreciated,

   John Kendrick

Reply

You must log in to post.