Installing MySQL and Creating Databases | MySQL for Beginners

Подписаться 774 тыс.

Просмотров 158 тыс.

50% 1

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

Опубликовано:

18 май 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 254

@user-ts4uh2nt3b Месяц назад

Hi there! for those struggling issues on no "Developer Default" you can either choose "Full" or "Custom" settings.

@Tennislover1990 22 дня назад

THANK YOU!

@kadambari7741 20 дней назад

Thank a lot

@mcxineupdates1117 17 дней назад

But I can’t establish a connection

@jenine212 14 дней назад

Thank you ❤

@Clairdelune-vq4sb 12 дней назад

Thanksssss

@NaJoeLibre 6 месяцев назад

The RU-vidr who started it all for me

@Christiantalkwit_Ifeanyi 3 месяца назад

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

@shareka478 17 дней назад

He will not😂

@viktoriaballa4622 6 месяцев назад

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.

@davidstone6 2 месяца назад

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

@henrylahiry5479 3 месяца назад

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 !

@kevinolome8852 6 месяцев назад

Thanks Alex you are motivating me in Data Analytics roles and the most important thing your lessons are free

@AlexTheAnalyst 9 дней назад

Agreed! Access to all!

@abbielmi9163 4 месяца назад

You are a gifted teacher, an inspirational teacher and role model to your learners+++

@everytin8215 8 дней назад

Decided to take my data analytic career path today....Excited for this yehey!

@sols9019 2 месяца назад

Lesson 1, Done! Excited to move to the next tutorial. Very handy with clear instructions Alex! Thankie!

@zahracabdalla1810 13 дней назад

Can you help me please

@zahracabdalla1810 13 дней назад

My is not working

@InfotechArchives 6 месяцев назад

My younger brother is loving your videos. Nice work 🙏🏼🙌

@aquacanleo8303 6 месяцев назад

Thank you for all that you do, you are truly the BEST ♥

@Iam_fares 6 месяцев назад

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

@zahracabdalla1810 13 дней назад

Can you help me pls mind is not working

@TheWizs89 6 месяцев назад

finally, about mySQL!! i hope you can make about Data Analyst project with mySQL too

@bufagp648 6 месяцев назад

just started today it's good love it ❤

@dennisngigi9038 6 месяцев назад

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?

@0AutoD0 11 дней назад

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.

@moem655 10 дней назад

thank you so much i was just going to complain about not finding developer default on my pc

@moem655 10 дней назад

the developer option has been removed from the 8.0.32 version too. i just downloaded it and cannot find that too

@0AutoD0 9 дней назад

@@moem655 Are you sure? it worked for me the other day. Are you downloading the exact version he is suggesting?

@davidtindell950 2 месяца назад

Thanks Sir Alex ! BTW: I used first draft version of MySQL (20+ yrs ago. We see that it has improved somewhat :)

@gtr_chauc.9332 6 месяцев назад

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.

@Mo-HARDIN 6 месяцев назад

You are so amazing ❤

@Mr.Arshad-oc1fd 21 день назад

Thanks for teaching us 🎉😊❤

@shuchigupta5270 3 месяца назад

Hello @Alexthe Analyst, I have a doubt, how to activate the lightening symbol in MySQL to execute creating tables

@mafravik 24 дня назад

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!!

@gloriaolaniya7592 3 дня назад

Thanks so much for this

@hoangngbot 4 месяца назад

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!

@javiercarrion6843 6 дней назад

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.

@juanmanuelarevalomadrid1937 23 дня назад

I just finished your older SQL playlists. How has MySQL in this series changed compared to your previous series on SQL?

@davidlein2438 23 дня назад

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

@AlexTheAnalyst 23 дня назад

Haha I just updated the bootcamp to MySQL instead of the MSSQL series - the MSSQL videos are still available if you want those :)

@marwakhaleel1351 22 дня назад

@@AlexTheAnalyst Why did you update this from MSSQL to MySQL ?

