MAMP’s MySQL root user password is set to root by default and changing it is not as straightforward as it perhaps should be.
Previously, I described how to successfully change the root user password providing that you know the current one. If not, this method will not work and a way of re-setting the root user password is required.
Having MAMP’s Apache and MYSQL servers start at login is as simple as checking the Start Servers when starting MAMP option in MAMP’s preferences and adding MAMP.app to the Login Items.
However, some user intervention is needed if using the standard ports for Apache: 80 and MySQL: 3306 instead of MAMP’s default ports. In this case MAMP will require a password when it starts as port 80 is a privileged port.
Having recently changed my local testing server environment from XAMPP to MAMP v2.x I wanted to change the password for the MySQL root user. By default it’s set to root.
Changing the MySQL password for the root user was straightforward enough, but locating and editing the files to reflect the new password was a little more challenging.