1 00:00:01,140 --> 00:00:08,850 So is no, we are going to try this as clearly on our own as a computer, you know, need to install 2 00:00:08,940 --> 00:00:10,560 this or any practices. 3 00:00:11,280 --> 00:00:13,920 I want you to understand the background of this. 4 00:00:13,920 --> 00:00:17,390 A school like Aquarius and that's it. 5 00:00:17,400 --> 00:00:18,600 You don't need to practice. 6 00:00:18,600 --> 00:00:19,440 It's optional. 7 00:00:19,440 --> 00:00:22,430 If you want to practice, you can download this in the next hour. 8 00:00:22,480 --> 00:00:29,340 And witness of the basics of a school, uh, skills transfer structure, code language. 9 00:00:29,340 --> 00:00:31,200 And it's not a programming language. 10 00:00:31,630 --> 00:00:38,370 Uh, it stands for structure language, which means that we need to send the Kuwaitis in a structured 11 00:00:38,370 --> 00:00:42,450 manner to get the information out of the information in the database. 12 00:00:42,990 --> 00:00:50,250 Of course, there is a programming version of the school that is Karpe in the school where you can automate 13 00:00:50,250 --> 00:00:54,420 the school queries and also can represent the variables. 14 00:00:54,600 --> 00:00:56,900 So you're not going into that much debt? 15 00:00:57,130 --> 00:01:02,640 Uh, we're just seeing the perspective about this. 16 00:01:03,000 --> 00:01:08,190 So there are different versions of a school or a school, Microsoft, the school, etc. So the basics 17 00:01:08,190 --> 00:01:09,200 index will be the same. 18 00:01:09,390 --> 00:01:15,810 And what these guys will do is they will add some additional comments, uh, like a condensed somewhat 19 00:01:16,510 --> 00:01:22,320 atmosphere to type of comments to create the databases are to share the database. 20 00:01:22,920 --> 00:01:28,280 But the basic syntax of this school remains constant in all the, uh, languages. 21 00:01:28,770 --> 00:01:34,440 So we are going to do this my school that's, uh, Google towards my school downloads. 22 00:01:35,130 --> 00:01:40,550 And you can see my school documents, the website, and there is an enterprise edition. 23 00:01:40,560 --> 00:01:41,610 We don't want that. 24 00:01:41,640 --> 00:01:44,850 And we just go with this free community edition. 25 00:01:46,830 --> 00:01:51,480 And you can see there are, uh, some of these community service and workbench. 26 00:01:51,870 --> 00:01:57,390 Uh, first we are going to introduce community server and we are going to introduce workbench orders. 27 00:01:57,630 --> 00:02:03,040 We can start using this Microsoft MySQL installer to install both of these software. 28 00:02:03,130 --> 00:02:04,350 So let's click on this. 29 00:02:04,560 --> 00:02:11,100 So this community server will start Azara, this MySQL and using this workbench, we will connect to 30 00:02:11,100 --> 00:02:13,990 this server and we can operate on the database. 31 00:02:14,250 --> 00:02:16,410 This which is a graphical user interface. 32 00:02:16,560 --> 00:02:22,950 And this is my excursionists, uh, command line based on this initiative for Windows. 33 00:02:23,520 --> 00:02:32,130 And you can see there are two versions, uh, that do but only but this is a webpage and this is our 34 00:02:32,130 --> 00:02:32,750 friend Sara. 35 00:02:32,940 --> 00:02:36,180 So I prefer to operate, ensure we can download. 36 00:02:38,610 --> 00:02:43,870 So you can it's asking for raggedness up, you can just click this no, just Tatmadaw. 37 00:02:47,500 --> 00:02:49,780 And say to Florida, we want. 38 00:03:02,720 --> 00:03:11,120 So meantime, there is some theory about this, my school, so this school is very nice subject, but 39 00:03:11,120 --> 00:03:17,630 also to very difficult if we go in depth because I just concentrate on the basics to pass my course 40 00:03:17,630 --> 00:03:23,810 in my college, there is a school course and it's very, very hard and not if you go into this school, 41 00:03:23,810 --> 00:03:28,040 you will encounter this storm called Big Data. 42 00:03:28,670 --> 00:03:31,580 That is the new storm now going on, big data. 43 00:03:31,880 --> 00:03:38,360 And the this is data mining where you will have the so much of data and you will extract the useful 44 00:03:38,360 --> 00:03:41,360 information from these databases and data warehouses. 45 00:03:41,780 --> 00:03:43,550 So we are not going that much. 46 00:03:43,820 --> 00:03:53,390 We are just seeing the basics and the penetration testing point of this is where we can, uh, had this 47 00:03:53,390 --> 00:03:58,810 MySQL, uh, Esker vulnerability and how we can inject our own query. 48 00:03:59,420 --> 00:04:01,760 So my Insha has been downloaded. 49 00:04:02,330 --> 00:04:03,380 Let me click on this. 50 00:04:08,350 --> 00:04:09,580 So, Ron, this fire. 51 00:04:26,280 --> 00:04:34,740 So now my my school instructor has been shuttered and it's asking some options and I will go with this 52 00:04:34,760 --> 00:04:41,160 developer deferred and click on next, you can see the contents that are going to be installed. 53 00:04:41,580 --> 00:04:47,880 And my government is also going to be installed, you know, little river strings of energy that local 54 00:04:47,880 --> 00:04:49,920 conditions are a part of our next. 55 00:04:52,750 --> 00:04:59,560 And the father recommends how failing the foreign products, failing the requirements, so we don't 56 00:04:59,560 --> 00:05:05,340 need any of this now because we are, uh, concentrating only on school basics. 57 00:05:05,620 --> 00:05:08,950 So if you want to come to the show, you are to put on character. 58 00:05:08,950 --> 00:05:14,710 You can insure this or you can click on next one on more products have not been satisfied. 59 00:05:15,010 --> 00:05:15,310 Yes. 60 00:05:15,310 --> 00:05:17,500 I want to continue now. 61 00:05:17,530 --> 00:05:19,990 These products are going to be installed on our computer. 62 00:05:20,650 --> 00:05:21,010 Keep. 63 00:05:42,890 --> 00:05:49,570 So all the components of this my school has been in, you can see the green tick mark here and it has 64 00:05:49,650 --> 00:05:54,950 your shot, the suburban shell and to the Java and C++ program. 65 00:05:55,580 --> 00:06:02,980 So you can import this grapple with this MySQL database using a new programming language and not a script 66 00:06:02,990 --> 00:06:03,470 niched. 67 00:06:06,420 --> 00:06:09,150 Now we need to configure our server, Keegan, next. 68 00:06:13,430 --> 00:06:18,050 So we need to leave it as far as General Myers concerned and click on next. 69 00:06:19,750 --> 00:06:29,920 And I can see you can see this as a development computer and click on next, and you can see here the 70 00:06:29,930 --> 00:06:34,710 Wall Street, which you can see in here, but I'm not going to change Gregan next. 71 00:06:35,760 --> 00:06:43,540 I know we are going to set the password for this authentication connection and we need to set the password. 72 00:06:52,710 --> 00:06:54,690 So let's click on the next. 73 00:06:57,100 --> 00:07:00,430 And on this, OK? 74 00:07:00,520 --> 00:07:02,560 It's already been set to start on. 75 00:07:03,960 --> 00:07:08,390 And you can also check this, if you don't want my SQL Server at the system, shut up. 76 00:07:08,440 --> 00:07:11,470 And I want this as some sort of Gregan next. 77 00:07:13,950 --> 00:07:17,670 Now, what good are these comments? 78 00:07:42,250 --> 00:07:44,160 Already, the configuration has been set. 79 00:07:46,930 --> 00:07:51,320 Yes, it's some firewalls and initializing database and the server has been shattered. 80 00:07:52,280 --> 00:07:53,320 Now we can finish. 81 00:07:56,360 --> 00:08:05,120 And click on next and click on Finish and again next again, no. 82 00:08:08,700 --> 00:08:16,350 We need to type in the password we have entered before this, OK, actions are easier to find. 83 00:08:16,460 --> 00:08:21,360 That's when the default username is root and the password is what you have entered before. 84 00:08:21,750 --> 00:08:32,180 Uh, and, uh, trenchers carried a box of connectional now connected to. 85 00:08:59,980 --> 00:09:04,210 So now let's click on this finish and click on next. 86 00:09:06,680 --> 00:09:14,150 And now it's asking to start this, my government and I just can't take this, shall we only need the 87 00:09:14,150 --> 00:09:15,950 workbench click can finish. 88 00:09:32,690 --> 00:09:38,850 So as you can see, my school performance has been shattered, concede consider is already a connection. 89 00:09:39,120 --> 00:09:43,340 Let me deal this or the connection. 90 00:09:44,360 --> 00:09:46,310 And now let's add a new correction. 91 00:09:46,430 --> 00:09:54,080 Click on this icon and you this correction in, let's say, a local my school. 92 00:09:54,740 --> 00:09:55,940 Sorry, my school. 93 00:09:57,890 --> 00:09:59,000 My school server. 94 00:09:59,600 --> 00:10:00,020 Right. 95 00:10:00,770 --> 00:10:06,200 And this is my IP address, Brocklehurst and about three three zero six. 96 00:10:06,560 --> 00:10:07,850 And username is rude. 97 00:10:08,240 --> 00:10:13,460 If you have added their username, you need to put that username here and click on this coding world. 98 00:10:14,450 --> 00:10:22,970 So to enter the password, it will be permanently record in the world of the password and click on talk 99 00:10:23,030 --> 00:10:27,620 and how I think I have entered the card, not on this connection before. 100 00:10:27,620 --> 00:10:32,990 Okay, this is very important step because if you click it, then you need to test this again. 101 00:10:33,560 --> 00:10:38,810 But it's better, better practice to test this connection. 102 00:10:38,810 --> 00:10:46,560 Now, are you going to successfully make the school connection and now you're going to get now double 103 00:10:46,580 --> 00:10:47,360 click on this. 104 00:10:52,990 --> 00:10:59,920 As you can see, no interface has been opened, no, I can execute some rescue workers then that will 105 00:10:59,920 --> 00:11:01,720 reflect on our database. 106 00:11:02,000 --> 00:11:08,490 We can also create multiple databases and multiple databases through databases. 107 00:11:08,650 --> 00:11:12,570 So these are all this is not the MySQL workbench. 108 00:11:12,580 --> 00:11:16,150 And in the next few days, we see some high school basics. 109 00:11:16,150 --> 00:11:20,170 And I will also explain this and was no need to worry about that. 110 00:11:21,250 --> 00:11:29,550 The main thing is, even if you do not practice this MySQL queries, you need to just watch these videos 111 00:11:29,560 --> 00:11:30,850 because it's very important 112 00:11:34,060 --> 00:11:35,830 you will understand how the skill works. 113 00:11:36,460 --> 00:11:45,160 I can just say the in action by showing you the command and where the operations will divide the one 114 00:11:45,160 --> 00:11:47,740 quarter into the two queries and then I can just show you. 115 00:11:47,780 --> 00:11:48,070 Right. 116 00:11:48,340 --> 00:11:55,660 But understanding this back in a school, basics, not only the skill outsider backing will help you 117 00:11:55,660 --> 00:12:01,780 understand how this how this masculinization or any other data is getting. 118 00:12:02,470 --> 00:12:05,290 So that's very important from a potential point of view. 119 00:12:05,560 --> 00:12:07,920 So it's learning to the basics of this. 120 00:12:07,930 --> 00:12:10,610 Bakan So that's all for this video. 121 00:12:10,630 --> 00:12:12,100 I hope you have understood. 122 00:12:12,520 --> 00:12:17,850 If you are just not inside this school, just watch the basics video. 123 00:12:18,640 --> 00:12:24,000 I highly recommend to ensure this workbench and the practice is good.