How To Install MySQL on Mac OS X
HTML-код
- Опубликовано: 7 авг 2017
- 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';
★★★Top Online Courses From ProgrammingKnowledge ★★★
Python Programming Course ➡️ bit.ly/2vsuMaS ⚫️ bit.ly/2GOaeQB
Java Programming Course ➡️ bit.ly/2GEfQMf ⚫️ bit.ly/2Vvjy4a
Bash Shell Scripting Course ➡️ bit.ly/2DBVF0C ⚫️ bit.ly/2UM06vF
Linux Command Line Tutorials ➡️ bit.ly/2IXuil0 ⚫️ bit.ly/2IXukt8
C Programming Course ➡️ bit.ly/2GQCiD1 ⚫️ bit.ly/2ZGN6ej
C++ Programming Course ➡️ bit.ly/2V4oEVJ ⚫️ bit.ly/2XMvqMs
PHP Programming Course ➡️ bit.ly/2XP71WH ⚫️ bit.ly/2vs3od6
Android Development Course ➡️ bit.ly/2UHih5H ⚫️ bit.ly/2IMhVci
C# Programming Course ➡️ bit.ly/2Vr7HEl ⚫️ bit.ly/2W6RXTU
JavaFx Programming Course ➡️ bit.ly/2XMvZWA ⚫️ bit.ly/2V2CoAi
NodeJs Programming Course ➡️ bit.ly/2GPg7gA ⚫️ bit.ly/2GQYTQ2
Jenkins Course For Developers and DevOps ➡️ bit.ly/2Wd4l4W ⚫️ bit.ly/2J1B1ug
Scala Programming Tutorial Course ➡️ bit.ly/2PysyA4 ⚫️ bit.ly/2PCaVj2
Bootstrap Responsive Web Design Tutorial ➡️ bit.ly/2DFQ2yC ⚫️ bit.ly/2VoJWwH
MongoDB Tutorial Course ➡️ bit.ly/2LaCJfP ⚫️ bit.ly/2WaI7Ap
QT C++ GUI Tutorial For Beginners ➡️ bit.ly/2vwqHSZ
★★★ Online Courses to learn ★★★
Get 2 FREE Months of Unlimited Classes from skillshare - skillshare.eqcm.net/r1KEj
Data Science - bit.ly/2lD9h5L | bit.ly/2lI8wIl
Machine Learning - bit.ly/2WGGQpb | bit.ly/2GghLXX
Artificial Intelligence - bit.ly/2lYqaYx | bit.ly/2NmaPya
MERN Stack E-Degree Program - bit.ly/2kx2NFe | bit.ly/2lWj4no
DevOps E-degree - bit.ly/2k1PwUQ | bit.ly/2k8Ypfy
Data Analytics with R - bit.ly/2lBKqz8 | bit.ly/2lAjos3
AWS Certification Training - bit.ly/2kmLtTu | bit.ly/2lAkQL1
Projects in Java - bit.ly/2kzn25d | bit.ly/2lBMffs
Machine Learning With TensorFlow - bit.ly/2m1z3AF | bit.ly/2lBMhnA
Angular 8 - Complete Essential Guide - bit.ly/2lYvYRP
Kotlin Android Development Masterclass - bit.ly/2GcblsI
Learn iOS Programming Building Advance Projects - bit.ly/2kyX7ue
★★★ Follow ★★★
My Website - www.codebind.com
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!
![Install MySQL 8.0.28 Database on MacOS Big Sur [Step-by-Step Tutorial]](http://i.ytimg.com/vi/CBtBZgmP22M/mqdefault.jpg)
![Install MySQL 8.0.28 Database on MacOS Big Sur [Step-by-Step Tutorial]](/img/tr.png)
![Sean Rii, Karyon, Sharzkii - Taungule [My Love] (Official Visualizer)](http://i.ytimg.com/vi/eJoMuypbSzQ/mqdefault.jpg)
I have spent 48 hours trying to access MySQL, this video saved me on a Sunday evening before my submission, thank you sir ! You are a real hero !! ^^
I can't express my happiness after all that hustle and struggle reading through various blogs, stack overflow, friends but all in vain and that's where your video comes in. Thank you very much, this has worked wonders for me. Cheers
Really helpful video. You are the best:) Btw, anyone get response of "command not found" , type this in your terminal "export PATH=$PATH:/usr/local/mysql/bin".This command will place your MySQL to right path.
Tq sooo muchhh
you deserve top comment, thank you so so much
thank you, this comment is a life saver😀
THANK YOU! THANK YOU! THANK YOU!!!!!! I have gone over and over uninstalling and installing trying to figure out how to get to the my SQL server. And lo and behold I did not have that batch profile. This second I follow the steps in your video I was able to login no problem. You saved my butt. I needed to access this for school and no other video out there helped me!
If an error comes up saying that Apple can’t validate the package for Malicious software, or something to that effect, it means that you have a newer Mac. Close the error message. Hold down the control key while clicking on the pkg file. Select “open” from the pop-up menu.
Thanks so much! I've been having this problem for the longest 😅
@@emmanuelamoh7181 Your comment has been so helpful. Thank you so much!
BRO THANK YOU SO MUCH
no joke was abt to cry , tysm
Thank you so much! But is opening a file without mac scanning it for bugs alright?
Thank you! I finally got MYSQL set up on my Macbook. I followed your tutorage step by step and it works on my OS High Sierra. I 'm taking a course at my job. This is what I needed.
Thanks a lot!! I'd wasted an entire day just to figure out how to uninstall & re-install MySQL Server & WorkBench in Mac OS. It really helped me :)
tremendously helpful! I spent almost an entire evening trying to figure out how to install mysql and to get it running. Your video really helped me a lot. Thank you!!!
Thank you so much for explaining all of this so well. I watched 3-4 videos before this that did not explain the .bash_profile creation neither did they explain the procedure or use of it. You are really great!
You are the best! i struggled with this for month now i have MySQL installed.
Ive been programming moderately since college (about 5 years) and I swear getting things installed is the hardest part lol. The good news is someday you'll have a job with an IT department that does it for you.
I was facing some issues with MySQL 8.0 installation on my MacBook Pro, this video resolved all the issues, Thanks a lot, you saved my day :)
Thank you a lot, was quite difficult to install but once I´ve found this video I totally got it! The Workbench was my salvation!
Dude, you are a legend. I set up a new computer and didn't have the bash file, which I didn't see. You saved a lot of nerves. Thank you very much.
you're an absolute life-saver! although I didn't understand the whole process with the terminal...(using a newer version of Mac) but finally understood why I failed to find the MySQL application on my mac after installing it for 3+ times on my computer ---> it was cuz I had no clue that I needed to install a workbench!!! (was watching misleading videos where Windows users breezed through the whole process...) thank you so much for the detailed explanation!
As my first comment ever on RUclips, THANK YOU VERY MUCH!!!! Something that FINALLY works! Keep it up!
Thanks, perfect tutorial for those using MySQL on Mac for the first time.
THANK YOU SOOOO MUCH! Beginning of learning mysql is sooooo difficult, but you helped me out and solve all my problems. Thank you very much!
I've been trying to install SQL for so long! Thank you!!!
Thank you very much, have been searching for the way to operate mysql in mac for an hour until reaching your video!! That's help a lot
I would definitely suggest his videos to all my friends. This is such an excellent explanation about installing SQL and run it.
THANK YOU.Installing MySQL from Brew was so messy and buggy. It helps me a lot
Great video! My first go around of installing MySQL Community Server and WorkBench was unsuccessful but this video was super helpful. Awesome work, thank you!
This tutorial helped so well! I downloaded the latest version and it still worked smooth as a cake. Though for some reason I had to use *touch* even though .bash_profile even though I could see bash_profile. Weird.
But as I used picture in picture and followed all instructions side by side, it worked so darn well!
Props to you @ProgrammingKnowledge!
THANK YOU. Installing MySQL from Brew was so messy and buggy. Now I can finally use MySQL 5.7
Thank you so much for making this tutorial, it is still extremely helpful. Just, I would like to give you a suggestion. The new version asks for choosing between using a strong password encryption or a legacy password encryption. Using the second option, you are able to choose the password and you don't need to change it later. So, it is not necessary to use the terminal for anything.
Thank you. In my case everything had gone wrong-- from no disk permissions( its my computer only and i wasnt able to add myself? Had to sudo it) to not having a bash profile ( last time I hd a new computer was ages ago and forgot all the setup and brew ordeals). This cleared up a lot and took into account different usage cases-- awesome!
You explained so beautifully! Much needed info. Thanks a lot!
Thank you soOooOooOOooo MUCH!! Extremely helpful, detailed, and easy to follow! Very much appreciated!
thank you so much this is my best, I have 3 books on sql and none of them go over the install process and i had a hard time finding a video.
between you and your comments section i got this done. what a saviourrrrr a true heroooo
Thank you so much for your help, I was facing a lot of problems for my Mac os high Sierra. but following you line by line, I successfully installed it. Thanks again!
I was new at Mac OS and you helped me lot in order to configured these stuffs, thanks
Firs time installing this. Thank you for these instructions, very easy to understand great video
Good stuff, nice thorough walkthrough for installing mysql and its tools on the Mac.
three days of finding the solution had been finally blessed..thank you sir...
Thanks very mutch for this vid. I've tried many, but this is the first one who did the job. Thnx
Thanks for sharing this MySQL installation guide, much appreciated!
Best video for My SQL installation ever!! Thanks a lot!
I rarely comment, but this was a great tutorial! THANKS!
Thank you so much you saved my entire day "mysql not found", I know it takes lots of effort on searching GitHub and Stack overflow, love you man and thank you so much again.
same issue ... how to resolve
This tutorial is extrealmy helpful, than you sooo much!!!
Indians are the most talented. I skipped your video seeing that it's gonna consume 20 minutes and instead I watched a 6 minutes useless video and got stuck while connecting to the server from the terminal. His command itself was wrong. Ended up wasted 1.5 hours in total for a job which can be done in 15 minutes.
Loved it, keep up the good work, keep coding!!
Although the installation process is different at present date, this is a really good video. I was given the option to give a password for root at installation without temporary password given.
I'm writing an IOS phone app using XCode on my Mac for my Capstone project. This video was hugely helpful, thank you.
Thank you so much- exactly what I was looking for!
Thanks for this video. Transparent. Straight to the point.
Works great - thanks. Newer version asks user to set up a password during install. Great work on setting up the .bash_profile step.
Such a detailed illustration!! Thank you very much!!
.thank you so much , i was having trouble with connection , and now you solve it
you save my life, thanks again
Worked perfectly for me. Thank you for the tutorial!
The BEST tutorial! Worked like a charm!! Thx!
Great, I follow you step by step and everything work fine. Thank you.
Thank you for making this video! It was very accurate!
Great video tutorial. Thanks for posting this!! Super helpful!
Awesome step by step tutorial !! Thank you buddy
Thank you so much! I tried with the latest version there was a couple of minor differences put this helped so much.
Thank you for creating this video. it was very helpful.
Fabulous tutorial. Many thanks - it helped me out immensely.
This video helped a lot!
Thank you!
From Brazil!
Great Work Man!! Thanks for helping me out on this!
This is an exemplary educational video! very clear! Brilliant!
Helped me SOOO MUCH! Thanks, helpful a lot!
Best tutorial by faaar. Thank you!
Thanks a lot brother works flawlessly after seeing your steps
thank you so much man. it worked
I only got stock at the point that i needed to start mysql with the commnad "mysql -u root -p" i was getting an error (maybe someone else has it here) but the problem was i am using the zsh and it i needed to add a piece of code to the zsh source file and then everything got ok
thanks again
Thank you very much for your crystal clear explanation!!!
Best tutorial so far period !!!
Thanks for this. it was a great help and worked perfectly (when I actually followed your instructions :-) )
This video is very great!! the step by step!! Good job!
It is overall a good tutorial! For someone who thinks he is speaking too slow, just change the speed of this video and it feels much better!
Thanks for this tutorial. Its working beautifully.
I get through every step but when I get into the work bench nothing will load. I do have SQL running correctly. I get an error that I cannot connect to database server. Your connection attempt failed from user 'root' from your host to server at localhost:3306:
Any thoughts?
Thank you for this video. It helped so much!
CRAZY EXPLANATION! U SAFE MY LIFE BRO! GREAT!
fantastic straight forward video ! thank you !
Thank you very much. This video helped me to setup MySQL
Thank you sooooooooooooo much!!! It's so great to have this amazing video!!!
You're a GENIUS! Thank you so much :)
Huge thanks for detailed explanation!
Thanks a lot for this video ! It's very complete and it works perfectely.
Thank you, fantastic video! So helpful!
Thank you so very much.... It really helped me after long suffering... thanks once again
After installing MySQL do we need to do the terminal commands? Or can we just use workbench instead?
Good video, Nice Explanation. All the best
this tutorial really helps!!! Thank you
Great tutorial, helped so much. Thank you!
great video !! thanks mate from Sydney
you saved my life and my mental sanity. thanks!
Thank you so SO much, Mr. Patel!
Thank you so much it worked well. Keep doing the good work!!
This was very helpful, thanks!
Very Helpful. Thank you so much!
Thank you very much, very good explained. Thumbs up!
This works man.. That's cool, thanks for your guidance
THANK YOU SO MUCH, FINALLY I CAN ACCESS MY DATABASE FROM *NODEJS*
GREAT ! very clear explanations!
Thank you very much, this video was very helpful to me.
You saved me twice! lol
Thank you so much!!
Thank you! this was really helpful!
Thanks, buddy. It worked like a charm.