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.

