#MAMP MYSQL PASSWORD HOW TO#
#MAMP MYSQL PASSWORD PASSWORD#

If successful the script will display the message Updated /Applications/MAMP/bin/filename.sh with new password 'NEWPASSWORD' for each file updated. In case you have explicitly set a password for root user, then enter that. If OLDPASSWORD is not found in an individual file the script will display the message WARNING: Could not find old password 'OLDPASSWORD' in /Applications/MAMP/bin/filename.sh. It will ask for password, you would need to just press enter as by default password is blank in MAMP mysql user. If either the OLDPASSWORD or the NEWPASSWORD are omitted, the script will exit with the error ERROR: Usage is mamp-mysql.sh OLDPASSWORD NEWPASSWORD. Try to access the phpMyAdmin web page through the Safari browser.

Launch MAMP and click the Start Servers button. The script changes all occurrences of OLDPASSWORD with NEWPASSWORD in the designated files making a backup (.bak) of each file in its parent directory before any changes are made. Replace 'root' with the actual password of the MySQL root user. type /path/to/mamp-mysql.sh OLDPASSWORD NEWPASSWORD replacing OLDPASSWORD and NEWPASSWORD as appropriate and press enter to run the script.type chmod +x /path/to/mamp-mysql.sh and press enter to make the script executable.Open the Terminal application in macOS.It seems you configured to use blank password when the command hangs. Not sure if you tried that before trying to reset the password. Mamp-mysql.sh is a Bash script that automates updating these files with the new password and is run from the command line. The default password for the root user for MySQL database is bitnami.

#MAMP MYSQL PASSWORD HOW TO#

Instructions on changing the password for MAMP's MySQL root user and how to manually update each of these files can be found at Changing the MySQL Root User Password in MAMP. However, if you’re using MAMP 4.5 which shipped with MySQL 5.6. /Applications/MAMP/bin/quickCheckMysqlUpgrade.sh This affects versions of MAMP since 5.0 released on which shipped with MySQL 5.7.21. /Applications/MAMP/Library/bin/mysqladmin -u root -p password NewPassword and substituting a new password (random 12 character) for NewPassword.Changing or re-setting the password for MAMP's MySQL root user necessitates updating hard-coded references to the old password in several Bash scripts shipped with MAMP for macOS. If anyone using WAMP has a similar issue, this worked well: Download the 'database' SQL file in the project files and place it in the 'www' directory in the 'wamp' main directory on your disk (or elsewhere, so long as you know where it is).

Mamp mysql password