#Reset mamp mysql password update#
#Reset mamp mysql password password#
#Reset mamp mysql password free#

$link = mysql_connect('localhost', 'root', 'NEWPASSWORD') This file does not exist in MAMP 3.x, 4.x or 5.x but for MAMP 2.x the English version of this file is /Applications/MAMP/bin/mamp/English/index.php:

#Reset mamp mysql password update#

Purely for cosmetic purposes you may also want to update MAMP’s start page to reflect the changed password.

#Reset mamp mysql password password#

If you’re using MAMP 2.x continue reading for some additional changes.įile: /Applications/MAMP/bin/mamp/index.phpįinally, stop and restart MAMP’s MySQL server to complete the password change. If you’re using MAMP 3.x, 4.x or 5.x stop and restart MAMP’s MySQL server to complete the password change. Instructions can be found in the repository’s README.md file. $cfg ='NEWPASSWORD' // MySQL password (only neededĪs an alternative to updating these files manually I’ve written a simple Bash script that runs in Terminal and updates the files with the new password. Applications/MAMP/Library/bin/mysql_upgrade -u root -pNEWPASSWORD -socket=/Applications/MAMP/tmp/mysql/mysql.sock -forceįile: /Applications/MAMP/bin/phpMyAdmin/ Applications/MAMP/Library/bin/mysqladmin -u root -pNEWPASSWORD -socket=/Applications/MAMP/tmp/mysql/mysql.sock shutdownįile: /Applications/MAMP/bin/upgradeMysql.sh * Applications/MAMP/Library/bin/mysqlcheck -all-databases -repair -u root -pNEWPASSWORD -socket=/Applications/MAMP/tmp/mysql/mysql.sockįile: /Applications/MAMP/bin/stopMysql.sh * Applications/MAMP/Library/bin/mysqlcheck -quick -check-upgrade -u root -pNEWPASSWORD -socket=/Applications/MAMP/tmp/mysql/mysql.sock mysqlįile: /Applications/MAMP/bin/repairMysql.sh * Applications/MAMP/Library/bin/mysqlcheck -all-databases -check -check-upgrade -u root -pNEWPASSWORD -socket=/Applications/MAMP/tmp/mysql/mysql.sockįile: /Applications/MAMP/bin/quickCheckMysqlUpgrade.sh * For files marked * an easy way to locate the old password is to search for the string -proot where -p is the password option and root is the old password.įile: /Applications/MAMP/bin/checkMysql.sh * Next, all the occurrences of the old password root need to be changed to the new password NEWPASSWORD in the following files. You’ll be prompted for the current root password: Applications/MAMP/Library/bin/mysqladmin -u root -p password NEWPASSWORD To change the MySQL password for root ensure that MAMP’s MySQL server is running then open Terminal and type the following, replacing NEWPASSWORD with the password of your choice: They are applicable to MAMP versions 2.x, 3.x, 4.x and 5.x but be aware of the slight difference in the changes required.

#Reset mamp mysql password free#

These instructions are for the free version of MAMP not MAMP Pro.

If you’ve forgotten it please refer to Resetting MAMP’s MySQL Root User Password. These instructions are for changing a known password for the root user. Information on MAMP’s own site appeared incomplete and other documentation I found - while helpful - was for versions of MAMP prior to version 2. Applications/MAMP/Library/bin/mysqlcheck: Got error: 1045: Access denied for user (using password: YES) when trying to connect Failure to update all the necessary files results in MAMP reporting the following error: By default it’s set to root.Ĭhanging the MySQL password for the root user was straightforward enough, but locating and editing the files to reflect the new password was a different story. Having recently changed my local testing server environment from XAMPP to MAMP v2.0.5 I wanted to change the password for the MySQL root user.