Changing the MySQL password in MAMP – Lucid Nerd Tutorial

In this Lucid Nerd beginner tutorial, I will cover how to change MAMP’s default MySQL password from root to a password of your choice in Mac OSX.

Advertisements

2 thoughts on “Changing the MySQL password in MAMP – Lucid Nerd Tutorial

  1. good video! im following it verbatum and heres what i get, can you help?

    Last login: Mon Dec 12 16:41:40 on console
    users-macbook-pro-51:~ user$ /Applications/MAMP/Library/bin/mysqladmin -u root -p password xxxxxxxxxxxxx
    Enter password:
    /Applications/MAMP/Library/bin/mysqladmin: connect to server at ‘localhost’ failed
    error: ‘Access denied for user ‘root’@’localhost’ (using password: YES)’
    users-macbook-pro-51:~ user$
    users-macbook-pro-51:~ user$ /Applications/MAMP/Library/bin/mysgladmin -u root -p password xxxxxxxxxxxxx
    -bash: /Applications/MAMP/Library/bin/mysgladmin: No such file or directory
    users-macbook-pro-51:~ user$

  2. Make sure that you have started MAMP, and that Apache and MySQL have green lights before you go into the command-line to change your password. Otherwise you will not be able to connect to the MySQL database server at Localhost to change the password. Hope this helps you out.

    Please note that on your last two lines of output you have typed mysgladmin not mysqladmin, and that is why the No such file or directory error message was displayed.

    Don’t worry about your typos if you are a beginner. Trust me you will type may more in the coming months. I spent days looking for errors when I started, just to find it was a typo or missing semi-colon. It’s all part of the fun.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s