Installing MySQL and Creating Databases | MySQL for Beginners
ฝัง
- เผยแพร่เมื่อ 9 มิ.ย. 2024
- In this lesson we are going to install MySQL and create our database.
Download MySQL here: dev.mysql.com/downloads/insta...
Come here if you’re missing a lot of parts when installing MySQL:
Microsoft C++ Redistributable Package: www.techspot.com/downloads/67...
GitHub Database File: github.com/AlexTheAnalyst/MyS...
💻Analyst Builder
📖MySQL Interview Crash Course: www.analystbuilder.com/course...
📖Full MySQL Course: www.analystbuilder.com/course...
📖Advanced MySQL Course: www.analystbuilder.com/course...
____________________________________________
RESOURCES:
Analyst Builder - www.analystbuilder.com/
Take my Full MySQL Course Here: bit.ly/3tqOipr
Take my Full Python Course Here: bit.ly/48O581R
Practice Technical Interview Questions: bit.ly/46pDqqL
Coursera Courses:
📖Google Data Analyst Certification: coursera.pxf.io/5bBd62
📖Data Analysis with Python - coursera.pxf.io/BXY3Wy
📖IBM Data Analysis Specialization - coursera.pxf.io/AoYOdR
📖Tableau Data Visualization - coursera.pxf.io/MXYqaN
Udemy Courses:
📖Python for Data Science - bit.ly/3Z4A5K6
📖Statistics for Data Science - bit.ly/37jqDbq
📖SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
📖Tableau A-Z - bit.ly/385lYvN
Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!
____________________________________________
BECOME A MEMBER -
Want to support the channel? Consider becoming a member! I do Monthly Livestreams and you get some awesome Emoji's to use in chat and comments!
/ @alextheanalyst
____________________________________________
Websites:
💻Website: AlexTheAnalyst.com
💾GitHub: github.com/AlexTheAnalyst
📱Instagram: @Alex_The_Analyst
____________________________________________
All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for
The TH-camr who started it all for me
Pls can you help me take a step by step guide on how to download MySQL, what I see in his video is not what shows on my desktop
He will not😂
Hi there! for those struggling issues on no "Developer Default" you can either choose "Full" or "Custom" settings.
THANK YOU!
Thank a lot
But I can’t establish a connection
Thank you ❤
Thanksssss
After about 5 trials and not getting anywhere facing challenges, I've finally installed MySQL successfully.
Celebrate with me!
Please help me lol
Wish I could. I've tried maybe 4 times. Hoping 5 is the magic number. 😅 Smh
This is awesome. Incase you need a study buddy, I'll be available.
@@anotherwarren7994 I can so relate. I watched someone else's video on how to install MySQL, i watched Alex's own, i uninstalled the MySQL installer and installed it again about 4 times while deleting the packages from the previous installation.
It was just a rollercoaster of trying and trying again and believing I could get it.
I had to stop being anxious, took breaks in between, told myself I could get it right, all of these took about 5 days though.
And voila, I noticed at some point, i and Mr. Alex's video were at the same place and it became successful.
Just keep trying and be patient. Don't be in a hurry. Take your time and make sure there are no errors for each installation process.
All the best! Do let me know when it's successful.
@@445Larry You have to keep trying it. Take breaks in between and make sure there are no errors during each stage of the installation process.
Also, try another video on installing MySQL from someone else on TH-cam. Maybe it'll help.
Hey Alex! As someone who cannot afford the Coursera data analytics course, this boot camp revived my hope to learn data analytics from scratch and hopefully land a job. Thank you for helping us!
OMFG, Iwas looking for a good MySQL course and I wished you could start it and IT'S HAPPENING. I'm more than hapoy right now 😍😍😍😍❤️❤️❤️ BEST TEACHER EVER.
Thank you so much Alex, setup was a breeze following your instruction. I needed a crash course for an upcoming opportunity and i am hoping to learn from your courses !
This video was great to help me get this all downloaded and set up. There's no way I could've done it myself. Thank you
Thanks Alex you are motivating me in Data Analytics roles and the most important thing your lessons are free
Agreed! Access to all!
@@AlexTheAnalyst Hi Alex i followed your old sql playlist from 4 years ago where you used SQL server managment studio. Should i follow this new bootcamp playlist instead? will i miss anything from the old playlist? also should i switch to MySql instead for these new videos???
You are a gifted teacher, an inspirational teacher and role model to your learners+++
Lesson 1, Done! Excited to move to the next tutorial. Very handy with clear instructions Alex! Thankie!
Can you help me please
My is not working
@@zahracabdalla1810 mine too
Well I just finished Microsoft SQL thanks to you but I realised my college wants to teach us mysql and you're making a tutorial for it that'll come in handy
Can you help me pls mind is not working
My younger brother is loving your videos. Nice work 🙏🏼🙌
Thank you for the amazing work @ Alex The Analyst, I am currently taking your Tableau series and its awesome.Will this MySQL course series be part of the bootcamp?
Thank you so much for this boot camp. I started today and I'll most definitely see it to the end.
Thank you for all that you do, you are truly the BEST ♥
Decided to take my data analytic career path today....Excited for this yehey!
How is going I just started today?
For those wondering why you can't get his 8.0.32 version of mySQL and cant get the developers default version, at 1:06 click on archives and scroll to the release that he is using.
thank you so much i was just going to complain about not finding developer default on my pc
the developer option has been removed from the 8.0.32 version too. i just downloaded it and cannot find that too
@@moem655 Are you sure? it worked for me the other day. Are you downloading the exact version he is suggesting?
@0AutoD0, thanks for the tip.
I just hope it'll have a developers default version?
I was struggling with the same problem, but I have selected version 0.32 and 'Developer's Default' and it's still missing.
I have a mac, but it does not give me an option to choose the "Mac" option when i hit the drop down button on the select operating system. Is anyone else having that issue? what should I do ??
I am having the same issue
same issue
same no option for Mac
same issue, no option for mac operating system
we have an option: Select the archives folder, in which u can select mac os version for your system. If your OS IS mac 12.7.5 you select mac os 13 or you can select mac os12. But everything you should find in archives folder...
finally, about mySQL!! i hope you can make about Data Analyst project with mySQL too
Hi, Alex. Thank you so much for your videos. They are sooo informative and I (we) are learning so much from you. Please, note that in the video, at 7min:15s, you show the Navigator > Schemas panel with the databases. At least in my case, when I open the mySQL application it actually shows the Navigator > Administrator panel, which shows a completely different view. It took me a while to notice the two tabs (Administrator | Schemas) on the bottom part of the Navigator panel, which your video does not indicate. Thanks again so much for your work!!
Thanks so much for this
just started today it's good love it ❤
Awww man!! I can't wait to buy a laptop. Now that I really have a legitimate reason to have one. Shout out and good luck to everyone on this Journey to becoming a Data Analyst. And TY Alex for your work and guidance. I am sure some of us will make you proud.
There is no developer default option on my installer >.> looks like im getting the full version
me too
same. what did you do? does the full version work the same?
Use custom set up and select SQL Server and SQL Documentation that should work to get your set up done.
@@yatharthpratapsingh i want to create a root account so as to continue my configuration
@@yatharthpratapsinghdid it work for you?
I just finished your older SQL playlists. How has MySQL in this series changed compared to your previous series on SQL?
Thank God am able to install it . Mr Alex you are the best
Hi Alex, may I have some questions?
I have multiple large tables in CSV format. Usually, I will handle my CSV using Python or R, but this time, my local machine can't handle the data, so I'm learning about AWS RDS. So far, I have imported the large CSV to MySQL Workbench and done some computations (e.g., sum, mean, etc.). The next step is to make some visualization using the computation result. Should I:
1. Export the result to AWS S3, then sync it to SageMaker for using a notebook instance for visualize the result, or
2. Connect the SageMaker notebook to AWS RDS directly for visualization?
Thank you so much!
This is an awesome video. I am trying to get my children into Databases which I work in the Oracle world and SQL also and it serves me well.
Thanks Sir Alex ! BTW: I used first draft version of MySQL (20+ yrs ago. We see that it has improved somewhat :)
hey Alex, what do you suggest for those using a Mac, on the dropdown it does not give the option to download MySQL server for Mac?!
Same problem here. Have you found a solution?
@@BicirBicir www.google.com/search?sca_esv=acc4d604aee1a7ed&sca_upv=1&sxsrf=ADLYWILctSuZjP_seJSFka-xGp450W-ABw:1716041945205&q=download+mysql+on+mac&tbm=vid&source=lnms&prmd=visnbtz&sa=X&ved=2ahUKEwiO2MC0speGAxV_GTQIHcs7BjsQ0pQJegQIFRAB&biw=1420&bih=734&dpr=2#fpstate=ive&vld=cid:bfe2f853,vid:aWZKws7RWic,st:0
Thanks for teaching us 🎉😊❤
Thank you very much for sharing these great videos. Can I get an advice what options should I select if I don't have an Developer option in MySql installer?
I also need help too
Hi
There is no default option for me in the installation prompt, should i select the full version or manual ?
any updates on this ?
Hi Alex while trying to install MySQL i didnt see ' developer default' in the set up type. What should i do?
Will you ever do any SQL videos with Oracle? Currently using it in class and your videos have helped a lot as my professor isn’t the greatest at teaching.
Hello @Alex the Analyst..why can't I add the python connector. I keep seeing the notification of ' has failing requirements '... please help.
Hello Alex !
I have been unable to download exact same version which you have shown in your video. though I have went through the link given in your description. That version does not have developer default option.
what to do ?
Click on archives on the site and select another version
Amazing 🤩 greetings from Egypt 🙏💖
Me too 🎉❤
For the developers option problem, what has worked with me so far is choosing the full option, then even if you have any errors keep going back and trying again, and trust me that would eventually work. And you’ll find yourself on the same steps as Alex
Hello. I'm struggling A Lot here on MacOS. I got passed all the obstacles so far except not being able to run the program with the lightning bolt or shortcut as the icons after open and save are like grayed out.
Thank you, Alex. I initially had issues setting up because I couldn't find MySQL with developer default. Luckily I have gotten a hang of it and I am so excited. I have successfully installed it
what did u chose?
how did you find it?
I downloaded the app but got another version and this version doesn’t have developer default option, please what do I do?
Any suggestions?
When downloading from the MySQL Community Downloads 1:06 , click on Archives, and you can select the appropriate version from there. A kind individual suggested this on my comment. Hope it helps.
I was working through this playlist (just started). I went to the next video and the entire playlist changed to MySQL haha. In my opinion it's a massive upgrade. I like MySQL much more. Also the switch from The Office to Parks and Rec is hilarious to me
Haha I just updated the bootcamp to MySQL instead of the MSSQL series - the MSSQL videos are still available if you want those :)
@@AlexTheAnalyst Why did you update this from
MSSQL to MySQL ?
Same happend for me. As I am a total novice and just started a couple of days before the playlist was updated, I was really confused that what just happend? Is it a issue in my system or what? Then I checked Alex Channel and then I realized that he has updated the bootcamp playlist.
hey alex thanks for helping us, i have a question is there any difference between this course and the paid course in analyst builder?
while setup I have no chice of developer default , does full choic will be ok ?and great thanks to you
Same here too
You are so amazing ❤
Great video!
THERE IS NO DEVELOPER DEFAULT OPTION
what should i do??
Use the FULL Option
@@AlexTheAnalyst In full option we get a error where we get hanged and SQL server won't come up so using custom as alternative is also better option. I was able to spin my SQL server and connection was successful for me.
@@AlexTheAnalyst I asked this question as a separate option now I know thanks
I can't download your version of sql on my Mac with the link you provided. I have a different version of sql but it's very difficult to follow along as it looks totally different to the version you are using as someone brand new to this. Any suggestions?
no reply ?
Hello @Alexthe Analyst, I have a doubt, how to activate the lightening symbol in MySQL to execute creating tables
Me too🥹
Hi , Could you also make a setup video for Mac IOS or Just put the sets in the Description because I have downloaded the package and installed it but I didn't get any of the steps and selections and everything was installed from the package and I dont know if I have the correct version installed or not. Thanks
I somehow backtracked and ended up following your tutorial on SQL Server Management all the way through the beginner module not realizing this was the one I had originally started, lol. Is MySql the new industry standard? How do I get the sakilla schema?
Do you have a video on saving Data here from a website ?
As for April 2024 when downloading the "developer" option it's not available anymore. What should I select instead?
Full option
Hi Alex, I'm really looking forward for this series. Anyway, I have a question, what is the difference between MySQL and the previous SQL software that you use in the previous SQL course? Is the previous one similar to MSSQL or is it different?
Same, I just finished the old MySQL serie videos, but not sure what is the difference with this whole new serie of videos.
@@juanmanuelarevalomadrid1937 It turns out that the previous series was about MSSQL, not MySQL. The current series is in MySQL. There are a few differences between MSSQL and MySQL, such as their syntax. Hope this helps🙌🏻
Hi, thanks a lot! when installing MY QSL there is no Developer default option, any advice?
Hello, i tried installing it as you showed and everything worked fine until installation page and mine doesnt have the connector files. will that be a problem for me and how do i fix it ?
Very cool , Just had minor issue to complet the installation but it's working now . Not sure why.
SQL IS great and going to be an exciting series . Let's go . Hopefully you will get the time to include an actual real life project.... Merci beaucoup
I’m having issues right now too, the installation process is tough for me😢😢😢
@@Christiantalkwit_Ifeanyi same here!!
Excited about learning more about SQL, Tableau. Definitely going to keep going with excel. I know something about all of them. But doing the bootcamp and I want to change my professional life with your help. Thank you @Alextheanalyst
Can i do this on a macbook or is it pretty different?
Hi Alex, when I am trying to install mysql the developer default option is not showing. What should I do?
Hey Alex, when i try to download it, it has a newer version from this video and the dev ops isnt available. should we install with full setup option instead?
The same problem here
Use the full Option
Thankyou Alex for a great starting tutorial. At work I have to move from my Access database to MySQL after working with that student Db for near on 16 years, goodbye old friend. Anyway, I tried installing MySQL on my own yesterday at work and couldn't get it right. Looked for some tutorials, but they were either hard to understand the accent or too old a version of MySQL. Today I found your tutorial, which helped me install it on my home PC in no time and I'm now up and running. (Will have to fix it up at work on Monday). I look forward to the next tutorial, as soon as I can get a chance. BTW, Parks and Rec are one of my favourite shows. Thanks again.
I’m facing the same challenge, and I’m almost getting frustrated 😢 good u pls help me. Take me on a step by step guide
Thanks Alex for all of the tutorials, but i am having some difficulty in installing the sql server in my dell latitude laptop, windows 10. when the page for installation pops up, it does nt have the Developers options just as i saw in the video. what could possibly be wrong ?
Same problem here too bro. Is u got solution for this?
Please @alex the MySQL app that I downloaded does not have the “developer default” option in the set up type
Same here !
Can I use Xampp with Maria DB not SQL Server? Its working faster on my notebook
Hi Alex, nice video thanks man, I have a problem, I don't understand why my installation setup didn't include developer default option, it shows server only, client , full or custom, I have opted for full and the version is 8.0.36, does that cause any issue or is it ok?
Same hereee. I installed it in my desktop, developer default was there but not available in my laptop when tried there :(
When I go to the install link there is no option to change to Mac, only Windows and I cannot find it anywhere. Can anyone recommend where to find this?
Please need some assistance no change after clicking light buttons and my features ie light button is uncoloured
I clicked on the download button to get the query sql text file but it's not downloading into my pc
um the download option for sql isnt available for macbooks
I have the same problem, did you solve it?
there is no Mac version for SQL, which SQL application should i download please suggest me
I chose both full and custom options but couldn't make a server connection in both cases it was always a " failed connection"
i downloaded but didn't get developer default option while installing except that every other option was available.
This was a very helpful video. Thank you! However, the process screens and options have changed. Which makes it more challenging for us noobs!
The workbench and shell can’t install can the sql still work?
in which part of the github is the park and recreation file? I can't find it.
Watching this even tho i have no laptop yet. Will just rewatch and relearn everything after I can afford one
You would def get a laptop soon!! Wishing you best.
thank you so much
That developer Default option does not exist anymore in 2024, what should I execute? I have custom, full, client and server, Please help!
there is no developer default now in the options what shall I choose?
Did you solve this?
Can i use the SQL online because am not it will work on Windows 8 pro
Hello, there is no option for MAC download.
I thought I was the only one having this problem
@@44.44aline any luck?
any luck?
Thanks Alex for this shared knowledge .
Pls i am facing challenge at the last face of the installation it kept directing me to reconfigure after selecting finish, pls help me on what to do
I faced exactly this problem, and after doing everything I thought possible and it still didn't work, I simply downloaded MySQL Workbench directly. I hope it works for you too.
Hi Alex. For some reason I'm getting errors when I try to execute. Is there something I'm not doing right?
Hello! Anyone knows how to deactivate the overwritting when you want to make any change in your queries? There are some moments I want to change something but then it overwrites on it :/ and I do nor see that happens to Alex. Thank you
2:33 there isnt option for 'developer default'
same goes for me. Were you able to find a solution?
@@farooqamin2411 I remember I chose 'Custom' instead. And it works just fine
hi, there seems to be an issue when downloading MySQL, it does not want to open. i have tried downloading from other websites and i am getting the same thing
Hey Alex. I love your tutorial videos and really want to continue the course. I am already in the Data Cleaning part of the lesson but I still haven't downloaded the mysql properly. It keeps on giving me errors and it says "CONNECTION NOT STABLISHED''. I hope someone can help me. Thanks
The link doesn't have an option for Mac OS? Please check
Yeah that's the same issue I had. His videos are for mySQL and Microsoft SQL Server and they both run on windows. I saw that the Microsoft one can be run through Docker if you're on a Mac but I was really hoping to not add a bunch of steps just to get started.
I’m using a Mac and it isn’t included in the drop down
Thankyou sir
Hi alex, i am using the link given in the description to download MYSQL unfortunately i am misssing few parts and unable to land on the same page that you have to practice. May i know what could be the reason? also it apperas to be 237 mb however it was showing over 400mb on your screen i am confused whether i am o the same page as yours.
Yes I have the same problem!!
at the start i dont get the developer default ? how can i get that
Same here
Is there anyway to download this on an iPad?
Sorry under what playlist can we get the next video
I would like to know, what if we the data set we got from Kaggle got deleted on our PC, will it affect the data on our database on the MY SQL server? does the database on MYSQL server gets affected if the dataset downloaded on the PC gets deleted?
No, unless you go to refresh your data - then it will try to connect back to the source file and find nothing resulting in an error.
@@AlexTheAnalyst Hello there is no option for developer default, what should I pick?
Hey there Mr Alex, im stuck. What im seeing on your video is not what i see on my laptop😢
I just downloaded SQL but it is not giving me the Developer Default option in set-up
People have been commenting for months about the developer default option. Can you please provide us with an update on what to do about that? Thanks.
I actually started learning from your channel but in setting up my sql type i think its been updated no developers option which one would be better to use for a beginner like I @alex the analyst
Your comment on this will help alot