MySQL Tutorial for Beginners 2 - How to Install MySQL on Mac

In this post we will learn how to How To Install MySQL on Mac OS X. The same procedure can be used for installing MySQL on Mac OS X.

How to add MySQL to $PATH variable:
cd to your home folder
$ open -t .bash_profile
Try adding the following line to your .bash_profile file.
export PATH=${PATH}:/usr/local/mysql/bin/

Setting the MySQL root user password on OS X
$ mysql -u root -p
mysql$ ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';

MySQL Database is world's most popular open source database because of its consistent fast performance, high reliability and ease of use. MySQL has Open Source License i.e. it has free GNU General Public License. So it is Free to modify and distribute but all modification must be available in source code format. MySQL Database is Mostly used to power web sites and small apps and it also supports clustering and replication. Database Management System is used to manage the storage and retrieval of data to and from the database and hides the complexity of what is actually going on from the user. SQL (Structured Query Language) is the language used to insert and retrieve content. Clients make queries on the database to Retrieve, Insert, Update or Delete content.
★★★Top Online Courses From ProgrammingKnowledge ★★★

★★★ Online Courses to learn ★★★

★★★ Follow ★★★

DISCLAIMER: This video and description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. This help support the channel and allows us to continue to make videos like this. Thank you for the support!

[sushanthb]

Thanks for the helpful tutorial! Just a quick tip for macOS users on the latest versions (Catalina and later): If you're using zsh as your default shell, you'll need to add environment variables like MySQL to the .zshrc file instead of .bash_profile. I initially tried adding MySQL to .bash_profile but got a command not found error. After switching to .zshrc, it worked perfectly. Hope this helps anyone running into the same issue! :)

[raghavbansal]

mysql -u root -p commond is not working
it shows zsh: command not found: mysql

[juan]

This is the best video of all the video tutorials on this! Thank you!

[bluemedia]

Thanks so I watched so many videos but I couldn’t find such great video like this thanks 🙏🏻 a lot

[sonicbrew]

Thanks man! Short and clear video, I really appreciate it!

[akrammasad]

for this problem
zsh: command not found: mysql
here's a solution:
In the terminal type this command
vi ~/.zshrc
Then Past the next command
export
to quit vi command add a colon

:
Then type (no space after the colon)
wq
Then Enter to quit and save
you are all set to execute the sql command
mysql -u root -p

[stephystephen]

thanks a lot! it worked right away unlike the other videos!

[GilAguilar]

Thank you for the video got my mysql working like it should cheers and have a great day :-)

[breannavasko]

Hello, I click on start my instance, the instances are active for about 5 second then automatically go back to red. How can I fix this?

[jhanvibhatt]

Not able to do any further process after downloading MySQL, please help out

[abhishek-hbvg]

Will u be uploading the videos everyday????

[yilizhang]

Is the user root password created purely by the users or it was provided somewhere else?

[ProGamer-mqmp]

open -t .bash_profile if bash command is not working on mac then try following step
1. vi ~/.zshrc
2. paste there this export
3 save that
4. run to activate
source ~/.zshrc

[learn_korean_with_hee]

the pronunciation is not clear at 6:21 so, when I put password, what keyboard should I click together?

[danielleguizamon]

Hello everybody. I have problems about how to change the password. Does anybody know it? I tried to uninstall it and reinstall it again but I didn't have success

[mansijswarnkar]

Path in the bash file is something predefined ?

[sarthaknirmal]

"-t bash_profile" file is empty. Are we supposed to fill it with what you have filled with??