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. LINKS: LUCID NERD LINKS: Subscribe: http://www.y…

Original source


32 responses to “Changing the MySQL password in MAMP – Lucid Nerd Tutorial”

  1. I almost never bother signing in to like a video. But this time it was worth it.

    I don't know why it's so hard to find the correct way to do this, but thanks to you, it (finally) worked. Thanks!

  2. hey i followed all the steps. it all worked fine, but at the end when I am checking if phpmyadmin page it says
    MySQL said:

    #1045 – Access denied for user 'root'@'localhost' (using password: YES)

  3. @10029759 I have a few questions to help me figure out what you are trying do. 1. Why do you want to connect to a live database? If you are just learnig it will be easier to export the data from the live database and import it into the development database while you learn. 2. Can you write PHP code? If so you can configure the connection by writing some PHP see example at the web address "helpDOTgodaddyDOTcomFORWARDSLASHarticleFORWADSLASH3351" replace the DOT's with . and FORWARDSLASH's with /

  4. Many thanks, I'm very new to this database stuff. Can you recommend a free mysql client that i would be able to connect to a database live to, one that is more easily than MAMP??

    Would appreciate any help

    Joe

  5. @10029759 I only use MAMP for local development, if I need test data in my database I export the data from the live database and import it to the development database so not to corrupt the live data. I have never connected to a remote database before in MAMP and I cannot find anything in the MAMP documentation or a google search to tell me if it is possible to do so. If I find anything I will let you know.

  6. Hi Mark, many thanks for this video. I'm new to mysql and MAMP and have a question that I'm sure you will be able to answer. I have been given access to a website database, yet when trying to access it through MAMP I was informed that I would need to enter the server details via the Config.php folder. As I cannot do this through a browser. I think it currently is set default, which is Root???

    Can you please help me point MAMP to the correct place.

    Many thanks Joe

  7. Thank you so much! You started making these videos at the perfect time. I've been trying to fix this problem for a couple days now ever since I changed the root password in phpmyadmin and didn't change the other files. You're a life saver man!

Leave a Reply