This video literally saved my life!! Been trying to install it for quite some time and couldn't make it work, but your tutorial guided me through every step. Thank you so much for this video!!
Everything went well until the terminal step, in the first method I got a message that such file doesn't exit, same for the bash profile, what should I do ??
I've seen a few people leave comments with bash profile errors. I'm not sure what it would be, other than checking that the command is correct. Otherwise searching on Google is probably better.
Hi, I run the path configuration of bash profile but command not found error persists. I got the exact error you got at 6:53 when you rerun the mysql -u root -p command. my terminal is running zsh, what should I do? Already tried the suggestion in one of the comments that says run open - e .zshrc instead. I wasn't.t sure where to place the configuration line so I placed that at the bottom, saved and rerun the sql root command. same issue arises. Please help! not able to do any of my work.
If .bash_profile doesn’t exist in your system files you can create one by typing this command "touch .bash_profile" in the terminal. Then add this code to your .bash_profile file: "export PATH=${PATH}:/usr/local/mysql/bin/ "and Command + S to save the change that you just made to the .bash_profile file and that is enough to add MySQL to your paths.
Thank you for the detailed walkthrough. I came across your video because I couldn't figure out why typing "mysql" in the terminal didn't work. So I guess the installer doesn't add the binary location to the PATH variable. A little suggestions, I think you can just put "/usr/local/mysql/bin" to the PATH, because there's a symlink in "/usr/local" that points directly to the "mysql-8.0.28-macos..." folder.
I have an issue, I followed your steps but at the end of installing it gets stuck and stays for hours saying "Install time remaining: Less than a minute". Can you please tell me why this is happening and what I need to fix?
So, I'm very new to databases & programming, and downloading to teach myself more. The problem I'm having following this tutorial is that I'm not running bash. I'm running zsh. where do I find my .zsh profile to set my path?
I had a problem "“mysql-8.0.21-macos10.15-x86_64.pkg” can’t be opened because Apple cannot check it for malicious software ". I resolved by clickind control + clicking the icon.
I keep getting an error pop-up that the ".pkg" cannot be opened because it is from an unidentified developer. There is no allow option. I have tried all possible solutions that I could find on the internet including trying "Open Anyway" from under security settings which doesnt do anything as I get the same error message when I click on Open Anyway. Suggestions please?
Hmm I've seen that error before, but the solutions I found online worked for me (the Open Anyway that you mentioned). I can't think of anything else that could help resolve this error.
I followed your steps but when running 'mysql -u root -p' I get this message 'ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)'. I am inputting the password correctly, what might be the issue?
After installing and tried opening it on system preference, this "You can’t open MySQL preferences pane because it doesn’t work on an Intel-based Mac." popped up. How do I solve this issue? Pls help!
The "community server" is something that runs in the background. It isn't an application that you need to open. There is a way to start and stop it, using either the Preferences on MacOS, or the Terminal, but it should be running automatically. If you want to do some work with the database (e.g. add data to the database), you'll need an SQL Editor such as MySQL Workbench.
Merci beaucoup pour cette vidéo. J'étais tellement habituée à utiliser les containers Docker que votre vidéo a était super utile, et vous expliquait très bien. Je vous remercie.
Hi! tried following the video (great video btw) and I managed to install MySQL but later when i tried to start the server from system preferences, it asked for the system password (for me its touch id) which worked as normal and then the server starts for a second but then stops. The red light turns green for a second and then becomes red again. I don't know why this happened. Any suggestions?
Thanks! I remember this happening to me once but I don't remember the solution. Could you have two MySQL installations on the one computer? Perhaps there is another MySQL installation running on the same port number, and then the service that you start immediately stops because there is a port issue. If not, then I would suggest Googling it, I think that's what I did last time.
The problem was my terminal wasn’t in .bash, it was .zsh. So I had to paste the MySQL file into the .zprofile instead of .bash. If that’s makes since. Sorry I’m not the most computer savvy.
Can you please tell what should I do now. I mean i have everything with Terminal etc I downloaded SQL from terminal what now. I mean what's next after this Terminal process. Now how can I work on SQL Workbench. I mean I am done with this process what should I do next. Can you please tell me or anyone in the comment section please.
Did you download MySQL using the Terminal? If so, next you can download MySQL Workbench and install it, which will let you interact with the SQL database. Then, you can create a new connection to the database within MySQL Workbench, probably using a hostname of localhost and the username of root.
@@DatabaseStar I did my sql workbench telling me again and again that my password is incorrect and don't know how can I reset my password so please I really need help I can't work on my sql Workbench I am a new student so that's why I really need help
Hi, I am running macOS Big Sur 11.7.7. After following all the steps for Mac installation I keep receiving this error when finally trying to open mysql from terminal: dyld: Symbol not found: __ZTTNSt3__118basic_stringstreamIcNS_11char_traitsIcEENS_9allocatorIcEEEE Referenced from: /usr/local/mysql/bin/mysql (which was built for Mac OS X 12.0) Expected in: /usr/lib/libc++.1.dylib in /usr/local/mysql/bin/mysql How can I get past this?
Hi, please help me. I have installed Mysql just like the tutorial but I couldnt find mysql in system preference (settings) therefore I cant initialize database nor do anything. The problem seems new so there are not many topics about that
Thanks!! This in combo with your home Brew vid got mines working! Subd!!! But, the serve still shows red when in sys prefs, however, I think I'm connected via the mysql server in terminal???
@@DatabaseStar I tried that, mines still red for some reason. Also it’s a brand new Mac book pro so I haven’t had it long enough to screw some stuff up…😅 I’ve only installed XCode, MYSQL and MAMP(it’s not running). And yes, I restarted it multiple times. It turns green for a second then back to red…🤷🏾♂️
I notice Homebrew now issues warnings to upgrade to the "newest version of MacOS to ensure compatibility." How ironic that a CLI tool that resembles the experience of using a computer from the 1980's would tell you that. Lol. I don't want to upgrade at this time so I guess Homebrew doesn't work for me.
Somehow you are the only person to show how to set up servers with 0 confusion. I appreciate you so much.
Thanks!
This video literally saved my life!! Been trying to install it for quite some time and couldn't make it work, but your tutorial guided me through every step. Thank you so much for this video!!
Glad this video could help you!
Everything went well until the terminal step, in the first method I got a message that such file doesn't exit, same for the bash profile, what should I do ??
I've seen a few people leave comments with bash profile errors. I'm not sure what it would be, other than checking that the command is correct. Otherwise searching on Google is probably better.
Hi, I run the path configuration of bash profile but command not found error persists. I got the exact error you got at 6:53 when you rerun the mysql -u root -p command. my terminal is running zsh, what should I do? Already tried the suggestion in one of the comments that says run open - e .zshrc instead. I wasn't.t sure where to place the configuration line so I placed that at the bottom, saved and rerun the sql root command. same issue arises. Please help! not able to do any of my work.
Oh that's annoying it's not working. I'm not sure what else to try, my knowledge of solving these bash problems is pretty limited unfortunately...
Change the opening the terminal: Terminal -> Options -> Opening terminal -> /bin/bash instead of /bin/zsh -> restart terminal
If .bash_profile doesn’t exist in your system files you can create one by typing this command "touch .bash_profile" in the terminal. Then add this code to your .bash_profile file: "export PATH=${PATH}:/usr/local/mysql/bin/ "and Command + S to save the change that you just made to the .bash_profile file and that is enough to add MySQL to your paths.
@@premkrish8530 thanks bro, helped a lot
@@rub.p Thank you this helped!
I'm sorry but when I do the .bash_profile part on 6:30 it’s still saying not found
Ah, I'm not sure what else to do. Some other people have had similar comments that they still get this error.
yeah me too
I did exactly what were said in this video but installation got stuck and it could not progress to configuration..... Maybe I should try Homebrew.
That’s odd. Yeah if there are no solutions when you Google the issue you could try home brew.
When I write the name of the MySQL tool or try to open .bash_profile, neither work by saying no such file and .bash_profile does not exist.
Oh I’m not sure why that would be the case
Thank you for the detailed walkthrough. I came across your video because I couldn't figure out why typing "mysql" in the terminal didn't work. So I guess the installer doesn't add the binary location to the PATH variable.
A little suggestions, I think you can just put "/usr/local/mysql/bin" to the PATH, because there's a symlink in "/usr/local" that points directly to the "mysql-8.0.28-macos..." folder.
Glad you liked the video! And thanks for the tip about adding to the PATH, I'll keep that in mind.
I have an issue, I followed your steps but at the end of installing it gets stuck and stays for hours saying "Install time remaining: Less than a minute". Can you please tell me why this is happening and what I need to fix?
Could be that you're running the wrong version of MYSQL for your OS.
Hmm I’m not sure why it’s staying stuck for hours. Perhaps Dylan’s suggestion is the cause.
same, did you find a solution?
love u bro...u best...my career started because of u
Wow thanks! I’m glad you started a career! What’s your role at the moment?
i m a student@@DatabaseStar
So, I'm very new to databases & programming, and downloading to teach myself more. The problem I'm having following this tutorial is that I'm not running bash. I'm running zsh. where do I find my .zsh profile to set my path?
Oh I’m not sure actually, I’m not that familiar with zsh
I had a problem "“mysql-8.0.21-macos10.15-x86_64.pkg” can’t be opened because Apple cannot check it for malicious software ". I resolved by clickind control + clicking the icon.
Ah good to know you resolved it.
Thanks so much
@@imogen206 anytime!
You can also right click on it, then click "Open". Should works the same.
Hi while installing mysql in MacBook Pro it is showing successfully wait a minute like this showing running mode only
Oh I'm not sure what that could be.
I keep getting an error pop-up that the ".pkg" cannot be opened because it is from an unidentified developer. There is no allow option. I have tried all possible solutions that I could find on the internet including trying "Open Anyway" from under security settings which doesnt do anything as I get the same error message when I click on Open Anyway. Suggestions please?
Hmm I've seen that error before, but the solutions I found online worked for me (the Open Anyway that you mentioned). I can't think of anything else that could help resolve this error.
Mysql is working on my terminal but no application is showing in System preferences like you showed
Oh that's strange, I'm not sure why that is.
System perference not show in macbook air , so how can i found system perference?
It should be there in the Apple menu.
the directory will not appear , also installation with this way dosent work for me
Which directory does not appear? Why doesn’t the installation work for you?
Great video - nice and simple. Easy to follow. Thanks very much!
Glad it was helpful!
I followed your steps but when running 'mysql -u root -p' I get this message 'ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)'. I am inputting the password correctly, what might be the issue?
Hmm maybe the MySQL database is not running. Or maybe there are some special characters that are not accepted in the password.
When installing on my mac10 there was no option to configure after installation it was just summary and close. How can I fix hthis?
Oh that’s odd. I’m not sure why that would have happened.
Just the help I needed!! Thank you!!
But unfortunately, "bash doesn't exist." Says I'm using .zsh and so far from the comments there isn't a fix for this.
You're welcome!
is it normal for the 'installing' step to take more than 30 minutes?
I don't think so, I think it was a few minutes for me. You could try cancelling and retrying.
Thank you so much for your wonderful and simple to understand explanation. U r da man!!
You're most welcome
Thank you, this was very clear and succinct and helped a lot
Glad it was helpful!
After installing and tried opening it on system preference, this "You can’t open MySQL preferences pane because it doesn’t work on an Intel-based Mac." popped up.
How do I solve this issue? Pls help!
Oh I've never seen that before. Hopefully Google has some answers (I'll look at it myself too)
Thank you so much for posting this amazing video, it helps me so much with my homework
Happy to help!
I did all of this and it worked but how do I actually open the community server app. I can’t seem to find it
The "community server" is something that runs in the background. It isn't an application that you need to open. There is a way to start and stop it, using either the Preferences on MacOS, or the Terminal, but it should be running automatically.
If you want to do some work with the database (e.g. add data to the database), you'll need an SQL Editor such as MySQL Workbench.
Merci beaucoup pour cette vidéo. J'étais tellement habituée à utiliser les containers Docker que votre vidéo a était super utile, et vous expliquait très bien. Je vous remercie.
Thanks, I'm glad you liked the video!
how to open the terminal app?
You can find it in the Applications folder or by opening Spotlight and searching for Terminal.
Hi! tried following the video (great video btw) and I managed to install MySQL but later when i tried to start the server from system preferences, it asked for the system password (for me its touch id) which worked as normal and then the server starts for a second but then stops. The red light turns green for a second and then becomes red again. I don't know why this happened. Any suggestions?
Thanks! I remember this happening to me once but I don't remember the solution. Could you have two MySQL installations on the one computer? Perhaps there is another MySQL installation running on the same port number, and then the service that you start immediately stops because there is a port issue.
If not, then I would suggest Googling it, I think that's what I did last time.
I followed your exact steps. It didn't work for me. I run Mac OS Ventura 13.4
Oh no, what issue are you having?
The problem was my terminal wasn’t in .bash, it was .zsh. So I had to paste the MySQL file into the .zprofile instead of .bash. If that’s makes since. Sorry I’m not the most computer savvy.
Can you please tell what should I do now. I mean i have everything with Terminal etc I downloaded SQL from terminal what now. I mean what's next after this Terminal process. Now how can I work on SQL Workbench. I mean I am done with this process what should I do next. Can you please tell me or anyone in the comment section please.
Did you download MySQL using the Terminal? If so, next you can download MySQL Workbench and install it, which will let you interact with the SQL database. Then, you can create a new connection to the database within MySQL Workbench, probably using a hostname of localhost and the username of root.
@@DatabaseStar I did my sql workbench telling me again and again that my password is incorrect and don't know how can I reset my password so please I really need help I can't work on my sql Workbench I am a new student so that's why I really need help
This video is helpful for me. Thanks for your sharing
Glad it was helpful!
hi, from what year would an imac be classed as older? Mine is 2017 so dont know whether to do x86 or ARM
I think the new CPUs came into macs around 2020 so if it’s 2017 it would be the x86
very good tutorial, i appreciate it mate.
Thanks!
Excellent tutorial, thank you!
You're very welcome!
Thank you so much for this! Massive help to me.
No problem, glad it was helpful.
Hi, I am running macOS Big Sur 11.7.7. After following all the steps for Mac installation I keep receiving this error when finally trying to open mysql from terminal: dyld: Symbol not found: __ZTTNSt3__118basic_stringstreamIcNS_11char_traitsIcEENS_9allocatorIcEEEE
Referenced from: /usr/local/mysql/bin/mysql (which was built for Mac OS X 12.0)
Expected in: /usr/lib/libc++.1.dylib
in /usr/local/mysql/bin/mysql
How can I get past this?
Hi, I'm not sure what that error means unfortunately...
bash profile is not opening
Oh I’m not sure how to resolve that. But I can see others have had issues with this.
the configuration isn't clear enough so I didn't get the direction for there
Which configuration did you want to know more about?
what address should we add to the text file?
Is there an address shown in the video for the file?
That's a great video, very easy to understand thank you
Glad it was helpful!
video was too good but still didn't work for me :( may be path variables are not getting saved properly .. don't know :(
Oh that’s a shame it doesn’t work. Hope you get it fixed soon
@@DatabaseStar yeah :(
soooo useful thank you so much. you saved my day :)
Glad it helped!
Hi, please help me. I have installed Mysql just like the tutorial but I couldnt find mysql in system preference (settings) therefore I cant initialize database nor do anything. The problem seems new so there are not many topics about that
Oh that's strange! There may be a way to start it using Terminal if you don't see it in the settings.
I hope you were able to already solve it but I just restarted the system and it appeared shortly after
thank you so much!! very helpful !!
No problem, glad it helped.
6:50 same error I got, but you trimmed the error part in this video. My 8 minutes wasted
Hey, what do you mean by "trimmed the error part"? The error you get can be resolved by adding that path to the bash profile?
it works well for me. Thank you
Great to hear!
Thanks!! This in combo with your home Brew vid got mines working! Subd!!! But, the serve still shows red when in sys prefs, however, I think I'm connected via the mysql server in terminal???
Good to hear! If it's still red you may need to start the mysql server. You could do this in the System Preferences I believe.
@@DatabaseStar I tried that, mines still red for some reason. Also it’s a brand new Mac book pro so I haven’t had it long enough to screw some stuff up…😅 I’ve only installed XCode, MYSQL and MAMP(it’s not running). And yes, I restarted it multiple times. It turns green for a second then back to red…🤷🏾♂️
@@divsyntax9720 SAME!!! Have you solved this problem yet?
@@jiaqili5930 Sadly, no I have not.
I notice Homebrew now issues warnings to upgrade to the "newest version of MacOS to ensure compatibility." How ironic that a CLI tool that resembles the experience of using a computer from the 1980's would tell you that. Lol. I don't want to upgrade at this time so I guess Homebrew doesn't work for me.
Oh that's a little annoying! I haven't updated my macOS either so I might get the same errors if I try.
Thank you so much for sharing.
You're welcome!
hey man great video it is just that .bash_profile was not in my directory
Thanks!
Wonderful learning video Thanls
Thanks!
I followed the steps, but I don't understand where do I get the line from bin folder?
Which line from bin folder?
Thank you so much for your help.
Joao Silva - Brazil
Best Regards,
Thanks!
Thanks alot Man
No problem!
Thank you!
No problem!
tks for share!
No problem!
It works
Good to hear!
so I guess with this video, you don't need docker anymore right? because I have watched so many videos and most of them suggest using docker 🥲
That’s right. You don’t need docker to run this. Docker is popular as you’ve seen but it’s not required.
@@DatabaseStar thank you databasestar
when i open the bash profile file, it looks different than yours, and i still wrote the path line there,,,it does not work and i don know why :(
Oh that’s odd. Perhaps the file is in a different location. I’m not sure why it won’t work unfortunately
How do I generate the terminal? Please help.
You can open the terminal from the Applications folder, or by running "terminal" from within Spotlight.
Thanks a lot for the clarifications
You're welcome!