• Sunday , 5 April 2020

Changing the MySQL password in MAMP – Lucid Nerd Tutorial

Code Canyon



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

3d Ocean

Related Posts

32 Comments

  1. thisdudeiskillinit
    March 9, 2018 at 18:09

    Major kudos!

  2. Dzaiidy
    March 9, 2018 at 18:09

    Can we do it with Mamp ?

  3. Tyler Agnew
    March 9, 2018 at 18:09

    This was great – thank you LucidNerd. For recent versions of MAMP, I also needed to change my password in the checkMysql.sh file in my bin folder.

  4. Dominic Davies
    March 9, 2018 at 18:09

    Thanks @thelucidnerd, this video helped me 5 years later, very happy!

  5. mario athanasiadis
    March 9, 2018 at 18:09

    problem solved

  6. mario athanasiadis
    March 9, 2018 at 18:09

    I found the error and made the change but to edit the "index.php" file. it is not equal to your video. there is no such command line.

  7. mario athanasiadis
    March 9, 2018 at 18:09

    I copy bash: /Aplications/MAMP/Library/bin/mysqladmin: No such file or directory in the terminal and send me this…-bash: /Aplications/MAMP/Library/bin/mysqladmin: No such file or directory
    help me please

  8. Fady Azmy
    March 9, 2018 at 18:09

    Thank you !

  9. health author
    March 9, 2018 at 18:09

    Please help. I can't make changes to the index.php file – mine looks different, and now i'm all screwed up and can't get into anything

  10. Dmytro Postovitenko
    March 9, 2018 at 18:09

    Thanks.  Short and precise.  

  11. gfunkonthecheesetree
    March 9, 2018 at 18:09

    Thanks! Helped a ton!

  12. abdullah alsalem
    March 9, 2018 at 18:09

    thank you so much bro … you are the best

    like + share + subscribe 

  13. Stephen O'Connor
    March 9, 2018 at 18:09

    Excellent. Been trying to do this for a few hours and this was spot on! Thank you.

  14. middleCmusic
    March 9, 2018 at 18:09

    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!

  15. Charlie Contal
    March 9, 2018 at 18:09

    Perfect ! Thanks !

  16. lowi82
    March 9, 2018 at 18:09

    THANK YOU !! This is great stuff

  17. Eamon Brennan
    March 9, 2018 at 18:09

    Thank you Mark . I was tearing my hair out over that…

  18. mrobita23
    March 9, 2018 at 18:09

    THANK YOU!!! you are the only one in the entire world to show how to change the root password properly, good God!!

  19. Noelia Martínez Martínez
    March 9, 2018 at 18:09

    La mejor explicación que he encontrado! GRACIAS!

  20. Quinton Aiken
    March 9, 2018 at 18:09

    YOU SAVED MY LIFE

  21. Matt HOU
    March 9, 2018 at 18:09

    thanks a lot~

  22. kkaragianna
    March 9, 2018 at 18:09

    Well done mate! Very useful.

  23. foolsfolorules
    March 9, 2018 at 18:09

    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)

  24. Vivek Rughani
    March 9, 2018 at 18:09

    This video is super helpful! Spent a good hour trying to figure out how to access MAMP after messing up a pasword change. This video helped me fix it in 2 minutes.

  25. jazzybeat28
    March 9, 2018 at 18:09

    I would love to see this for MAMP PRO

  26. lucidnerd.com
    March 9, 2018 at 18:09

    @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 /

  27. Joseph Andrews
    March 9, 2018 at 18:09

    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

  28. lucidnerd.com
    March 9, 2018 at 18:09

    @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.

  29. Joseph Andrews
    March 9, 2018 at 18:09

    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

  30. lucidnerd.com
    March 9, 2018 at 18:09

    @popeserrano You're very welcome, glad you found it helpful and thanks for taking the time to watch. Will be uploading many more computer related videos in the future.

  31. lucidnerd.com
    March 9, 2018 at 18:09

    @NihonDior You're welcome, really pleased this video helped you out.

  32. Wembley Leach
    March 9, 2018 at 18:09

    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 Comment

You must be logged in to post a comment.