Welcome back, everyone.
This is a speech and this session is about setting up the MySQL database.
Trust me, this is going to be very fun and very exciting because here will be setting up the database
from scratch again.
Let's not take enough time and get started with it.
Let's first finalize how your database should really looks like.
So what are we going to make?
We already have as much as we already have a Web site and we just want to build up, build a database
of students and the state databases.
Let's save for the academy itself for our T.G. Academy, the academy itself, where we are building
up the database for database for student information.
So we want to create a table for students, not GIs.
And the student will be having their first name, last name at Assemblance, maybe their interest and
the location of it.
Right.
So here is how it's going to look.
Students will be the table.
OK, I understand this.
A database in my school, there could be multiple databases.
OK, and each student basis can have multiple tables.
All right.
So if you select databases like my website.
OK, so this could be a database.
And in the database, my Web site or my VEP, you can have a database for students, database for gold.
I mean, sorry, table for students, table for login, information of students, table for goals,
information table for maybe a -- for many stuff.
You can have multiple tables and do it for a single database.
OK, so in our case this is what we have.
OK, so we'll be building the entire database from the scratch and I'll show you how exactly it's going
to work.
We'll be making use of my school in this case, which is open source and free of cost as well.
Let's open our MySQL server.
So this is the server that we have.
OK.
OK, what we can do is we can keep this.
I didn't see the presentation in March, so I'll keep the database on the left and this on the right.
OK, so what do you see on the right as my SQL Server?
So the first thing misconstrues is basically it's running on the you've been doing what you can do is
you can just have Ubuntu server download from a dot com or maybe any other platform, get it downloaded,
or maybe you can have the old file or watch the machine file for what's a box directly.
You can turn it up.
And the first thing that you can do is do the APD update and a video brief.
Right.
So this is what you can do once you are once you are with the area.
So this is what you have to start with once you have your system, your Linux Ubuntu machine, ready.
After that, what do you need to do is you have to install the mindscape.
The command is MySQL server.
All right.
The moment you do that, it will install demitasse good server because in my case, the server is already
installed, so I won't be having a trouble with this.
OK, so now once that is done, then you have to start the system so that you have two systems start
miles of server and oh sorry, the MySQL sort of OK, and then you can check the status of it.
It's running.
Right.
So I just started the MySQL server and it seems to be running absolutely fine.
Now in this case, what are we going to do is we are going to create a database and for that we have
to configure our entire MySQL service will be going into the MySQL instance.
We are currently into the Ubuntu.
Okay.
And you can even verify the version of it.
This is what it is.
It is a Linux machine beento that.
Supposing that the architecture is well.
So that's pretty straightforward.
Let me see why is it even more better.
OK, this looks nice.
OK, let's get started.
So in order to log into my school, you have to dial my school, log in as a group and then get into
it.
You have to specify your password.
One, if you see my school, that's that's indicates that you are in the database.
OK, now to verify if you have any database and do it.
As I told you, in my school, there can be multiple databases.
All right.
And each student bases have the multiple tables.
Right.
So let's check it out.
If we have any databases into the system, databases, you have to end up in the pool.
That's what it is, right?
If you do that directly, straight away for fail and then you have to exit in that case.
Right.
So always make use of something like this to sort of always use something like this where you end up
pretty good so that it won't create a problem for you.
OK, now this is the way you get to see about entire database.
OK.
And then exactly when you get to see all the databases and you want to create a new one, what you can
do is you can create a new database.
And for that you need to make use of the command, create a database, creative ways to say, I mean,
to my DB, for example.
And then we specified does the database has been created to verify what you can do.
So databases and information.
And then you get to see right here, my DB has been created.
OK, you see, the second database might be it has been created now.
So the freedom is created.
Now, what's next?
As I told you, if you really want to create the individual interests, you have to it's Iraqi, right?
So you have to come down from the database to the table to the individual entries.
So currently we are in the MySQL, so we have to get into the database.
So in order to go there, you can make a command, use, use my TV and then semicolon.
You are into the database now.
Database has been changed.
Right?
So currently you are into this table.
So what you are trying to do might be and you can verify if you have any papers into it, there's no
table.
So there is no table into this database.
Of course it is not.
It won't be because we have just created the database.
So we have to start creating tables now.
So what's the name of the table?
It has to be students, right?
So let's create one.
So the command would be three and then the name you have to specify the name of the table that will
be students.
And then you can specify what are the entries.
You need the first name for sure.
Right.
So we have to specify first name and then you have to define what would be the maximum number of character
that you are looking for.
So.
Hundred, and then you can have the next column off the table with the same style, last name and then.
Uh, I'm sorry that I came back to work, that's where you did find it, and again, the next one as
the increased.
All right, so interest.
And then again, they're their characters, and that's going to be a game.
Well, then we have location
and that can.
And here we go.
So the table has been created.
We are still only by TV.
So let's check it out.
If the table is really crooked, it has been created or not.
Lovely.
So you could see the table has been created and there Gollum's has been built up as well.
But there's no intrigue for sure.
There's no entry into the into this into this table and that you can even get to know when you type
like select any intrigue from people.
So that's what if you look at it, that's what we have used in the introduction as well to the from
indicates from the witch table.
So let's say I want to see anything from students.
So I don't see anything because there's no rule defined.
There's no oh, sorry.
I think we forgot to add I.D. and do it right.
We forgot to add the ID number.
And what we can do is basically you can still go ahead with this or you can make you you can probably
drop it as well.
So let's say it would be even good for you to understand how to draw up a table as well and start a
new one as well.
So let's say if you want to drop this table and create the new one, we're defining the idea and everything.
So let's say you can do it, drop table students and then you go.
So this table has now been deleted.
How you can verify that.
You see, there's no table.
Right.
But let's do it a quick job here.
We can do the better.
And that's going to solve the problem solved the problem basically.
So we can go here again.
They bidi Raccah hundred.
Oh, so what?
Right, so this is now completed.
Oh, um.
I missed some yeah, so this has been completed now and the moment we hit enter, this should be done
right.
Our table is now ready.
We can again verify with the same stuff.
So tables and see the table has been built.
Now, you can still the same way.
You can verify if there is any entry into the table.
Same about select.
As I told you, you won't be able to see anything because there's no entry.
It says, right.
We have just modified and we have just modified the column.
We have just added a column by removing the earlier right.
So there is nothing how to add individual entries, how to add basically individual rows into it so
that what you can do is you can go to insert being into the same database.
You don't have to change database or you don't have to go even further into a table as well.
You just have to be stuck.
Stick with one database and the time we are going to need to maybe we have created a table, but five
column, right.
So five column we initially created for that you have dropped and now we have the packet.
So now let's insert the information into it, insert into the name of the database students.
And that's where we define values.
Right.
So we have to specify the values.
Now, remember this.
We used to always remember how many columns you have.
So accordingly, whenever you add values, you should be sure about it.
So let's say now we know there are five columns, right?
So we'll have to add five entries accordingly.
So if one.
And then.
We have John, right, and then the Brown, then his interest is hanging.
I love John for.
And then we have a location that stands, and the moment you hit enter after semicolon, it should be
inserted, right.
So now we have added just one rule.
Do you want to see what's inside?
You can still make user select anything from this table.
And you would see this.
You got the idea.
Now, how could we add more so inside?
Number two, then you can specify the last song and his.
Sorry, well, his interests into cybersecurity for some reason.
Wonderful.
We have added one more entry, let's add the third one.
And I need that information so that it would make sense for you.
Looks pretty comfortable hacking and can.
There are many ways, in fact, there are many tools available.
But I want to show you the most innovative and most simplest, the most applicable method.
Charlie.
I'm sorry.
Charlie.
Yeah, Charlie.
And the cheese sandwiches or the lovely Neil Hacking.
All right, so he's from San Jose.
I just I'm just Johnette, let's verify the information in the tape.
And you know this, right?
If you want to see the information on the table, you're going into the I want to see all any information
from this statement.
Right from this statement.
Students lovely, isn't it?
Really cool.
Right.
So what do you can actually do as you can be even more specific about any information?
Right.
So you can even specify select staff from students there where Heidi is one.
Right.
Where it is one.
Right.
So that's how you select the individual rights to the right ideas for you.
See, what I'm really referring to, we have seen our organization where we have selected the U.S. ambassador
combination that we use to define where it is to and this and this that.
Right.
So we can even be specific about, OK, where their first name is Charlie and last name is Change.
So that entire URL will be selected.
I hope you got the idea pretty well.
And this is something which we this is the very fundamental it would be difficult to get the this idea
so straightforward in any of the hacking to do it.
But I this I feel this is very, very important for you to understand.
The estriol injection and making use of Escadrille during this penetration testing is really, really
important.
All right.
So I hope you got the idea.
We'll catch you in the next session.
And thank you.