Any sufficiently advanced technology is indistinguishable from magic.

Arthur C. Clarke

Change MySQL password

September 14th, 2013

Unlike WAMPServer on Windows,MAMP on Mac OS X some with a password already set for the root user, ‘root‘. I found quite a few posts regarding changing this password usinf the following command in the terminal:

/Applications/MAMP/Library/bin/mysqladmin -u root -p password 

What wasn’t clear from this is that in this instance password is not a placeholder for your password that you should replace but in fact an actual command. After typing or pasting this command, with replaced with the password you want to use you are then prompted for your existing password, ‘root‘. I tried several times with my Mac password because that is what I normally enter when terminal propmts me to ‘Enter Password‘. Felt a bit stupid for wasting half an hour or so but it is sorted now.

Web Design|MySQL