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
Changing the MySQL password in MAMP – Lucid Nerd Tutorial
32 responses to “Changing the MySQL password in MAMP – Lucid Nerd Tutorial”
Major kudos!
Can we do it with Mamp ?
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.
Thanks @thelucidnerd, this video helped me 5 years later, very happy!
problem solved
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.
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
Thank you !
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
Thanks. Short and precise.
Thanks! Helped a ton!
thank you so much bro … you are the best
like + share + subscribe
Excellent. Been trying to do this for a few hours and this was spot on! Thank you.
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!
Perfect ! Thanks !
THANK YOU !! This is great stuff
Thank you Mark . I was tearing my hair out over that…
THANK YOU!!! you are the only one in the entire world to show how to change the root password properly, good God!!
La mejor explicación que he encontrado! GRACIAS!
YOU SAVED MY LIFE
thanks a lot~
Well done mate! Very useful.
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)
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.
I would love to see this for MAMP PRO
@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 /
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
@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.
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
@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.
@NihonDior You're welcome, really pleased this video helped you out.
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!