@OnlinePurchase-uy8sj 18 дней назад

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.

@SUS1234 6 месяцев назад

Amazing 🤩 greetings from Egypt 🙏💖

@SAKE42able 6 месяцев назад

Me too 🎉❤

@Osiriscribe 3 месяца назад

There is no developer default option on my installer >.> looks like im getting the full version

@eriiyanuoluwaakinola2490 2 месяца назад

me too

@aanisahjahan7058 2 месяца назад

same. what did you do? does the full version work the same?

@yatharthpratapsingh 2 месяца назад

Use custom set up and select SQL Server and SQL Documentation that should work to get your set up done.

@temidayooluwatunmibi951 19 дней назад

@@yatharthpratapsingh i want to create a root account so as to continue my configuration

@svenkucina 3 месяца назад

Great video!

@lesittelesigues4284 3 дня назад

Watching this even tho i have no laptop yet. Will just rewatch and relearn everything after I can afford one

@user-vj1qi5rn3j 2 дня назад

You would def get a laptop soon!! Wishing you best.

@ayodelefisayo8291 24 дня назад

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

@abbielmi9163 4 месяца назад

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

@Christiantalkwit_Ifeanyi 3 месяца назад

I’m having issues right now too, the installation process is tough for me😢😢😢

@ameygabaleofficial Месяц назад

@@Christiantalkwit_Ifeanyi same here!!

@Osiriscribe 3 месяца назад

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?

@JenSkillz Месяц назад

This was a very helpful video. Thank you! However, the process screens and options have changed. Which makes it more challenging for us noobs!

@yokijatiperkasa861 Месяц назад

Thankyou sir

@Mikaa_0223 6 месяцев назад

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 ??

@user-dm5kl7rv6w 5 месяцев назад

I am having the same issue

@JonErikJardine 3 месяца назад

same issue

@destinicooper8474 25 дней назад

same no option for Mac

@megaisnaeni6348 19 часов назад

same issue, no option for mac operating system

@chankorvin9281 17 дней назад

I downloaded the app but got another version and this version doesn’t have developer default option, please what do I do? Any suggestions?

@yp8666 14 дней назад

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.

@MissKazkhstan 20 дней назад

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?

@ndatenuhsidoine1608 День назад

I also need help too

@owensunuwar697 4 месяца назад

THERE IS NO DEVELOPER DEFAULT OPTION what should i do??

@AlexTheAnalyst 4 месяца назад

Use the FULL Option

@yatharthpratapsingh 2 месяца назад

@@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.

@inurspace 3 месяца назад

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.

@Christiantalkwit_Ifeanyi 3 месяца назад

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

@sonekzyad Месяц назад

there is no developer default now in the options what shall I choose?

@ahsanabro9920 17 дней назад

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 ?

@heisbenny_ 15 дней назад

Click on archives on the site and select another version

@ahmadmarzodandy6054 6 месяцев назад

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?

@juanmanuelarevalomadrid1937 23 дня назад

Same, I just finished the old MySQL serie videos, but not sure what is the difference with this whole new serie of videos.

@ahmadmarzodandy6054 23 дня назад

@@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🙌🏻

@mohamedelnashar 6 месяцев назад

while setup I have no chice of developer default , does full choic will be ok ?and great thanks to you

@factos667 5 месяцев назад

Same here too

@andersonbernard271 Месяц назад

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 ?

@ramyamallela1771 15 дней назад

Same problem here too bro. Is u got solution for this?

@sabithsaqlain1367 6 месяцев назад

Hi There is no default option for me in the installation prompt, should i select the full version or manual ?

@russellrizzo6673 3 месяца назад

any updates on this ?

@mabediphirinyane Месяц назад

Do you have a video on saving Data here from a website ?

@destinicooper8474 25 дней назад

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?!

@BicirBicir 9 дней назад

Same problem here. Have you found a solution?

