How to install MySQL 8.0.22 Server latest version on MAC OS
HTML-код
- Опубликовано: 27 окт 2020
- Learn how to download & install MySQL 8 on MAC. To download the MySQL installer, refer the below video:
dev.mysql.com/downloads/mysql/
!!!!! Commands - Commented by a viewer Apoorva"
"Run the bash_profile file"
After adding the path of mysql, run the bash_profile file to configure the path
$source .bash_profile
Then try to run mysql -u root -p
It works!
Thanks Apoorva for the update!
!!!!!
!!!!! Comment by a viewer Des Bembu"
Alternatively, if you just copy /usr/local/mysql/bin/mysql -u root -p into the terminal it works.
Thanks!
!!!!!
!!!!!
Type PATH=$PATH:/usr/local/mysql/bin mysql -u root -p on Terminal
!!!!!
!!!!!
Commands
Set path for MySQL
$ open -t .bash_profile
If bash_profile does not exist, create a new one
$ touch .bash_profile
Add below line to .bash_rpfile and save (Command+S)
export PATH=${PATH}:/usr/local/mysql/bin/
!!!!
--------------------------------------------
Install MySQL on Windows 10
• How to install MySQL 8...
Hindi: Install MySQL on Windows 10
• How to download & inst...
#MySQL #Install #MySQL8 #MAC
►Don’t forget to Subscribe
/ amittechie
► Donate & Support us
www.paypal.com/paypalme/learn...
►Our popular videos:
- How to run first program in PHP? • How to run first PHP p...
- Android: Locate and view SQLite Database in Android Studio • Android: Locate and vi...
- Android Studio- Change App Name (App Title) of Android App • Android Studio- Change...
- How to run your first Java Program in NetBeans IDE • How to run your first ...
Subscribe to Amit Thinks for more videos!
Like! Subscribe! Share!
Stay tuned!
![Install MySQL 8.0.28 Database on MacOS Big Sur [Step-by-Step Tutorial]](http://i.ytimg.com/vi/CBtBZgmP22M/mqdefault.jpg)
🔥 MySQL Tutorial for Beginners with 45 lessons: ruclips.net/video/fFgdnS1laA0/видео.html
Hi Amit. I just want to say thank you sooo much for this tutorial. I could not get mySQL to work for days because I did not know I had to create a bash profile. I tried so many other methods you are the only one I found who did the extra step. Thanks a million.
You are most welcome, @Michelle. Thank you for the appreciation. Do refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: ruclips.net/video/fFgdnS1laA0/видео.html
Awesome tutorial bro. Was able to setup my database and got it up and running. Thank you alot.
Glad it helped, @Victor. After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons:
ruclips.net/video/fFgdnS1laA0/видео.html
Thank you so much for this tutorial brother you saved me for my database course!!!!
You are welcome! Here's our 3 hrs free MySQL tutorial with 45 lessons: ruclips.net/video/fFgdnS1laA0/видео.html
Thanks! Finally clear instructions on how to perform the setup correctly!
You're welcome, @Andy. Subscribe!
After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons:
ruclips.net/video/fFgdnS1laA0/видео.html
I'm not sure why My Udemy instructor didn't do this in his video, but when I wake up tomorrow, I'm going to do this. Thank you Amit!
Sure, @Tony. After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons:
ruclips.net/video/fFgdnS1laA0/видео.html
Thank for this I needed this! Extremely thankful I have found your video!
Welcome! After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons:
ruclips.net/video/fFgdnS1laA0/видео.html
So helpful. Got my db set up in no time. Thank you!
Welcome! After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons:
ruclips.net/video/fFgdnS1laA0/видео.html
Thank you so much, this was so helpful! Sending you blessings!
You're welcome, @Gorcsa!
After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: ruclips.net/video/fFgdnS1laA0/видео.html
This was an amazing video - worked perfect for my Mac! Thank you.
After entering % mysql -u root -p, I get: zsh: command not found: mysql plz advice!
i keep getting stuck on the installation progress, i’ve wait it for an hour, and it said ‘the application not responding’ do you know how to make my installer keep going?
ur amazing bro.. thanks a lot.. finally mysql got installed
You're welcome! Subscribe!
Thanks a lot!! I was able to install it successfully!!
You're welcome, Farheen.
Refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons:
ruclips.net/video/fFgdnS1laA0/видео.html
Does this also install the workbench? if not could you please do the steps to do the same?
Permission denied is coming when we write that command about touch.....
Please help in that case
Very good instruction! Thanks, worked perfectly for me
Glad it helped. Subscribe! After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: ruclips.net/video/fFgdnS1laA0/видео.html
Hy, thanks for the terminal tutorial, I have a question, how do i open it everytime??? ... i do not see any mysql application logo in my applications folder. Do i always have to use mysql through this terminal?
For some reason it shows me this, “mysql-8.0.31-macos12-arm64.pkg” cannot be opened because it is from an unidentified developer", what should I do?
Thank you! Your video helped me successfully download SQL
Glad it helped! Welcome. After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: ruclips.net/video/fFgdnS1laA0/видео.html
Hi Amit. Thank you for this tutorial, I've been struggling to install it for a couple weeks now and I'm finally able to set it up. A doubt, I'm trying to install MySQL Workbench on Catalina 10.15.7 but the latest version is not supported on Catalina while archived versions do not work. Is there a way to use Sequel Ace as an alternative to Workbench? Thanks in advance!
Try using this extension if you have installed it properly it will get you to the login windo just enter your SQL password it will br resolved
Thank you for this tutorials, Amit. Great help.
Glad it was helpful! After installing, refer to our free 3 hrs MySQL Tutorial for Beginners with 45 lessons:
ruclips.net/video/fFgdnS1laA0/видео.html
hello i have a type error "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)" after "mysql" command
hi actually I would like to use mysql connector with python in Mac but am not able to
if it's possible will you please post a tutorial for the same
I got problem after i installed mysql server 8.0.22 I curiously revoke the rights of the USr on mysql workbench how can I retrieved the rights? I found as well there is no schema pane on my mysqlworkbech? how can i fix that
Hello Amit , Thank you so much!!
The video was very helpful .....
You're welcome. After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons:
ruclips.net/video/fFgdnS1laA0/видео.html
Thanks for this great video! One note I have was that I was not able to copy the bin path name (in the video this is around 4:47) without first clicking the menu and then holding down the option key.
Copy bin as pathname: ruclips.net/video/onXM6L0LXWY/видео.html
Thanks man!
@@Amit.Thinks:26 I am not getting anything to paste... What to do please help! Actually I was facing the same issue (i didn't get the option for copying as pathname) but then i watched your this video and did accordingly but I am not getting anything to paste 6:26
sir when i try to create ash profile the terminal shows permission denied....
Hellooo after saving the bash profile and opening new terminal and typing
mysql -u root -p
I am getting “zsh: command not found: my sql
yeah I am also getting the same problem. Is your issue resolved? pls help
i got the same problem, have you solved it?
@@niksyareena8615 Same here
Just tell me how you were able to minimise in full screen mode in mac, i have to first came out from full screen mode to minimize 😢
so was this only the server? so should I do the work bench next and the rest? I just got it to work thanks
Thanks!! Finally I was able to setup my database
Glad it helped! After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons:
ruclips.net/video/fFgdnS1laA0/видео.html
Thank you so much, this was really helpful!
You're welcome. After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons:
ruclips.net/video/fFgdnS1laA0/видео.html
After installation,
" You can’t open MySQL preferences pane because it doesn’t work on an Intel-based Mac." shows on the system preferences of my Mac OS(10.14.6).
The version from MySQL is macOS 12 (x86, 64-bit), DMG Archive, please kindly helpppppp
sir does macbook m1 256ssd enough for coding and software devlopment ?
Thank you so much man! Really useful.
You're welcome, @Demetrio.
After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons:
ruclips.net/video/fFgdnS1laA0/видео.html
Hi Amit, thank you for this video. Good bless you brother
You're welcome. After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons:
ruclips.net/video/fFgdnS1laA0/видео.html
Hi! When I installed mysql, the dot is red next to "active instance." do you know why that is?
Hi Amit I Couldn’t find out how to insert data and doing stuff on popsql, was saying “ unknown mysql server host....”
Probably I’m doing something wrong
Hey Amit,
Thank you so for the video.
I was not able to figure from 4:39. Where you searched “USR”.
I couldn’t find that file on my macOS Big Sur version
Follow this video: ruclips.net/video/pOTo32VthRY/видео.html
sir .bash_profie is already there and its locked .cant edit ..what to do?
Hi Amit, my terminal shows access denied for path copy, how do I fix it
i love u and all ur work, u hope u will be rich and happy in ur life. Ty
Thank you for the appreciation, @Davide. These comments keep me going. Refer our website also. We provide free learning tutorials there as well: studyopedia.com/
With that, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: ruclips.net/video/fFgdnS1laA0/видео.html
Thanks alot , this video really helped me !!
Glad it helped! After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons:
ruclips.net/video/fFgdnS1laA0/видео.html
Hey , I’m unable to initialize the database and update my root password it is displaying initialization failed , I tried it many times it’s still the same please help me out I’m desperate at this point , a lot is riding on MySQL all of my uni projects require me to use MYSQL please help me out
Hi Amit, I downloaded the package from mysql website. But when I tried to install further it did not ask for 'configuration' and also there was no Configuration section where I could enter the root password. Can you help here?
Thank You
Hi, Try the following foix:
ruclips.net/video/6yrEiSvVutM/видео.html
If that doesn't work, then try below fixes:
FIX: MySQL server Failed to Install on Windows 10 [2021 Updated]
ruclips.net/video/m9UKmUK9BbA/видео.html
FIX: MySQL not showing in services | mysql80 issue SOLVED [2021 Updated]
ruclips.net/video/m9UKmUK9BbA/видео.html
FIX: Can't connect to MySQL Server: MySQL Workbench could not detect any MySQL running
ruclips.net/video/eeXB1hLVl7I/видео.html
FIX: Bad Handshake error | Failed to Connect
ruclips.net/video/__4x-DsVzo4/видео.html
FIX: MySQL No Packages Found Error
ruclips.net/video/6yrEiSvVutM/видео.html
Fix: "mysql is not recognized...:
ruclips.net/video/_b3bgMhzxYY/видео.html
Thank you for the video. Somehow after I installed it, I ran into an error while loading Mysql on the system preference, saying Can't load mysql preference panel. I see this is a common problem. Wondering how you get around it?
I had that issue too, when downloading from the site you should click on x86, 64 bit version
hey Amit mySQL does not start automatically and I hit start mySQL Server and enter my password it starts for a sec and back stop. any advice? cheers
in my mac there is no usr folder there is user folder but when i try to look into it after mysql installation i di not find any local file, how to get location of mysql iin mac
Here's how to find the path:
ruclips.net/video/onXM6L0LXWY/видео.html
ruclips.net/video/pOTo32VthRY/видео.html
brother i have seen so many tutorials nothing worked but u saved me
Welcome. After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons:
ruclips.net/video/fFgdnS1laA0/видео.html
@@Amit.Thinks fs i will
thanks, bro! your video helped me a lot
Glad I could help! Subscribe! After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: ruclips.net/video/fFgdnS1laA0/видео.html
I have .bash_profile when I write open It will open but with Conda due to I have downloaded anaconda If I tried to do copy or anything it will not take I m confuse
thank you for the clear instructions
You are welcome! Subscribe!
After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: ruclips.net/video/fFgdnS1laA0/видео.html
Thanks Sir!
It was a great help.
After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons:
ruclips.net/video/fFgdnS1laA0/видео.html
Plz make vedio on workbench also for mac.How to install it and what is it
do u know how to install sql connector integration with python
Very Very helpful sir ...Thank you so much.
You're welcome. After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons:
ruclips.net/video/fFgdnS1laA0/видео.html
Thanks and I did it. I got some errors but it helps me for now
Check the Video Description...
Hi Amit, i have followed your instructions and created a bash profile and saved it. when it came to opening the mysql root, it says command not found mysql. What do I do? I have even gone and done your step on creating a bash profile and i'm still getting the same error after completing the steps. please assist
Check the Video Description
On the step 4:21 when I finish installing MySQL i can't find any "usr" folder on my mac. What I'm doing wrong? I can't move foward after this step.
did you type /usr or just usr
I followed all the steps but while trying to run it I'm getting an error saying command not found, please help.
Hi, check the Video Description
zsh command in not available
I did one thing different i was unable to copy the path the way u did it coz the copy path to terminal wasn’t coming in my mac i used a shortcut option+command+c then pasted it and also after that when i closed the path tab to terminal part, opened a new terminal and wrote mysql -u root -p and clicked enter the password didn’t appear infact it is saying command not found please solve this query of mine if someone can
Check description
in my case, once i put the "open -t.bash_profile command it says invalid option. Do you have any idea why it's not working?
there is a space between -t and .bash_profile
hey amit i followed your tutorial step by step but when i tried to run mysql i got following error
zsh: command not found: mysql
could you or anyone please help.......
Same
Check Video Description
Super duper helpful ... Thanks chief ...
You're welcome. After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons:
ruclips.net/video/fFgdnS1laA0/видео.html
hi is there any video of yours using which we can know how to install mysql-connector-python in mac?
did u find a way
Thanks a lot. The video is worth every second.
Welcome! After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons: ruclips.net/video/fFgdnS1laA0/видео.html
Hi, everything runs fine until I enter "mysql -u root -p" (7:37). It still says command not found. May I know how I can solve this?
Here's the fix for "mysql is not recognized...: ruclips.net/video/_b3bgMhzxYY/видео.html
Hey whenever I copy the bin as pathname and paste it to the bash profile , the export doesn’t show just the path is there a way thru this?
Check the video description
Thank you so much I can run mysql on my mac now but one thing whenever I close my terminal after working and open it again later I have to type the command PATH again to start mysql,
Is there anyway to skip that step and just start by typing Password as i used to do on a pc? Thanks
If you followed all the steps, we have shown how to set the path. Now, you just need to type "mysql -u root -p" and enter the password.
@@Amit.Thinks Hi it is not allowing me to enter any password after doing this. The key is grey and locked to where nothing can be typed after it. Please assist
Thank you so much man!!! worked
Welcome. After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons:
ruclips.net/video/fFgdnS1laA0/видео.html
hey thanks a lot....I was finally able to download mysql with your help
Could you pls also tell how can we change the font size?
Hi @Sapna, After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons:
ruclips.net/video/fFgdnS1laA0/видео.html
Do you want to change the font size of CMD?
If yes, then right click on the top-bar of CMD and click "Properties". It will give you an option to change font size.
@@Amit.Thinks thankyou
Am not able to copy the path what to do now?
Hello amit…
After installation, I didn’t get any option of copy of pathname in bin folder…. What should i have to do for resolving this ?
Check tehe video description for probable fix
Hi please i don’t know why at the end the password dosn’t give me to enter it ?
Hello I have the latest updated software update and I do not see copy bin as path ?
It got updated in Mac OS BigSur. Here’s how to copy now: m.ruclips.net/video/pOTo32VthRY/видео.html
when I type the command: mysql -u root -p
I get the following message: zsh: command not found: mysql
I followed all of your steps. any idea what I could've done wrong?
Check the video description
I can't connect msql python connector
Great video dude!
You're welcome. After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons:
ruclips.net/video/fFgdnS1laA0/видео.html
how about sql server installation on mac please tell sir
u did an amaizing work thankyou soo much
Thanks! Refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons:
ruclips.net/video/fFgdnS1laA0/видео.html
will u help me
as i have downloaded mysql on macbook air 2017 after writing path line i am not able to type password
bestiehassan@BESTIEs-MacBook-Air ~ % /usr/local/mysql/bin/mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
after i wrote the .bash_profile I tried to run mysql but I got command not found
do you know why?
Do check the video description. Some fixes are provided there by me and some users.
What is terminal? What is zsh and bash? Somebody please explain
When I write mysql -u root ….
It shows command not found
Set the path. Check the updated video: ruclips.net/video/eq-e_n7lm2M/видео.html
hey amit can you please make a video on python mysql connectivity on mac
You saved my day thank you🙏
You're welcome. After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons:
ruclips.net/video/fFgdnS1laA0/видео.html
getting the issue of "Could not load MySQL preference pane." please help...!!!
Same problem....plz help us🙏🙏
hi amit, you are cool. thank you for this tutorial
You're welcome. After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons:
ruclips.net/video/fFgdnS1laA0/видео.html
Heyy i am not getting the option “Copy ‘bin’ as Pathname” what should i do next ???
Try this: ruclips.net/video/pOTo32VthRY/видео.html
done with everything but how everytime i need to open that i have to write the last code "mysql -u root -p" how to make mysql a seperate file
Type PATH=$PATH:/usr/local/mysql/bin mysql -u root -p on Terminal
This will set the path.
@@Amit.Thinks OMG thank you SO MUCH it worked now!
@@melikekecelioglu6883 try `source ~/.bash_profile` and then try mysql -u root -p
@@dewwrat omg thanks alot dude...idk why only mysql -u root -p was not working for me but this worked!
When I try to type mysql -u root -p it tells me that it can't find mysql even though I followed all the instructions, I would appreciate your help
Check the video description for probable solutions
Can you please help me about how you are working on bash after entering the terminal?
Check the video description for possible solution
thankyou sir it is very hellpfull video for me thanx a lot😍
You're welcome. After installing, refer our free 3 hrs MySQL Tutorial for Beginners with 45 lessons:
ruclips.net/video/fFgdnS1laA0/видео.html
Where I find this configuration item to see "copy bin as pathname" ? I don't have like this in video (4:44min). Thanks
Copy bin as pathname: ruclips.net/video/pOTo32VthRY/видео.html
when i type command mysql -u root -p ,its says command not found : mysql. Would really appreciate some help.
Fix: ruclips.net/video/_b3bgMhzxYY/видео.html
sir my touch .bash_profile is not working, it is not giving permission
my macbook is not showing the "copy bin as pathname" any help?
Check this: ruclips.net/video/pOTo32VthRY/видео.html
Hi Amit, When I open the installer it says that MySQL cannot be downloaded on this computer
Same problem. Did you install it & how??