WEBVTT 1 00:00:01.161 --> 00:00:01.994 Hey! 2 00:00:01.994 --> 00:00:04.909 In this video, we're going to learn how to install MySQL 3 00:00:04.909 --> 00:00:06.659 on Microsoft Windows. 4 00:00:10.742 --> 00:00:12.124 So as far as the topics here, 5 00:00:12.124 --> 00:00:14.751 the first thing we're going to do is download MySQL, 6 00:00:14.751 --> 00:00:16.716 then we'll install MySQL, 7 00:00:16.716 --> 00:00:19.926 and then finally we'll verify our installation. 8 00:00:19.926 --> 00:00:21.479 Alright, so a lot of good stuff. 9 00:00:21.479 --> 00:00:25.062 Let's go ahead and jump in and get started. 10 00:00:28.935 --> 00:00:31.547 Alright, so what we need to do is open up a web browser 11 00:00:31.547 --> 00:00:33.446 and visit the MySQL website. 12 00:00:33.446 --> 00:00:37.613 So here my browser I'll type in dev.mysql.com/downloads 13 00:00:39.175 --> 00:00:43.686 and this will take me to the MySQL downloads site. 14 00:00:43.686 --> 00:00:45.037 Alright, once I'm at the page 15 00:00:45.037 --> 00:00:49.273 I want to download the MySQL community server 16 00:00:49.273 --> 00:00:51.215 and on the community server page, 17 00:00:51.215 --> 00:00:52.860 they have an option here for downloading it 18 00:00:52.860 --> 00:00:54.556 for Microsoft Windows. 19 00:00:54.556 --> 00:00:59.484 I'll go ahead and select that option for downloading. 20 00:00:59.484 --> 00:01:01.614 This will take me to the download page 21 00:01:01.614 --> 00:01:02.712 and I'll select the option here 22 00:01:02.712 --> 00:01:06.053 for downloading the Microsoft Windows MSI installer 23 00:01:06.053 --> 00:01:07.455 and I'll chose the web version. 24 00:01:07.455 --> 00:01:10.372 It's a small, light weight version. 25 00:01:11.426 --> 00:01:13.234 Now normally they want you to log in, 26 00:01:13.234 --> 00:01:14.627 but in this case I'll say no thanks, 27 00:01:14.627 --> 00:01:17.627 just go ahead and start my download. 28 00:01:20.276 --> 00:01:22.743 Alright, so your browser will prompt you to save the file. 29 00:01:22.743 --> 00:01:23.941 I'll go ahead and save the file. 30 00:01:23.941 --> 00:01:28.108 And it will start downloading it to my file system. 31 00:01:31.154 --> 00:01:31.987 Okay, great. 32 00:01:31.987 --> 00:01:32.901 So it's downloaded. 33 00:01:32.901 --> 00:01:35.107 We can open up our windows explorer, 34 00:01:35.107 --> 00:01:37.302 move into the downloads folder. 35 00:01:37.302 --> 00:01:41.190 And now what I want to do is simply the start the installer. 36 00:01:41.190 --> 00:01:42.023 So this will start up 37 00:01:42.023 --> 00:01:45.523 a normal Microsoft Windows install wizard. 38 00:01:46.836 --> 00:01:48.769 Alright, so the standard thing here, right? 39 00:01:48.769 --> 00:01:50.739 License agreement, go ahead and check the box 40 00:01:50.739 --> 00:01:52.223 I accept the agreement. 41 00:01:52.223 --> 00:01:54.774 Go ahead and click next. 42 00:01:54.774 --> 00:01:56.867 Here we want to keep the developer defaults, 43 00:01:56.867 --> 00:02:00.950 so just make no changes there. Developer default. 44 00:02:03.987 --> 00:02:06.350 Next they're going to check some of the requirements 45 00:02:06.350 --> 00:02:07.183 of your system. 46 00:02:07.183 --> 00:02:10.570 So the first product listed here is the MySQL work bench. 47 00:02:10.570 --> 00:02:14.206 We need to install the Microsoft Visual C++ runtime 48 00:02:14.206 --> 00:02:16.540 but the installer will actually do this for you. 49 00:02:16.540 --> 00:02:19.022 So we'll simply select that and hit execute 50 00:02:19.022 --> 00:02:20.171 and it will go out to the web 51 00:02:20.171 --> 00:02:22.609 and it will download the appropriate dependencies 52 00:02:22.609 --> 00:02:23.442 that you need. 53 00:02:23.442 --> 00:02:26.458 So I'll just click, click, click, accept all the defaults 54 00:02:26.458 --> 00:02:28.623 as it goes through this example. 55 00:02:28.623 --> 00:02:30.684 And it's at that point that we have everything available 56 00:02:30.684 --> 00:02:32.207 for MySQL workbench. 57 00:02:32.207 --> 00:02:34.239 It will prompt us about some of the other products. 58 00:02:34.239 --> 00:02:36.982 You can just go ahead and just click past that. 59 00:02:36.982 --> 00:02:38.100 And then just hit execute 60 00:02:38.100 --> 00:02:40.355 and it will start downloading all the dependencies 61 00:02:40.355 --> 00:02:41.350 that you need. 62 00:02:41.350 --> 00:02:43.390 So this will take a while. 63 00:02:43.390 --> 00:02:44.914 I'll kind of step away 64 00:02:44.914 --> 00:02:48.731 and I'll come back once everything is downloaded. 65 00:02:48.731 --> 00:02:49.564 Okay, great. 66 00:02:49.564 --> 00:02:50.397 So we've downloaded everything. 67 00:02:50.397 --> 00:02:52.205 Note here we have all green checks here 68 00:02:52.205 --> 00:02:54.256 and the status is complete for everything. 69 00:02:54.256 --> 00:02:55.507 So we're in good shape. 70 00:02:55.507 --> 00:02:58.434 So we can go ahead and click next. 71 00:02:58.434 --> 00:03:00.941 Click next one more time. 72 00:03:00.941 --> 00:03:03.696 Here we'll set up some of the networking. 73 00:03:03.696 --> 00:03:05.106 We'll just keep all of the defaults. 74 00:03:05.106 --> 00:03:06.398 Click next. 75 00:03:06.398 --> 00:03:09.568 At this point we'll need to define our root password. 76 00:03:09.568 --> 00:03:11.994 So you can give whatever you want for your root password. 77 00:03:11.994 --> 00:03:13.794 You can call it FUBAR, whatever. 78 00:03:13.794 --> 00:03:15.648 I'm going to give a long password 79 00:03:15.648 --> 00:03:18.385 just so it comes out as a strong password. 80 00:03:18.385 --> 00:03:19.713 But you can give whatever you want. 81 00:03:19.713 --> 00:03:21.697 You can give a four letter password if you like. 82 00:03:21.697 --> 00:03:22.640 The key item here 83 00:03:22.640 --> 00:03:25.659 is that you need to remember that password. 84 00:03:25.659 --> 00:03:27.841 Make sure you write it down (laughs). 85 00:03:27.841 --> 00:03:29.397 Alright, I'll go ahead and click next. 86 00:03:29.397 --> 00:03:30.524 I'll keep the defaults here. 87 00:03:30.524 --> 00:03:33.023 It's going to run MySQL as a windows service. 88 00:03:33.023 --> 00:03:34.445 I'll click execute, 89 00:03:34.445 --> 00:03:36.009 and it will go off and it will start applying 90 00:03:36.009 --> 00:03:38.926 our server configurations. 91 00:03:38.926 --> 00:03:41.509 I'll hit finish, I'll hit next. 92 00:03:43.648 --> 00:03:45.245 And now we're going to do a simple test 93 00:03:45.245 --> 00:03:46.302 to connect to our server. 94 00:03:46.302 --> 00:03:48.991 Click the check button, connection successful. 95 00:03:48.991 --> 00:03:50.028 We're okay. 96 00:03:50.028 --> 00:03:53.330 And then we hit next, and finished, and next one more time. 97 00:03:53.330 --> 00:03:54.293 And at this point, 98 00:03:54.293 --> 00:03:56.163 we hit finish and it will actually start up 99 00:03:56.163 --> 00:03:57.679 the MySQL server. 100 00:03:57.679 --> 00:04:00.369 So now what we're going to do is verify our installation. 101 00:04:00.369 --> 00:04:02.381 So I'm going to use this MySQL workbench. 102 00:04:02.381 --> 00:04:04.930 It's simply a web gooey tool, 103 00:04:04.930 --> 00:04:06.688 I'm sorry it's simply just a gooey tool, 104 00:04:06.688 --> 00:04:09.585 that allows you to connect to your MySQL database. 105 00:04:09.585 --> 00:04:11.570 So here I just enter that same password 106 00:04:11.570 --> 00:04:13.102 I did during installation. 107 00:04:13.102 --> 00:04:15.693 And at this point I have a gooey open 108 00:04:15.693 --> 00:04:17.937 and I can actually query some of the tables. 109 00:04:17.937 --> 00:04:22.256 So MySQL always starts off with some sample tables for you. 110 00:04:22.256 --> 00:04:25.710 I'm going to access this one table called city 111 00:04:25.710 --> 00:04:26.706 and I'll just do this little, 112 00:04:26.706 --> 00:04:28.879 I'll right click, say select rows. 113 00:04:28.879 --> 00:04:31.196 And this will give me all the rows from the sample table. 114 00:04:31.196 --> 00:04:32.302 So, again, really here, 115 00:04:32.302 --> 00:04:34.738 we're just verifying that we can connect to the database 116 00:04:34.738 --> 00:04:36.446 and do a basic query. 117 00:04:36.446 --> 00:04:38.286 So this all looks really really good. 118 00:04:38.286 --> 00:04:41.627 So our server's up and running and we can query it. 119 00:04:41.627 --> 00:04:43.215 Alright, so this kind of wraps up the video. 120 00:04:43.215 --> 00:04:45.592 So we went through the process of downloading MySQL, 121 00:04:45.592 --> 00:04:49.653 installing it, and then finally you ran the MySQL workbench 122 00:04:49.653 --> 00:04:51.034 just to verify our installation. 123 00:04:51.034 --> 00:04:53.464 And at this point, MySQL is up and running, 124 00:04:53.464 --> 00:04:54.509 we're in good shape, 125 00:04:54.509 --> 00:04:57.790 and now we can use it later on in our jsf videos. 126 00:04:57.790 --> 00:04:58.623 Good job.