Hello, friend, welcome back in this video will start a new session, it's about how can create one
good application with using MySQL database.
Good applications means if you want to create or if you want to insert some of the data into the database,
if you want to read these data from the database, if you want to update these data or if you want to
delete this data from the database, how can do that?
Work is step by step.
I will show you that things with the live example suffering before I have already discussed about that
things with you.
We have used some of the Django, one of that building database.
So we have use of the Django building database.
That is the name as is collate.
So as I told you, this is Goliath is not much a professional of the database right now.
We will work some of the professional database.
So for the professional database, I want to do want to use that our my skill.
So if you want to use that MySQL, first of all, you have to do you have to install that.
And Jambi is one of the local server.
You have to do you have to download it.
OK, so that if you it in Google then it will get a lot of the resources for downloading.
This is totally free.
One of the software you have to do, you have to download it and install it in your system and after
you install it, you can get this tape up one of the popup.
So first of all, here you have to do you have to run your apogee.
So here you have to ram this Apache and the reaction of the MySQL.
So that's all we also needed for the reasons.
First of all, you have to run two of these.
And when you successfully installed the Jambi in your system after installing that, if you don't down
the localhost.
Then you can see that is actually all localhost and under the localhost, you can find out everything.
So if you go to your you version.
So right now I'm using that BHP version, seven point three point seven.
And also, if you want to find out that escrow server.
So his name is as a PSP myat been.
So you have to click on here and here.
You can see that is actually the MySQL server database area and there is all that database server version.
So here I am right now.
I'm using the server version, ten point four.
Make sure you updated your databases, Crossharbour.
And also I'm using the space version, seven point three point seven.
So we will create one of the code application with this advance of the provisional database software.
So that is actually the issue.
I have been so right now I want to work in particular that area.
So if you want to use that MySQL, first of all, you have to do you have to add one of the packets.
So in general, we have to add of the package right now.
I just stream will be open the terminal again, and that is our project.
Right.
So this project, first of all, I want to do is still on the package.
So for the MySQL, they have also on the package.
So if you want to install it, you have to write down as a B and the uninstall and then the MySQL client.
OK, so that is actually the one document as a P install and MySQL client.
So first of all, we have to do we have to install it so not to enter.
And now here you can see, friend, you snowshoeing as a requirement, already satisfied.
That means I have already installed in our system so far the results is not showing as a requirement,
already satisfied.
But if you install it not the first time, it may take a little time.
You will be downloaded all that file from the Internet, then automatically it will be installed the
total package in your system.
OK.
So right now I have already installed it for the reason system.
Legal system showing as a requirement, already satisfied.
So make that you're going to install this by being installed with the MySQL package, then make sure
you are connected to the Internet because it will be downloaded all that file from the Internet.
Now we have to do we have to configure it.
So if you want to configure it, you have to go to your my project.
That means my Fuseproject area.
So I just simply open it seems to this my first project that have the setting, DCPI.
So now go to that setting the by and now here, if you will, get on the database like here, if you
a little bit go here, you can see that the database area.
So by default within installed that can go by default.
We use that is I tried as I told you before, so by default that was actually escalate.
So now I want to change it.
So if you want to change it also to have the database, one of the commandos, so they have some of
the link, if you copy it, I just simply copy it and now go here and open it.
And now here you can see that Django project and they have all the investigation.
So by default, that was actually that this one that was the database default engine at a skylight and
no one to do and to change it without my school.
So if you want to use that MySQL, then you have to do we have to copy it.
So I just simply copy everything from here, OK?
I just simply copy everything.
Before that was actually like that we sat down to do and update it.
So no, I just simply copy and now go to our site.
That means in our setting fire here.
I want to do I want to update it.
I just simply based our new one.
So right now we will use our MySQL.
So for the MySQL configuration, we have to defining it as a database default engine.
And here we have to define our database, name, database, user name, database password, horse name
and the name.
And here now I will use my scale for the reasons here we have to do.
We have to change it.
So here after the backings, I just want to change it as a MySQL.
I name it as a my skill, OK, I just name it as my skill.
And now we have to do we have to create one of the database and we have to also define database, username
and password.
So for creating the database, as I told you, we have to do we have to go to our place, my admin localhost
right now.
I'm using that Sam.
And here I have already opened our aperture and the MySQL.
Right.
So now that is two.
This is it started.
So now if you want to create a new database into my piece, you I mean, you have to do we have to go
to that database and into the database here.
I want to do and create one of the new database.
So I just name it as if my underscore whatever he wants right now.
I'm actually using that my fast my fast under is called Django.
So this type of one of the database name, I want to create software that you have to do.
You have to just simply click as a create.
Now you can see our database is now successfully created.
So now if you have to, do we have to copy your database name so that your database name and now go
to our configuration and that is our database name.
You have to define on particular that position either simply defining it.
OK, so that will be our database name.
And also we have to put our database username and password.
So for right now, I'm using that Zamp and for the Zamp.
If you go your main homepage and if you go to that user account and into the user account here you can
see there is a user name by default at the root.
OK, so user name by default as a rule in your localhost and hostname as a localhost.
And the password.
Right now I, I don't have any password.
So for the reasons I just want to do, I just, just simply copied the fruit.
That bizarre user name will be as a root and password.
Right now I don't have any password.
So for the reasons I just make the things as empty and the holes.
You can also use it either then.
Right now I want to do want to use this hostname as a localhost.
I just simply copied and now here I just simply paste it.
OK, so here I just simply define our hostname and also the port, if you open yourself into the Zamp
here, consider the airport as a three three zero six.
So I don't want to use it as a three three zero six.
So that's all you have to do for configure your MySQL database with your general project.
So in our next video, we have to do we have to migrate our all the table because I have already created
some of the models right into the fast project I have already created to have this model as a musician
and the album.
So now we have to do we have to migrate it and we will migrated.
Then automatically Django will create all the table in our database.
That means here I have already created all the database, so that is the database I have defined.
So that is actually my first Django Django.
Right.
So here automatically it will be created.
All that data, that table.
OK, so how can I get it?
In our next video, I will show that things with a live example.
So thanks for watching and I'll see you the next video.