[FIXED] Mamp Pro Restore root user / uninstall

Issue

Hi in Mamp Pro I accidentally removed the root account, so I now cannot use mysql to create new databases and all other operations.

This is the error I get when startng mysql via mamp pro:

Checking MySQL databases failed Error message: /Applications/MAMP/Library/bin/mysqlcheck: Got error: 1044: Access denied for user 'root'@'localhost' to database 'mysql' when selecting the database

I have tried to reset to factory settings but that hasn't helped.

Basically in the users overview in Phpmyadmin, I just get a yellow box saying "No privileges".

I also tried to uninstall Mamp Pro, but when I tick the uninstaller's checkboxes and hit uninstall, I get the following error:

Error The privileged action failed.

Help would be really appreciated since I cannot do any work like this.

Solution

MAMP evidently creates some configuration files that can't be wiped via the uninstaller. I was able to circumvent the The privileged action failed error and completely uninstall MAMP Pro using the following steps:

1. Delete the appsolute directory from /Library/Application Support , which contains configuration files that are created upon MAMP Pro installation
2. Delete the file hosts.mamp.bak in /etc, which is the MAMP hosts backup file
3. Delete the MAMP directory from /Applications/MAMP
4. Open the MAMP Pro Uninstaller, check all five options, and click to uninstall

This should completely wipe the existing MAMP/MAMP Pro installation and enable a clean, fresh install. You may need to restart your computer to get Apache running after re-installation.

Answered By - zeantsoi