• 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

Viewing 5 replies - 1 through 5 (of 5 total)
  • 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.

    Thread Starter JohnKendrick

    (@johnkendrick)

    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

    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');

    Thread Starter JohnKendrick

    (@johnkendrick)

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

    Thread Starter JohnKendrick

    (@johnkendrick)

    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

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Error 1045’ is closed to new replies.