[FIXED] Change MySQL root password in MAMP on Mac OS X

Issue

I have MAMP installed on my Mac OS X, which is installed within my Applications folder.

The problem I am having is that I would like to change my "root" password which I have currently set to a new password, within one of my database schemas.

I have tried to locate mysqladmin but to no avail.

What is the query for changing this existing password?

Solution

Found it - used:

UPDATE mysql.user SET Password=PASSWORD('NEW PASSWORD') WHERE User='root';
FLUSH PRIVILEGES;

Answered By - tonyf