In order to explore more unprotected ABC News, the details manager, we need a database where we can
store our user details.
So once we store those user details, we can make changes inside our application in such a way where
we are leveraging to discuss the details, minutia to validate the user's presence inside the database
during authentication process, that you are free to create a database anywhere, either in your cloud
or in a local mission, so that we can get those data source credentials, details of my Escorial into
a springboard application configuration.
So in this scenario, I choose to create a free time MySQL database since it is more than enough for
an application.
So I'll show you how to create a database in the eight years and how to configure the same into a springboard
application as a database.
So for the first go to the database Amazon.com.
If you already have an account, try to go and click on a management console.
If it asks credentials, please.
In other words, if you don't have a code in eight years, you can always create an account.
And I'm assuring you, whatever we do in this course is completely free and we never select a database
which will charge some money to it.
So I'm just going to my account and clicking mission management consultant here and entering my credentials
posts that once you are on to the database management console, search for the ideal services, which
is mainly relational database rich.
So I can create a database here.
I'll go with an option of easy create, since it's almost the fastest way of creating a database.
And you'll also have an option of selecting the database server that you want to go with Oracle, Myskina
or Postgres.
But here in this scenario, I will select my school and here you have three instance, type one, this
particular instance and the other one is which you can use fluid environments like devlopment, testing,
environment.
But for this course we should be good with the free to instance.
Selecting that and database instance identifier is the name inside your alias.
I'm just giving some database instance.
Identify a name.
You're free to do whatever name you want provided by master user name so you can have and use a new
whatever you want.
So in this scenario, I'm just giving you a name as admin followed by you have to provide your master
username password and thus giving the password that I want for my admin username.
Please make sure you are remembering these credentials because they are very important later on when
we try to connect to the application or any ask you a client application post entering password details.
I'm good with Waterview default settings provided by Alias.
Once you verify everything you can click on create a database which will create a database in your NWS
console.
So now I have a database created which is of the name database to which I just know creator.
Usually it will take 10 to 15 minutes to create a new database, but you can wait till it shows available
and you keep on refreshing the same to see what is the latest status.
Once your database is available, select the specific database and click on Modify, the reason that
we want to modify is by default, your database will not be open to public network.
So if we want to access this database through your code, which is present inside your computer, a
laptop, you have to make sure whatever database that you have created is open to public access for
the same.
Just scroll down to down where you can see additional connectivity configuration here.
I have already changed the public accessible.
That's why it is there.
But for you, if you are doing this for the first time by default, the option not publicly accessible
is selected and you have to change it to publicly accessible.
And you also have an option of changing the portal.
But for now, just keep only publicly accessible and let the board member with the phone number.
Whatever minuscule it has with this, if you click on sale changes, you have an option of to apply
the changes immediately, which will restart your server.
Otherwise you can wait till the next scheduled maintenance window.
But in this scenario, I just wanted to have immediately changes.
But here, since there are no modifications done by me, the modified B B instances disable.
But you are free to go and apply this modified Beeby instance, which will bring you a server down for
five to 10 minutes.
And you can always see the status by going to the database as a dashboard.
And once the system is available, you are free to use it.
Now we have successfully created a database and we made configurations such a way that it can be accessed
publicly by anyone who knows the credentials and connection database.
For this, I will show you what the connection details if you click on this database to it will show
you the end point, which is the host name and phone number and credentials will be whatever you have
created using master username.
So to connect to this database, I will go ahead and download my client application, which is a skill
upon GitHub that I will.
From there you can go and download a secure electronic application by clicking on download UI and as
part of your operating system you can search for the dump and download it.
For me, it's a Windows operating system.
How to download the ones I have downloaded this how that application looks.
I have to create a connection there.
By clicking here.
It will ask me what is our database name that you want to give for your preference?
I will just say easy bang.
My school database is the connection name that I want to create and database is minuscule.
And whose name is the one that you can copy from Alias, which is this endpoint you are on board.
Name is a different one and username is the one I have created with this admin and password, whatever
I have created.
Once you enter the credentials click contest, if the database is open to public and the credentials,
everything is correct.
It will show you successfully connected post that you can see this connection.
Now, I will try to connect to that database here.
And you can see right now this is a brand new database and we don't have any details inside it.
With this, we successfully created a database in the cloud and connected through sample MySQL client
application, which is a secure electron.
In the next few videos will connect this database to a springboard application.
Along with that, we also create the tables user details in this database.
Thank you.
And see you in the next room by.