1 00:00:00,150 --> 00:00:06,510 In order to explore more unprotected ABC News, the details manager, we need a database where we can 2 00:00:06,510 --> 00:00:08,510 store our user details. 3 00:00:08,850 --> 00:00:15,750 So once we store those user details, we can make changes inside our application in such a way where 4 00:00:15,750 --> 00:00:21,750 we are leveraging to discuss the details, minutia to validate the user's presence inside the database 5 00:00:22,020 --> 00:00:29,370 during authentication process, that you are free to create a database anywhere, either in your cloud 6 00:00:29,370 --> 00:00:37,530 or in a local mission, so that we can get those data source credentials, details of my Escorial into 7 00:00:37,530 --> 00:00:39,730 a springboard application configuration. 8 00:00:40,140 --> 00:00:49,710 So in this scenario, I choose to create a free time MySQL database since it is more than enough for 9 00:00:49,710 --> 00:00:50,630 an application. 10 00:00:50,730 --> 00:00:57,960 So I'll show you how to create a database in the eight years and how to configure the same into a springboard 11 00:00:57,960 --> 00:00:59,940 application as a database. 12 00:00:59,950 --> 00:01:04,200 So for the first go to the database Amazon.com. 13 00:01:04,590 --> 00:01:10,230 If you already have an account, try to go and click on a management console. 14 00:01:10,710 --> 00:01:12,540 If it asks credentials, please. 15 00:01:12,560 --> 00:01:18,870 In other words, if you don't have a code in eight years, you can always create an account. 16 00:01:19,320 --> 00:01:27,420 And I'm assuring you, whatever we do in this course is completely free and we never select a database 17 00:01:27,450 --> 00:01:29,700 which will charge some money to it. 18 00:01:30,990 --> 00:01:37,560 So I'm just going to my account and clicking mission management consultant here and entering my credentials 19 00:01:38,250 --> 00:01:44,190 posts that once you are on to the database management console, search for the ideal services, which 20 00:01:44,190 --> 00:01:46,910 is mainly relational database rich. 21 00:01:47,250 --> 00:01:50,280 So I can create a database here. 22 00:01:50,370 --> 00:01:55,830 I'll go with an option of easy create, since it's almost the fastest way of creating a database. 23 00:01:55,950 --> 00:02:03,720 And you'll also have an option of selecting the database server that you want to go with Oracle, Myskina 24 00:02:03,960 --> 00:02:05,160 or Postgres. 25 00:02:05,520 --> 00:02:12,510 But here in this scenario, I will select my school and here you have three instance, type one, this 26 00:02:12,510 --> 00:02:18,750 particular instance and the other one is which you can use fluid environments like devlopment, testing, 27 00:02:18,750 --> 00:02:19,410 environment. 28 00:02:19,770 --> 00:02:24,330 But for this course we should be good with the free to instance. 29 00:02:24,810 --> 00:02:31,110 Selecting that and database instance identifier is the name inside your alias. 30 00:02:31,800 --> 00:02:34,050 I'm just giving some database instance. 31 00:02:34,050 --> 00:02:34,870 Identify a name. 32 00:02:34,890 --> 00:02:42,750 You're free to do whatever name you want provided by master user name so you can have and use a new 33 00:02:42,750 --> 00:02:43,810 whatever you want. 34 00:02:43,980 --> 00:02:51,600 So in this scenario, I'm just giving you a name as admin followed by you have to provide your master 35 00:02:51,870 --> 00:03:00,060 username password and thus giving the password that I want for my admin username. 36 00:03:00,450 --> 00:03:06,600 Please make sure you are remembering these credentials because they are very important later on when 37 00:03:06,600 --> 00:03:15,270 we try to connect to the application or any ask you a client application post entering password details. 38 00:03:15,270 --> 00:03:19,500 I'm good with Waterview default settings provided by Alias. 39 00:03:19,830 --> 00:03:27,010 Once you verify everything you can click on create a database which will create a database in your NWS 40 00:03:27,030 --> 00:03:27,500 console. 41 00:03:27,750 --> 00:03:33,630 So now I have a database created which is of the name database to which I just know creator. 42 00:03:33,900 --> 00:03:40,800 Usually it will take 10 to 15 minutes to create a new database, but you can wait till it shows available 43 00:03:40,800 --> 00:03:45,350 and you keep on refreshing the same to see what is the latest status. 44 00:03:46,950 --> 00:03:54,570 Once your database is available, select the specific database and click on Modify, the reason that 45 00:03:54,570 --> 00:04:01,820 we want to modify is by default, your database will not be open to public network. 46 00:04:01,980 --> 00:04:08,370 So if we want to access this database through your code, which is present inside your computer, a 47 00:04:08,370 --> 00:04:15,870 laptop, you have to make sure whatever database that you have created is open to public access for 48 00:04:15,870 --> 00:04:16,350 the same. 49 00:04:16,740 --> 00:04:24,310 Just scroll down to down where you can see additional connectivity configuration here. 50 00:04:24,780 --> 00:04:27,330 I have already changed the public accessible. 51 00:04:27,540 --> 00:04:28,740 That's why it is there. 52 00:04:29,100 --> 00:04:37,050 But for you, if you are doing this for the first time by default, the option not publicly accessible 53 00:04:37,080 --> 00:04:41,520 is selected and you have to change it to publicly accessible. 54 00:04:41,730 --> 00:04:44,610 And you also have an option of changing the portal. 55 00:04:44,970 --> 00:04:51,850 But for now, just keep only publicly accessible and let the board member with the phone number. 56 00:04:51,880 --> 00:04:59,520 Whatever minuscule it has with this, if you click on sale changes, you have an option of to apply 57 00:04:59,520 --> 00:05:03,650 the changes immediately, which will restart your server. 58 00:05:03,840 --> 00:05:07,560 Otherwise you can wait till the next scheduled maintenance window. 59 00:05:07,780 --> 00:05:12,690 But in this scenario, I just wanted to have immediately changes. 60 00:05:13,110 --> 00:05:19,190 But here, since there are no modifications done by me, the modified B B instances disable. 61 00:05:19,440 --> 00:05:26,550 But you are free to go and apply this modified Beeby instance, which will bring you a server down for 62 00:05:26,550 --> 00:05:27,780 five to 10 minutes. 63 00:05:27,960 --> 00:05:32,510 And you can always see the status by going to the database as a dashboard. 64 00:05:32,670 --> 00:05:36,430 And once the system is available, you are free to use it. 65 00:05:36,480 --> 00:05:44,040 Now we have successfully created a database and we made configurations such a way that it can be accessed 66 00:05:44,040 --> 00:05:49,130 publicly by anyone who knows the credentials and connection database. 67 00:05:49,410 --> 00:05:55,770 For this, I will show you what the connection details if you click on this database to it will show 68 00:05:55,770 --> 00:06:02,700 you the end point, which is the host name and phone number and credentials will be whatever you have 69 00:06:02,700 --> 00:06:06,200 created using master username. 70 00:06:06,570 --> 00:06:15,000 So to connect to this database, I will go ahead and download my client application, which is a skill 71 00:06:15,060 --> 00:06:16,730 upon GitHub that I will. 72 00:06:16,950 --> 00:06:24,930 From there you can go and download a secure electronic application by clicking on download UI and as 73 00:06:24,930 --> 00:06:30,060 part of your operating system you can search for the dump and download it. 74 00:06:30,240 --> 00:06:33,690 For me, it's a Windows operating system. 75 00:06:34,110 --> 00:06:39,510 How to download the ones I have downloaded this how that application looks. 76 00:06:40,050 --> 00:06:42,850 I have to create a connection there. 77 00:06:42,870 --> 00:06:45,000 By clicking here. 78 00:06:45,180 --> 00:06:50,790 It will ask me what is our database name that you want to give for your preference? 79 00:06:51,120 --> 00:06:53,910 I will just say easy bang. 80 00:06:54,270 --> 00:07:00,630 My school database is the connection name that I want to create and database is minuscule. 81 00:07:00,930 --> 00:07:09,480 And whose name is the one that you can copy from Alias, which is this endpoint you are on board. 82 00:07:09,510 --> 00:07:16,770 Name is a different one and username is the one I have created with this admin and password, whatever 83 00:07:16,950 --> 00:07:18,020 I have created. 84 00:07:18,450 --> 00:07:25,710 Once you enter the credentials click contest, if the database is open to public and the credentials, 85 00:07:25,710 --> 00:07:26,760 everything is correct. 86 00:07:26,760 --> 00:07:30,990 It will show you successfully connected post that you can see this connection. 87 00:07:31,320 --> 00:07:35,160 Now, I will try to connect to that database here. 88 00:07:35,370 --> 00:07:42,210 And you can see right now this is a brand new database and we don't have any details inside it. 89 00:07:42,570 --> 00:07:50,460 With this, we successfully created a database in the cloud and connected through sample MySQL client 90 00:07:50,460 --> 00:07:52,970 application, which is a secure electron. 91 00:07:53,370 --> 00:07:58,320 In the next few videos will connect this database to a springboard application. 92 00:07:58,530 --> 00:08:03,750 Along with that, we also create the tables user details in this database. 93 00:08:04,050 --> 00:08:04,620 Thank you. 94 00:08:04,770 --> 00:08:06,900 And see you in the next room by.