@helesashams8510 22 часа назад

@@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

@kacpercedrowski5317 3 дня назад

Can I use Xampp with Maria DB not SQL Server? Its working faster on my notebook

@myne_r Месяц назад

2:33 there isnt option for 'developer default'

@farooqamin2411 18 дней назад

same goes for me. Were you able to find a solution?

@myne_r 18 дней назад

@@farooqamin2411 I remember I chose 'Custom' instead. And it works just fine

@CristanRexPatricio 16 дней назад

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

@nivedhasankaran6779 28 дней назад

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?

@paulae8990 24 дня назад

Same hereee. I installed it in my desktop, developer default was there but not available in my laptop when tried there :(

@yp8666 17 дней назад

Hi Alex, I can't begin to express just how grateful I am to you for offering this to your community for free. I'm currently in the process of a career change and I couldn't afford to take up paid bootcamp or courses, so this truly is amazing, thank you. I have just one question though, I'm currently on the 3rd video in your bootcamp playlist (Installing MySQL and Creating Databases | MySQL for Beginners) and currently the developer option isn't available anymore in version 8.0.37.0, which option should we pick to proceed with the installation? Thank you.

@heisbenny_ 15 дней назад

Click on Archives and select any version

@yp8666 14 дней назад

@@heisbenny_ Thank you so much, that really helped 😃.

@dubthis10 5 месяцев назад

If you're like me and wrote the file instead of downloading it, note that the database name is wrapped in backticks (located above the tab button on your keyboard) instead of single quotes.

@pavithrap769 20 дней назад

Hey Alex, I'm installing Mysql In choosing a setup type, developer default is not showing, other options are visible. What to do? What

@EricaThompson-ip2kh 25 дней назад

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?

@wuapdagreat1004 2 дня назад

no reply ?

@mazharul661 6 дней назад

Done!

@samsonprecious5372 5 дней назад

Hi Alex, Thank you so much for this i was at the verge of giving up when i came across this video indeed God answers prayers i have a little challenge after downloading MySQL i noticed that the developer default option is not in the setup, what do i do please?

@Ikona731 3 дня назад

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.

@akinsinasegun2379 5 месяцев назад

I clicked on the download button to get the query sql text file but it's not downloading into my pc

@tridhamukherjee4186 2 месяца назад

Hi Alex, when I am trying to install mysql the developer default option is not showing. What should I do?

@olabodeobaniyi6934 5 дней назад

Hi, i am having issues running the beginner perk _rec_create_db as it keeps saying i have an error on my SQL syntax

@aimandaud1197 11 дней назад

I chose both full and custom options but couldn't make a server connection in both cases it was always a " failed connection"

@hectorelfatherr 3 дня назад

Can i do this on a macbook or is it pretty different?

@kingbebop8323 25 дней назад

Hi Alex! I was on the other playlist that uses SSMS, does it differ from MySQL?

@ayooluwakiitan 5 дней назад

Can you point me to that playlist pls? Been looking for it

@titokhaharuman3525 5 месяцев назад

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?

@doaagamal4222 4 месяца назад

The same problem here

@skyduncan7898 3 месяца назад

Use the full Option

@Christiantalkwit_Ifeanyi 3 месяца назад

Please @alex the MySQL app that I downloaded does not have the “developer default” option in the set up type

@user-he9ps4ns2z 18 дней назад

Same here !

@Ned-kc6ru 5 дней назад

Hi Alex while trying to install MySQL i didnt see ' developer default' in the set up type. What should i do?

@tahiraleem 5 дней назад

I had to install Workbench separately. It didn't come with the main installer.

@charlesolukoju4809 18 дней назад

Thank you very much to this video. Please I have a little challenge. I followed the steps from the video, I didn't get the "Connect to Server" part

@hisokaamorou4211 4 месяца назад

i downloaded but didn't get developer default option while installing except that every other option was available.

@Rianne421 2 месяца назад

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?

@ZamanAbhi День назад

there is no Mac version for SQL, which SQL application should i download please suggest me

@bolajiraji1129 3 месяца назад

Sorry under what playlist can we get the next video

@akinsinasegun2379 6 месяцев назад

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?

@AlexTheAnalyst 6 месяцев назад

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.

@najda4057 23 дня назад

@@AlexTheAnalyst Hello there is no option for developer default, what should I pick?

@chime2684 4 месяца назад

Why is mine on offline mode when I just installed and have an active internet connection

@studionimba 2 месяца назад

Developer Default option is missing? Please help

@Bananalama23 Месяц назад

If you have used MYSQL previously, it remembers the password because it is in 'programdata' file which is hidden or in program files. Have to manually delete

@adafreroscoe6534 27 дней назад

I’m using a Mac and it isn’t included in the drop down

@nidhis9946 22 дня назад

um the download option for sql isnt available for macbooks

@umamoon5585 12 дней назад

I have the same problem, did you solve it?

@anchal_diary 6 дней назад

video is little bit blur. is it only for my of is is like that ??

@ogunyanwoadeleke314 3 дня назад

Hey Alex, I forgot mySQL password and I've been stocked at the installation phase. How can you help me.

@bhavyamurali6111 3 месяца назад

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.

@user-mq7gt5ck8j Месяц назад

Yes I have the same problem!!

@lehutsomahlodi 18 дней назад

Hey there Mr Alex, im stuck. What im seeing on your video is not what i see on my laptop😢

@4EverSimming111 15 дней назад

I just downloaded SQL but it is not giving me the Developer Default option in set-up

@prachifashionillustration6574 4 месяца назад

i am not getting this developer option. What should i do?

@mashuur8128 6 месяцев назад

The link doesn't have an option for Mac OS? Please check

@shannabanna1 3 месяца назад

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.

@Kiddo29072009 2 месяца назад

Great instruction! Unfortunatley I struggle to connect to Server. It always gives me "conncetion faild". Any hints how to solve it? I am on Windows 11, 10.0.22631 version.

@peacenwanneka7247 5 дней назад

I've been trying to download mySQL and it always give " This page isn't working or Connection failed" please how did you resolve your own ?

@peacenwanneka7247 5 дней назад

I've been trying to download mySQL and it always give " This page isn't working or Connection failed" please how did you resolve your own ?

@peacenwanneka7247 5 дней назад

I've been trying to download mySQL and it always give " This page isn't working or Connection failed" please how did you resolve your own ?

@mariabsaibes7839 6 месяцев назад

Hello, there is no option for MAC download.

@44.44aline 3 месяца назад

I thought I was the only one having this problem

@malik6896ify 3 дня назад

@@44.44aline any luck?

@malik6896ify 3 дня назад

any luck?

@fritzserrano1987 2 дня назад

is it okay if there is no developer default?

@nicolekanigina4012 24 дня назад

Is there anyway to download this on an iPad?

@josh-wi3te 6 месяцев назад

plz start ...machine learning

@omrahulpandey 14 дней назад

The script you showed in your tutorial, is not available on github

@zahracabdalla1810 13 дней назад

For installation I only have one product just mySQL server

@talalkhan359 3 месяца назад

I am not able to find the schema portion and also the sample database is not visible to me I downloaded the full version

@sandeepa8755 2 месяца назад

Try to reinstall mysql, also make sure that there is nothing related to my sql in your program files and anywhere in your computer

@Ajgabbana 6 дней назад

I'm at @9:41 but every time I right click and Click - Select Rows - Limit 1000 my SQL shuts down Does anyone know why this is happening and how I can fix this problem?

@sumaiyashaikh2471 21 день назад

Hello Alex, I have started your free course of MySQL, I have downloaded the app, but at 2:38 where we have to select the setup type as developer default...in my device the option of developer default is not mentioned...what should i do?? Please help me out!!!