Search code examples
mysqlpasswordsrootmamp

Change MySQL root password in MAMP on Mac OS X

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;