WEBVTT 00:07.010 --> 00:11.390 So go over to your browser and type in MySQL on your browser. 00:11.390 --> 00:14.600 And once you do that, go ahead and hit enter. 00:14.600 --> 00:18.110 And that is going to bring you to this awesome page right in here. 00:18.470 --> 00:20.330 So you can see the very first link here. 00:20.360 --> 00:22.820 You can scroll down and see some of the things right in there. 00:22.850 --> 00:27.110 But what I need is the very first link right in here that is MySQL. 00:27.140 --> 00:28.790 Go ahead and hit on that. 00:28.790 --> 00:33.440 And it's going to bring us to this awesome page MySQL Enterprise Edition. 00:33.440 --> 00:35.960 So it has other things right here. 00:35.960 --> 00:38.480 So we are not interested in anything here. 00:38.510 --> 00:42.320 What do we need right now is to go ahead and hit on downloads. 00:42.320 --> 00:47.000 So once you hit on downloads is going to get us to this awesome page. 00:47.000 --> 00:52.310 So now we need to download the MySQL community edition. 00:52.310 --> 00:56.720 So move down and you can see MySQL community downloads. 00:56.720 --> 00:59.000 So go ahead and hit on this. 00:59.000 --> 01:02.150 And that is going to bring us to this awesome page. 01:02.300 --> 01:08.280 So if you get to this page, go ahead and look for MySQL installer for windows. 01:08.310 --> 01:13.350 In case you're working on windows PC, because that is what I'm using for this course. 01:13.350 --> 01:16.260 So go ahead and hit on install for this window. 01:16.260 --> 01:19.260 And that is going to bring us to this awesome page. 01:19.260 --> 01:21.420 So MySQL Community Edition. 01:21.420 --> 01:22.950 And this is where we have. 01:22.950 --> 01:26.910 So right now go ahead and hit on downloads. 01:26.910 --> 01:29.490 So the very first one right here warhead. 01:29.490 --> 01:30.630 And hit on that. 01:30.630 --> 01:32.610 So it can be able to download the installer. 01:32.610 --> 01:36.000 And if you do that it's going to pop up this. 01:36.030 --> 01:38.310 It says no thanks. 01:38.310 --> 01:40.170 Just start my download. 01:40.170 --> 01:43.140 So if wants to log in or sign up you can go ahead and do that. 01:43.140 --> 01:47.040 But for the sake of this course go ahead and hit on no thanks. 01:47.040 --> 01:51.810 And just start my downloads and your download will start immediately. 01:51.810 --> 01:54.990 So now I have downloaded this and it's already on my system. 01:54.990 --> 02:00.720 And the way I'm taking all these steps is to show us the step by step guide on how to download this 02:00.720 --> 02:02.040 and get started. 02:02.040 --> 02:05.970 So now let me go ahead and start the installation of this. 02:06.530 --> 02:10.730 So I have this on my computer right here, which I have just downloaded right now. 02:10.760 --> 02:14.780 Go ahead and double click on this so you can be able to start. 02:14.810 --> 02:15.800 Go ahead and hit on. 02:15.830 --> 02:20.000 Yes and it will start the download process immediately. 02:20.000 --> 02:22.640 So whenever I go ahead and hit on yes. 02:22.640 --> 02:31.550 And that we go to start off immediately and I can see the installer 1.6 and it's going on. 02:31.550 --> 02:34.580 And right now that is coming up. 02:34.580 --> 02:38.840 So you have some set of options to choose. 02:38.840 --> 02:40.640 You can choose the setup type you need. 02:40.670 --> 02:44.870 But for this course we go ahead and choose on Custom Setup. 02:44.870 --> 02:47.330 Now go ahead and hit on next. 02:47.330 --> 02:49.790 And right in here we need two things. 02:49.790 --> 02:51.980 That is the server and the workbench. 02:51.980 --> 02:55.130 Because we are going to use the workbench for this. 02:55.130 --> 02:58.850 So go ahead and hit on this and open up the server. 02:58.850 --> 03:05.480 And right in here I'm going to choose the latest server edition which is the very first one here. 03:05.480 --> 03:07.760 So go ahead and select this. 03:07.760 --> 03:09.680 So it moves over to this point. 03:09.730 --> 03:12.010 so we can discuss. 03:12.040 --> 03:13.330 It might have been updated. 03:13.330 --> 03:17.050 So always choose the latest version because it is more secure. 03:17.080 --> 03:19.660 Now go ahead and choose applications. 03:19.660 --> 03:25.000 And you can see I have MySQL workbench, MySQL shell and MySQL router. 03:25.000 --> 03:30.160 So go ahead and open up the MySQL workbench and then go ahead and open it again. 03:30.160 --> 03:32.890 And I'm going to choose the latest version right in here. 03:32.890 --> 03:35.350 So go ahead and put that right in here. 03:35.350 --> 03:38.320 So at this point I am ready to go. 03:38.350 --> 03:40.150 Go ahead and hit on next. 03:40.150 --> 03:42.820 And then go ahead and execute this. 03:42.820 --> 03:47.470 So once you click on execute you can see that it will begin to download. 03:47.470 --> 03:54.460 And the download process will just take a short while and everything will be downloaded for us. 03:55.120 --> 03:57.940 So everything is already downloaded. 03:57.940 --> 03:58.660 You can see that. 03:58.690 --> 04:03.010 Then we go ahead and hit on next and are ready to install. 04:03.040 --> 04:07.000 Go ahead and hit on execute and it will begin installation. 04:07.000 --> 04:09.250 And that will take most of our time. 04:09.250 --> 04:11.590 We go ahead and get everything set. 04:11.590 --> 04:14.060 So it is a story MySQL server. 04:14.060 --> 04:16.100 And that is um, was done. 04:16.100 --> 04:21.200 And after the server is installed, if you move over to installing the workbench and that is what is 04:21.200 --> 04:22.220 going on right now. 04:22.220 --> 04:24.440 So very soon that will be done for us. 04:26.450 --> 04:31.520 So now we have completed the installation of our MySQL server and MySQL workbench. 04:31.520 --> 04:35.150 Go ahead and hit on next and we are ready to configure. 04:35.180 --> 04:36.770 Go ahead and hit on next. 04:36.770 --> 04:41.570 And uh right here I have some other applications running on my system. 04:41.570 --> 04:45.320 And you can see that port 306 is already in use. 04:45.320 --> 04:49.430 So if you are installing this you're going to have port 3063. 04:49.430 --> 04:50.990 So go ahead and continue. 04:51.020 --> 04:54.560 Your installation is in port 3063306. 04:54.560 --> 05:01.430 So I mean this is port 3306 is already in use because I have other applications running on my computers. 05:01.430 --> 05:05.900 So we can go ahead and change that for my own system alone. 05:05.900 --> 05:09.890 So I'm using port 33068. 05:09.920 --> 05:13.760 But on your case go ahead and maintain port 3306. 05:13.790 --> 05:14.180 All right. 05:14.180 --> 05:18.480 So don't ever change that if you are not using that at the moment. 05:18.480 --> 05:20.490 So it's going to be free for you. 05:20.490 --> 05:21.780 You go ahead and continue. 05:21.810 --> 05:22.950 Don't ever change it. 05:22.980 --> 05:28.650 But if you have something that's not being used, all you need to do is to go ahead and change your 05:28.650 --> 05:30.420 port and continue. 05:30.450 --> 05:35.490 Or you go ahead and uninstall some things that you have installed on your computer previously. 05:35.520 --> 05:38.580 Now let's go ahead, because I don't want to uninstall anything on my computer. 05:38.580 --> 05:40.530 I'll go ahead and continue on next. 05:40.530 --> 05:44.730 So go ahead and follow me with port 3306 on your own computer. 05:44.760 --> 05:45.150 Go ahead. 05:45.150 --> 05:50.040 I hit on next and it says use strong password encryption for authentication. 05:50.040 --> 05:52.020 So go ahead and hit on next. 05:52.020 --> 05:55.080 And I'm going to enter the password. 05:55.080 --> 05:58.320 So I'm going to enter a strong password. 05:58.320 --> 06:05.130 So I had an anti strong password though it will say weak because my password is not as strong as it's 06:05.130 --> 06:06.150 supposed to be. 06:06.240 --> 06:11.760 So go ahead and ensure you have a strong password so that someone cannot penetrate your database. 06:11.790 --> 06:15.150 Now I can add a user, but that is beyond the scope of this. 06:15.150 --> 06:17.430 We are not going to do that at the moment. 06:17.430 --> 06:22.870 I don't want to add any user, I just want to continue because I'm using this laptop just by myself 06:22.870 --> 06:23.230 alone. 06:23.230 --> 06:27.160 So I'm the one using this account and I'm not sharing with anybody. 06:27.190 --> 06:29.020 Now go ahead and hit on next. 06:29.020 --> 06:38.080 And uh, we'll go ahead and hit on next and hit I hit on next and then it will be gone to apply the 06:38.080 --> 06:40.750 configuration step by step. 06:41.920 --> 06:47.410 So what I need to do now is to go ahead and click on execute for the configuration to start applying. 06:47.410 --> 06:50.350 And it will always much of a time everything will be applied. 06:50.350 --> 06:53.770 And then we go ahead and continue immediately. 06:54.220 --> 06:57.040 So the configuration has been applied successfully. 06:57.040 --> 07:03.310 You can see below here the configuration from MySQL server 8.0.39 was successful. 07:03.340 --> 07:05.500 Click on finish to continue. 07:05.530 --> 07:07.360 So go ahead and click on finish. 07:07.360 --> 07:11.350 And uh we'll go ahead and hit on next. 07:11.350 --> 07:15.280 And that is such a procedure has been completed. 07:15.310 --> 07:17.530 Start MySQL workbench after set up. 07:17.530 --> 07:19.600 Go ahead and hit on finish. 07:19.600 --> 07:26.190 And the MySQL workbench bench is going to start immediately, so it can be able to see that and then 07:26.190 --> 07:29.460 continue in the as soon as possible. 07:31.410 --> 07:33.270 Alright, so this is what we have right in here. 07:33.300 --> 07:36.090 I'll go ahead and make sure everything is in order. 07:36.120 --> 07:38.490 So we have this local instance MySQL. 07:38.520 --> 07:41.400 If you go ahead you can go ahead and click on this. 07:41.430 --> 07:47.700 If you click on this it's going to require you to input the password which is the root password. 07:47.700 --> 07:49.080 But I'm going to close this. 07:49.080 --> 07:54.090 I will show you how to be able to open up this in case if you have an issue in future ahead and delete 07:54.090 --> 07:57.180 this connection, I'll go ahead and delete the connection. 07:57.210 --> 07:59.310 They want to delete connection local instance. 07:59.310 --> 08:00.060 Yes. 08:00.090 --> 08:05.580 Now if you want to create your own connection from scratch, go ahead and go over to MySQL connections 08:05.580 --> 08:07.890 and hit on this plus button right in here. 08:07.890 --> 08:13.590 And you can go ahead and name this to be local hosts. 08:13.590 --> 08:21.990 So I'll name that to local host and connection method is a tcp IP and the host name is equal to this. 08:22.020 --> 08:28.150 Then the port I'm going to change this to port 2.13308 because there was a pot I put in when I was doing 08:28.150 --> 08:28.960 the installation. 08:28.960 --> 08:31.480 But you are on pot 3306. 08:31.510 --> 08:34.540 I will ask you to remain there if that is what it imputes. 08:34.570 --> 08:37.210 When we are doing the installation and that is the default. 08:37.210 --> 08:40.450 So go ahead and maintain that and continue with this. 08:40.450 --> 08:46.360 But if you change that previously or had an input that the pot which you entered and then go ahead and 08:46.360 --> 08:47.800 hit on okay. 08:47.800 --> 08:51.130 And we have Lucas right in here. 08:51.130 --> 08:54.670 So go ahead and hit on this and it's going to come up. 08:54.670 --> 08:57.490 So go back and put in your password and then go ahead. 08:57.520 --> 09:00.520 You can set the password or go ahead and click on okay. 09:00.520 --> 09:04.990 And that is going to open up the MySQL workbench for us. 09:04.990 --> 09:07.660 So we have the MySQL workbench right in here. 09:07.660 --> 09:10.090 And I hope that looks so beautiful and so awesome. 09:10.090 --> 09:13.030 So I can go ahead and close some of these windows. 09:13.030 --> 09:14.890 If I click on this this is off. 09:14.890 --> 09:17.500 So this is where I clicked and that went off. 09:17.500 --> 09:21.670 So you want to close the action output I'll go ahead and hit on this. 09:21.670 --> 09:23.260 The action output is off. 09:23.260 --> 09:25.390 And if I click on that it comes back. 09:25.390 --> 09:31.260 So the sidebar which is this, I can go ahead and close that, and they can see that there's no sidebar. 09:31.800 --> 09:32.340 All right. 09:32.340 --> 09:33.810 You can do this without any sidebar. 09:33.810 --> 09:35.070 So go ahead and click on that. 09:35.070 --> 09:40.650 You can see that whenever it is on blue it's going to always show whatever I click on the sidebar. 09:40.680 --> 09:42.570 There are actual outputs. 09:42.570 --> 09:46.680 Or maybe this one right in the automatic context helps disable. 09:46.680 --> 09:49.860 So I can always close this one because I don't actually need that. 09:49.890 --> 09:57.210 Now, if I want to change the look and feel of this place, go over to edit and go over to preferences 09:57.210 --> 09:58.680 and it's going to open up. 09:58.680 --> 10:04.230 So go over to Font and Colors and I'm going to move over to defaults. 10:04.230 --> 10:08.100 And I'll go ahead and hit on Windows 7 and click okay. 10:08.130 --> 10:11.160 And you can see that look and feel is now very sweet. 10:11.160 --> 10:12.300 I hope that is cool. 10:12.660 --> 10:17.850 So now let's go over to the next video lecture and create a database using MySQL workbench. 10:17.880 --> 10:18.390 Thank you. 10:18.390 --> 10:21.120 And I'm going to see you in the next video lecture.