How to Set Up MySQL on MacOS

Continuation of setting up a MAMP stack on your Mac.
To add the path to the .bash_profile
export PATH=$PATH:/usr/local/mysql/bin
To Login to the Terminal:
mysql -u root -p
To update the root password:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
Buy Me Coffee
buymeacoffee.c...

[@ViisSarvik]

Correct bash line is:
export PATH=${PATH}:/usr/local/mysql/bin/
The one given in the description did not work for me.

[@meghaagarwal9352]

When I installed the server, I wasn't given a password. I tried removing the server and re-installing and it still didn't happen. What to do?

[@Ali-uh5th]

Instead of temporary password, mysql just ask me to enter the strong passord. And eventually it doesn't the same as your instruction. How should i do?

[@KT-ut9zg]

Might be 'just another dang how to' channel, but it got me up and running. Clear and concise, thanks. By the way, very small mistake on the vid where you are setting the PATH variable, you say "semi-colon" instead of "colon" :-)

[@JustAnotherDangHowToChannel]

Thanks for watching the vid. Kinda mumbled my semi-colon and colons :)

[@sahdeoverma9247]

Hey i changed the host password but again whenever i try to login it show error, not connecting .pls help. I need to reset password.

[@yashaswinirao6779]

Hi, I saved the file .bash_profile with the path but when I say mysql in the terminal it says bash command not found

[@JustAnotherDangHowToChannel]

Hey there, first check mysql is running in system prefs.

[@yashaswinirao6779]

yes it is running

[@JustAnotherDangHowToChannel]

Make sure the export path syntax is correct. There is a colon on export PATH = $PATH:/usr/local/mysql/bin

[@yashaswinirao6779]

Yes I did as u said. but it says bash command not found

[@JustAnotherDangHowToChannel]

go to the terminal and go to /usr/local/mysql/bin and type mysql, tell me if that works. if it fails then something went wrong with the installation. If it works. paste in here your .bash_profile settings.

[@juliagarb]

Thank you! Worked for me.

[@siddharthshukla7266]

Hi, I have latest MacOS Sierra 10.12.5 and MySQL version 5.7.19. All installation is done perfectly but when I click on start server, it asks for password and after I write in the password the window just fluctuates and nothing more happens and server remains in stopped state.

[@JustAnotherDangHowToChannel]

Hard to tell. Try checking the error logs to see what is happening. On the terminal type cat /var/log/apache/error_log

[@NicolasIbarra]

Here is your god damn LIKE!

[@mariayelfimova3650]

THANK YOU!!
helped me very well

[@JustAnotherDangHowToChannel]

Glad to have helped.

[@parthdayala7519]

easy fizzy right

[@ashutoshsingh4523]

how to put that temporary password in terminal.

[@JustAnotherDangHowToChannel]

Just copy and paste. You won’t see it being pasted on the terminal when prompted.

[@beatcent3336]

In MacOS SIERRA, just go to dir:
/usr/local/mysql/bin/
then just run: ./mysql -u root -p
Remaining is in the video. Thank you! It works!

[@shoebmohammad926]

Great!! I was not able to connect with MYSQL with only using ./mysql - u root, then searched for a video and found your comment. It helped.

[@mukhritdinegamberdiev8469]

Thank you for the video bro!
But when I install Mysql the temporary password is not coming up, it just saying "ting" like I got a massage. please help me to solve the problem! Thank you in advance!