1 00:00:00,420 --> 00:00:00,990 Warning. 2 00:00:01,320 --> 00:00:06,570 This video may contain extremely frustrating installation instructions and is for experienced developers 3 00:00:06,570 --> 00:00:07,200 only. 4 00:00:07,500 --> 00:00:11,890 It's advised that you install using Cloud nine to avoid needless pain and anger. 5 00:00:11,910 --> 00:00:12,330 All right. 6 00:00:12,330 --> 00:00:16,860 If you're still here after the stern warning, I'll talk about how to install MySQL on Windows. 7 00:00:16,890 --> 00:00:17,280 Of course. 8 00:00:17,280 --> 00:00:22,020 Remember, you will probably run into some sort of issue depending on your computer and what you have 9 00:00:22,020 --> 00:00:23,040 installed already. 10 00:00:23,070 --> 00:00:24,570 It can be difficult. 11 00:00:24,570 --> 00:00:29,790 So that's why I really, really, really recommend that you use cloud nine skip windows until the end 12 00:00:29,790 --> 00:00:30,480 of the course. 13 00:00:31,230 --> 00:00:32,570 That's enough of a broken record. 14 00:00:32,580 --> 00:00:33,560 Let's get started. 15 00:00:33,570 --> 00:00:41,130 So to install MySQL on a PC, we need to go to MySQL and then click on the download section and then 16 00:00:41,130 --> 00:00:43,920 click on community and other community. 17 00:00:43,920 --> 00:00:45,540 You can actually click on any of these. 18 00:00:45,540 --> 00:00:50,430 If you click on download, what it's going to suggest for you if you're a Windows user, is that you 19 00:00:50,430 --> 00:00:55,270 actually use the MySQL installer rather than downloading things individually. 20 00:00:55,290 --> 00:01:00,180 Basically, it's a package that will help install a bunch of MySQL things all at once that you may or 21 00:01:00,180 --> 00:01:00,860 may not use. 22 00:01:00,910 --> 00:01:01,860 You may or may not need. 23 00:01:01,860 --> 00:01:05,760 Make sure that you have the correct version selected depending on your architecture. 24 00:01:05,760 --> 00:01:09,990 Then click download and it looks like it starts downloading, but it actually doesn't. 25 00:01:09,990 --> 00:01:12,390 You have to click another button at the bottom. 26 00:01:12,390 --> 00:01:12,990 No thanks. 27 00:01:12,990 --> 00:01:15,840 Just start my download and then I'll fast forward through. 28 00:01:15,840 --> 00:01:20,970 This takes a little bit to download depending on your internet, but then once it's done, all we want 29 00:01:20,970 --> 00:01:23,640 to do is open it up, run the installer. 30 00:01:24,540 --> 00:01:25,890 So then we have a couple of options. 31 00:01:25,890 --> 00:01:30,990 We're going to select developer default and then click next and then depending on what you have installed 32 00:01:30,990 --> 00:01:34,140 on your computer, you may need to actually install some other requirements. 33 00:01:34,140 --> 00:01:35,430 So I did here. 34 00:01:35,610 --> 00:01:41,340 So I basically had to go through a couple of times double click, click execute, wait for something 35 00:01:41,340 --> 00:01:44,250 else to go install in this case, Visual C++. 36 00:01:44,700 --> 00:01:47,010 And then I had to repeat that a couple of different times. 37 00:01:47,010 --> 00:01:51,390 Now that will probably be different for you and your machine, but then once that finishes, click on 38 00:01:51,390 --> 00:01:55,110 Execute Again and this will actually start the installation process. 39 00:01:55,110 --> 00:02:00,390 So there's a bunch of components installing, but once they're complete, click next and then we move 40 00:02:00,390 --> 00:02:04,560 on to configuration and all we really care about is configuring the server. 41 00:02:04,560 --> 00:02:08,820 So we'll click next again, basically click next another time. 42 00:02:08,820 --> 00:02:10,199 We don't need to change anything. 43 00:02:10,199 --> 00:02:13,470 And further, another time click next. 44 00:02:15,230 --> 00:02:15,470 Okay. 45 00:02:15,820 --> 00:02:21,790 So we're now at the point where we need to decide on a root password for my SQL so you can decide on 46 00:02:21,790 --> 00:02:22,680 whatever you like. 47 00:02:22,690 --> 00:02:25,120 I just chose password, the word password. 48 00:02:25,120 --> 00:02:28,480 It's not a good password, but I wanted to make it simple, easy to remember. 49 00:02:28,480 --> 00:02:31,210 So you type it in twice, tells me that it's weak. 50 00:02:31,480 --> 00:02:35,140 And then I'm also going to add a user here, you don't have to do this. 51 00:02:35,290 --> 00:02:37,030 I'm just going to make one with the name Colt. 52 00:02:37,030 --> 00:02:42,700 And also the password will be password and then confirm the password also tells me that it's weak and 53 00:02:42,700 --> 00:02:47,230 I'll click, okay, so really all that you need to do is remember whatever password you type for the 54 00:02:47,230 --> 00:02:51,100 root and then click next and then we'll click next one more time. 55 00:02:51,100 --> 00:02:56,680 And then finally again we'll click Execute and it will start to apply the configuration and it may take 56 00:02:56,680 --> 00:03:01,030 a moment or two, but then once it finishes, everything should be installed. 57 00:03:01,420 --> 00:03:03,850 So we'll click finish and then get out of here. 58 00:03:03,850 --> 00:03:05,560 So that's how we install. 59 00:03:05,560 --> 00:03:10,690 The next important thing is starting up the command line client, which you can find just under my SQL 60 00:03:10,690 --> 00:03:11,920 Command Line client. 61 00:03:11,920 --> 00:03:16,390 Click on it and then you'll need to enter your root password, which in my case was password. 62 00:03:16,570 --> 00:03:21,670 And now we're able to actually type some code, something like show databases, which we haven't talked 63 00:03:21,670 --> 00:03:23,650 about, but you can type code in there. 64 00:03:23,650 --> 00:03:27,400 You can also try typing things that aren't SQL and you'll see you get error messages. 65 00:03:27,400 --> 00:03:31,420 But all that we really need to care about is that we have the command line client up and running and 66 00:03:31,420 --> 00:03:32,650 we can type stuff into it.