1 00:00:00,060 --> 00:00:00,930 Welcome back, everyone. 2 00:00:00,960 --> 00:00:06,160 This is a speech and this session is about setting up the MySQL database. 3 00:00:06,180 --> 00:00:13,530 Trust me, this is going to be very fun and very exciting because here will be setting up the database 4 00:00:13,530 --> 00:00:15,580 from scratch again. 5 00:00:16,470 --> 00:00:18,960 Let's not take enough time and get started with it. 6 00:00:19,860 --> 00:00:23,070 Let's first finalize how your database should really looks like. 7 00:00:23,100 --> 00:00:25,300 So what are we going to make? 8 00:00:25,320 --> 00:00:33,090 We already have as much as we already have a Web site and we just want to build up, build a database 9 00:00:33,090 --> 00:00:37,050 of students and the state databases. 10 00:00:37,060 --> 00:00:45,030 Let's save for the academy itself for our T.G. Academy, the academy itself, where we are building 11 00:00:45,030 --> 00:00:50,590 up the database for database for student information. 12 00:00:51,090 --> 00:00:54,840 So we want to create a table for students, not GIs. 13 00:00:54,840 --> 00:01:00,780 And the student will be having their first name, last name at Assemblance, maybe their interest and 14 00:01:00,780 --> 00:01:01,790 the location of it. 15 00:01:01,800 --> 00:01:02,070 Right. 16 00:01:02,100 --> 00:01:04,860 So here is how it's going to look. 17 00:01:05,250 --> 00:01:06,660 Students will be the table. 18 00:01:07,500 --> 00:01:09,240 OK, I understand this. 19 00:01:09,240 --> 00:01:14,470 A database in my school, there could be multiple databases. 20 00:01:14,490 --> 00:01:18,910 OK, and each student basis can have multiple tables. 21 00:01:19,080 --> 00:01:19,470 All right. 22 00:01:19,830 --> 00:01:25,190 So if you select databases like my website. 23 00:01:25,230 --> 00:01:27,390 OK, so this could be a database. 24 00:01:27,390 --> 00:01:35,180 And in the database, my Web site or my VEP, you can have a database for students, database for gold. 25 00:01:35,190 --> 00:01:44,460 I mean, sorry, table for students, table for login, information of students, table for goals, 26 00:01:44,460 --> 00:01:52,500 information table for maybe a -- for many stuff. 27 00:01:52,500 --> 00:01:55,980 You can have multiple tables and do it for a single database. 28 00:01:56,010 --> 00:01:59,040 OK, so in our case this is what we have. 29 00:01:59,170 --> 00:02:04,410 OK, so we'll be building the entire database from the scratch and I'll show you how exactly it's going 30 00:02:04,410 --> 00:02:04,700 to work. 31 00:02:04,950 --> 00:02:12,270 We'll be making use of my school in this case, which is open source and free of cost as well. 32 00:02:13,500 --> 00:02:15,640 Let's open our MySQL server. 33 00:02:15,660 --> 00:02:18,250 So this is the server that we have. 34 00:02:19,120 --> 00:02:19,640 OK. 35 00:02:22,320 --> 00:02:22,920 OK. 36 00:02:29,030 --> 00:02:32,120 OK, what we can do is we can keep this. 37 00:02:35,860 --> 00:02:45,820 I didn't see the presentation in March, so I'll keep the database on the left and this on the right. 38 00:02:45,850 --> 00:02:51,410 OK, so what do you see on the right as my SQL Server? 39 00:02:51,760 --> 00:02:57,160 So the first thing misconstrues is basically it's running on the you've been doing what you can do is 40 00:02:57,160 --> 00:03:03,850 you can just have Ubuntu server download from a dot com or maybe any other platform, get it downloaded, 41 00:03:04,060 --> 00:03:10,140 or maybe you can have the old file or watch the machine file for what's a box directly. 42 00:03:10,590 --> 00:03:11,680 You can turn it up. 43 00:03:11,680 --> 00:03:17,260 And the first thing that you can do is do the APD update and a video brief. 44 00:03:17,320 --> 00:03:17,610 Right. 45 00:03:17,650 --> 00:03:26,800 So this is what you can do once you are once you are with the area. 46 00:03:27,580 --> 00:03:34,060 So this is what you have to start with once you have your system, your Linux Ubuntu machine, ready. 47 00:03:34,480 --> 00:03:38,560 After that, what do you need to do is you have to install the mindscape. 48 00:03:38,920 --> 00:03:40,780 The command is MySQL server. 49 00:03:40,990 --> 00:03:41,430 All right. 50 00:03:41,710 --> 00:03:47,320 The moment you do that, it will install demitasse good server because in my case, the server is already 51 00:03:47,320 --> 00:03:50,240 installed, so I won't be having a trouble with this. 52 00:03:50,290 --> 00:03:59,950 OK, so now once that is done, then you have to start the system so that you have two systems start 53 00:04:00,610 --> 00:04:13,840 miles of server and oh sorry, the MySQL sort of OK, and then you can check the status of it. 54 00:04:16,300 --> 00:04:16,960 It's running. 55 00:04:16,960 --> 00:04:17,250 Right. 56 00:04:17,680 --> 00:04:23,470 So I just started the MySQL server and it seems to be running absolutely fine. 57 00:04:23,710 --> 00:04:29,710 Now in this case, what are we going to do is we are going to create a database and for that we have 58 00:04:29,710 --> 00:04:37,120 to configure our entire MySQL service will be going into the MySQL instance. 59 00:04:37,340 --> 00:04:39,520 We are currently into the Ubuntu. 60 00:04:39,530 --> 00:04:39,930 Okay. 61 00:04:40,390 --> 00:04:43,270 And you can even verify the version of it. 62 00:04:43,780 --> 00:04:44,700 This is what it is. 63 00:04:44,710 --> 00:04:47,160 It is a Linux machine beento that. 64 00:04:47,160 --> 00:04:49,830 Supposing that the architecture is well. 65 00:04:49,840 --> 00:04:51,580 So that's pretty straightforward. 66 00:04:53,200 --> 00:04:56,970 Let me see why is it even more better. 67 00:04:58,300 --> 00:05:00,880 OK, this looks nice. 68 00:05:00,910 --> 00:05:02,800 OK, let's get started. 69 00:05:02,830 --> 00:05:10,030 So in order to log into my school, you have to dial my school, log in as a group and then get into 70 00:05:10,030 --> 00:05:10,180 it. 71 00:05:10,300 --> 00:05:12,090 You have to specify your password. 72 00:05:13,180 --> 00:05:19,360 One, if you see my school, that's that's indicates that you are in the database. 73 00:05:19,390 --> 00:05:24,790 OK, now to verify if you have any database and do it. 74 00:05:25,090 --> 00:05:28,430 As I told you, in my school, there can be multiple databases. 75 00:05:28,450 --> 00:05:28,800 All right. 76 00:05:28,960 --> 00:05:32,170 And each student bases have the multiple tables. 77 00:05:32,170 --> 00:05:32,440 Right. 78 00:05:33,430 --> 00:05:34,570 So let's check it out. 79 00:05:34,580 --> 00:05:41,920 If we have any databases into the system, databases, you have to end up in the pool. 80 00:05:42,670 --> 00:05:43,810 That's what it is, right? 81 00:05:44,200 --> 00:05:50,710 If you do that directly, straight away for fail and then you have to exit in that case. 82 00:05:50,720 --> 00:05:50,930 Right. 83 00:05:51,490 --> 00:06:01,390 So always make use of something like this to sort of always use something like this where you end up 84 00:06:01,390 --> 00:06:05,470 pretty good so that it won't create a problem for you. 85 00:06:05,800 --> 00:06:12,610 OK, now this is the way you get to see about entire database. 86 00:06:13,360 --> 00:06:13,780 OK. 87 00:06:13,810 --> 00:06:22,360 And then exactly when you get to see all the databases and you want to create a new one, what you can 88 00:06:22,360 --> 00:06:25,270 do is you can create a new database. 89 00:06:25,750 --> 00:06:34,510 And for that you need to make use of the command, create a database, creative ways to say, I mean, 90 00:06:34,510 --> 00:06:37,030 to my DB, for example. 91 00:06:37,030 --> 00:06:44,220 And then we specified does the database has been created to verify what you can do. 92 00:06:44,230 --> 00:06:48,280 So databases and information. 93 00:06:48,280 --> 00:06:52,690 And then you get to see right here, my DB has been created. 94 00:06:52,880 --> 00:06:56,490 OK, you see, the second database might be it has been created now. 95 00:06:56,740 --> 00:06:58,580 So the freedom is created. 96 00:06:58,600 --> 00:06:59,630 Now, what's next? 97 00:06:59,650 --> 00:07:07,380 As I told you, if you really want to create the individual interests, you have to it's Iraqi, right? 98 00:07:07,390 --> 00:07:12,970 So you have to come down from the database to the table to the individual entries. 99 00:07:13,180 --> 00:07:16,840 So currently we are in the MySQL, so we have to get into the database. 100 00:07:17,110 --> 00:07:23,360 So in order to go there, you can make a command, use, use my TV and then semicolon. 101 00:07:23,800 --> 00:07:26,060 You are into the database now. 102 00:07:26,080 --> 00:07:27,260 Database has been changed. 103 00:07:27,300 --> 00:07:27,500 Right? 104 00:07:27,820 --> 00:07:30,550 So currently you are into this table. 105 00:07:30,560 --> 00:07:37,780 So what you are trying to do might be and you can verify if you have any papers into it, there's no 106 00:07:37,780 --> 00:07:38,200 table. 107 00:07:38,560 --> 00:07:40,960 So there is no table into this database. 108 00:07:41,530 --> 00:07:42,520 Of course it is not. 109 00:07:42,520 --> 00:07:45,670 It won't be because we have just created the database. 110 00:07:45,670 --> 00:07:48,690 So we have to start creating tables now. 111 00:07:49,000 --> 00:07:50,320 So what's the name of the table? 112 00:07:50,350 --> 00:07:51,960 It has to be students, right? 113 00:07:52,480 --> 00:07:53,540 So let's create one. 114 00:07:53,620 --> 00:08:03,250 So the command would be three and then the name you have to specify the name of the table that will 115 00:08:03,250 --> 00:08:04,030 be students. 116 00:08:04,030 --> 00:08:07,690 And then you can specify what are the entries. 117 00:08:07,690 --> 00:08:09,860 You need the first name for sure. 118 00:08:09,880 --> 00:08:10,160 Right. 119 00:08:10,240 --> 00:08:16,690 So we have to specify first name and then you have to define what would be the maximum number of character 120 00:08:17,140 --> 00:08:18,500 that you are looking for. 121 00:08:18,520 --> 00:08:18,910 So. 122 00:08:20,690 --> 00:08:31,470 Hundred, and then you can have the next column off the table with the same style, last name and then. 123 00:08:33,780 --> 00:08:42,900 Uh, I'm sorry that I came back to work, that's where you did find it, and again, the next one as 124 00:08:42,900 --> 00:08:43,650 the increased. 125 00:08:44,840 --> 00:08:47,010 All right, so interest. 126 00:08:47,030 --> 00:08:52,780 And then again, they're their characters, and that's going to be a game. 127 00:08:55,520 --> 00:08:58,430 Well, then we have location 128 00:09:01,550 --> 00:09:02,990 and that can. 129 00:09:06,630 --> 00:09:09,100 And here we go. 130 00:09:09,500 --> 00:09:10,740 So the table has been created. 131 00:09:10,760 --> 00:09:12,220 We are still only by TV. 132 00:09:12,440 --> 00:09:13,480 So let's check it out. 133 00:09:13,490 --> 00:09:17,730 If the table is really crooked, it has been created or not. 134 00:09:18,260 --> 00:09:18,740 Lovely. 135 00:09:19,010 --> 00:09:24,110 So you could see the table has been created and there Gollum's has been built up as well. 136 00:09:24,470 --> 00:09:26,780 But there's no intrigue for sure. 137 00:09:26,780 --> 00:09:35,350 There's no entry into the into this into this table and that you can even get to know when you type 138 00:09:35,360 --> 00:09:39,010 like select any intrigue from people. 139 00:09:39,200 --> 00:09:45,380 So that's what if you look at it, that's what we have used in the introduction as well to the from 140 00:09:45,380 --> 00:09:47,440 indicates from the witch table. 141 00:09:47,930 --> 00:09:50,750 So let's say I want to see anything from students. 142 00:09:51,800 --> 00:09:55,310 So I don't see anything because there's no rule defined. 143 00:09:55,310 --> 00:09:57,050 There's no oh, sorry. 144 00:09:57,050 --> 00:10:00,290 I think we forgot to add I.D. and do it right. 145 00:10:00,740 --> 00:10:03,080 We forgot to add the ID number. 146 00:10:03,200 --> 00:10:11,270 And what we can do is basically you can still go ahead with this or you can make you you can probably 147 00:10:11,270 --> 00:10:12,290 drop it as well. 148 00:10:12,410 --> 00:10:17,780 So let's say it would be even good for you to understand how to draw up a table as well and start a 149 00:10:17,780 --> 00:10:18,910 new one as well. 150 00:10:19,730 --> 00:10:25,060 So let's say if you want to drop this table and create the new one, we're defining the idea and everything. 151 00:10:25,070 --> 00:10:33,740 So let's say you can do it, drop table students and then you go. 152 00:10:33,860 --> 00:10:37,250 So this table has now been deleted. 153 00:10:37,820 --> 00:10:39,110 How you can verify that. 154 00:10:39,620 --> 00:10:40,770 You see, there's no table. 155 00:10:40,790 --> 00:10:41,030 Right. 156 00:10:41,390 --> 00:10:43,910 But let's do it a quick job here. 157 00:10:44,450 --> 00:10:45,950 We can do the better. 158 00:10:46,070 --> 00:10:50,030 And that's going to solve the problem solved the problem basically. 159 00:10:50,030 --> 00:10:51,560 So we can go here again. 160 00:10:52,010 --> 00:10:57,870 They bidi Raccah hundred. 161 00:10:59,790 --> 00:11:02,660 Oh, so what? 162 00:11:03,150 --> 00:11:06,900 Right, so this is now completed. 163 00:11:09,420 --> 00:11:12,210 Oh, um. 164 00:11:19,350 --> 00:11:28,390 I missed some yeah, so this has been completed now and the moment we hit enter, this should be done 165 00:11:28,750 --> 00:11:29,140 right. 166 00:11:29,230 --> 00:11:31,060 Our table is now ready. 167 00:11:31,090 --> 00:11:33,160 We can again verify with the same stuff. 168 00:11:33,160 --> 00:11:37,260 So tables and see the table has been built. 169 00:11:37,660 --> 00:11:39,970 Now, you can still the same way. 170 00:11:39,970 --> 00:11:43,080 You can verify if there is any entry into the table. 171 00:11:43,450 --> 00:11:44,650 Same about select. 172 00:11:45,580 --> 00:11:49,270 As I told you, you won't be able to see anything because there's no entry. 173 00:11:49,270 --> 00:11:50,320 It says, right. 174 00:11:50,560 --> 00:11:53,970 We have just modified and we have just modified the column. 175 00:11:53,980 --> 00:11:57,840 We have just added a column by removing the earlier right. 176 00:11:57,940 --> 00:12:04,570 So there is nothing how to add individual entries, how to add basically individual rows into it so 177 00:12:04,600 --> 00:12:09,520 that what you can do is you can go to insert being into the same database. 178 00:12:09,530 --> 00:12:14,510 You don't have to change database or you don't have to go even further into a table as well. 179 00:12:14,540 --> 00:12:16,130 You just have to be stuck. 180 00:12:16,270 --> 00:12:24,580 Stick with one database and the time we are going to need to maybe we have created a table, but five 181 00:12:24,580 --> 00:12:25,420 column, right. 182 00:12:25,510 --> 00:12:30,870 So five column we initially created for that you have dropped and now we have the packet. 183 00:12:31,210 --> 00:12:40,030 So now let's insert the information into it, insert into the name of the database students. 184 00:12:40,300 --> 00:12:42,190 And that's where we define values. 185 00:12:42,190 --> 00:12:42,470 Right. 186 00:12:42,520 --> 00:12:45,020 So we have to specify the values. 187 00:12:45,050 --> 00:12:46,450 Now, remember this. 188 00:12:46,450 --> 00:12:49,800 We used to always remember how many columns you have. 189 00:12:49,810 --> 00:12:54,060 So accordingly, whenever you add values, you should be sure about it. 190 00:12:54,700 --> 00:13:00,130 So let's say now we know there are five columns, right? 191 00:13:00,160 --> 00:13:03,450 So we'll have to add five entries accordingly. 192 00:13:03,820 --> 00:13:04,630 So if one. 193 00:13:06,570 --> 00:13:07,500 And then. 194 00:13:09,320 --> 00:13:19,800 We have John, right, and then the Brown, then his interest is hanging. 195 00:13:20,560 --> 00:13:22,540 I love John for. 196 00:13:25,190 --> 00:13:35,570 And then we have a location that stands, and the moment you hit enter after semicolon, it should be 197 00:13:36,440 --> 00:13:38,000 inserted, right. 198 00:13:38,030 --> 00:13:40,330 So now we have added just one rule. 199 00:13:41,120 --> 00:13:42,830 Do you want to see what's inside? 200 00:13:42,980 --> 00:13:47,750 You can still make user select anything from this table. 201 00:13:47,750 --> 00:13:48,830 And you would see this. 202 00:13:49,160 --> 00:13:49,960 You got the idea. 203 00:13:50,300 --> 00:13:52,910 Now, how could we add more so inside? 204 00:13:57,160 --> 00:14:06,370 Number two, then you can specify the last song and his. 205 00:14:10,400 --> 00:14:17,620 Sorry, well, his interests into cybersecurity for some reason. 206 00:14:21,620 --> 00:14:22,220 Wonderful. 207 00:14:22,400 --> 00:14:27,380 We have added one more entry, let's add the third one. 208 00:14:31,750 --> 00:14:39,010 And I need that information so that it would make sense for you. 209 00:14:39,790 --> 00:14:46,780 Looks pretty comfortable hacking and can. 210 00:14:47,500 --> 00:14:50,070 There are many ways, in fact, there are many tools available. 211 00:14:50,440 --> 00:14:58,950 But I want to show you the most innovative and most simplest, the most applicable method. 212 00:15:01,450 --> 00:15:01,930 Charlie. 213 00:15:02,590 --> 00:15:03,310 I'm sorry. 214 00:15:04,180 --> 00:15:05,000 Charlie. 215 00:15:05,040 --> 00:15:05,530 Charlie. 216 00:15:05,530 --> 00:15:05,950 Charlie. 217 00:15:05,950 --> 00:15:06,300 Charlie. 218 00:15:06,340 --> 00:15:08,050 Yeah, Charlie. 219 00:15:08,050 --> 00:15:14,110 And the cheese sandwiches or the lovely Neil Hacking. 220 00:15:18,830 --> 00:15:21,110 All right, so he's from San Jose. 221 00:15:21,830 --> 00:15:26,510 I just I'm just Johnette, let's verify the information in the tape. 222 00:15:26,840 --> 00:15:28,570 And you know this, right? 223 00:15:28,580 --> 00:15:35,540 If you want to see the information on the table, you're going into the I want to see all any information 224 00:15:35,540 --> 00:15:36,730 from this statement. 225 00:15:37,010 --> 00:15:38,000 Right from this statement. 226 00:15:38,000 --> 00:15:42,080 Students lovely, isn't it? 227 00:15:42,080 --> 00:15:43,000 Really cool. 228 00:15:43,490 --> 00:15:43,790 Right. 229 00:15:44,240 --> 00:15:50,260 So what do you can actually do as you can be even more specific about any information? 230 00:15:50,270 --> 00:15:50,540 Right. 231 00:15:50,810 --> 00:16:02,600 So you can even specify select staff from students there where Heidi is one. 232 00:16:03,710 --> 00:16:04,040 Right. 233 00:16:05,480 --> 00:16:06,650 Where it is one. 234 00:16:06,830 --> 00:16:07,170 Right. 235 00:16:07,190 --> 00:16:15,020 So that's how you select the individual rights to the right ideas for you. 236 00:16:15,020 --> 00:16:21,800 See, what I'm really referring to, we have seen our organization where we have selected the U.S. ambassador 237 00:16:21,800 --> 00:16:26,720 combination that we use to define where it is to and this and this that. 238 00:16:26,720 --> 00:16:26,990 Right. 239 00:16:27,230 --> 00:16:34,620 So we can even be specific about, OK, where their first name is Charlie and last name is Change. 240 00:16:34,670 --> 00:16:37,770 So that entire URL will be selected. 241 00:16:38,540 --> 00:16:40,640 I hope you got the idea pretty well. 242 00:16:40,910 --> 00:16:48,350 And this is something which we this is the very fundamental it would be difficult to get the this idea 243 00:16:48,350 --> 00:16:52,790 so straightforward in any of the hacking to do it. 244 00:16:53,420 --> 00:16:57,710 But I this I feel this is very, very important for you to understand. 245 00:16:57,710 --> 00:17:04,700 The estriol injection and making use of Escadrille during this penetration testing is really, really 246 00:17:04,700 --> 00:17:05,180 important. 247 00:17:05,330 --> 00:17:05,650 All right. 248 00:17:05,990 --> 00:17:07,940 So I hope you got the idea. 249 00:17:08,510 --> 00:17:09,700 We'll catch you in the next session. 250 00:17:09,710 --> 00:17:10,430 And thank you.