1 00:00:00,210 --> 00:00:05,910 Hello, friend, welcome back in this video will start a new session, it's about how can create one 2 00:00:05,910 --> 00:00:08,910 good application with using MySQL database. 3 00:00:09,240 --> 00:00:14,490 Good applications means if you want to create or if you want to insert some of the data into the database, 4 00:00:14,490 --> 00:00:19,590 if you want to read these data from the database, if you want to update these data or if you want to 5 00:00:19,590 --> 00:00:22,320 delete this data from the database, how can do that? 6 00:00:22,320 --> 00:00:23,520 Work is step by step. 7 00:00:23,520 --> 00:00:28,770 I will show you that things with the live example suffering before I have already discussed about that 8 00:00:28,770 --> 00:00:29,550 things with you. 9 00:00:29,550 --> 00:00:33,570 We have used some of the Django, one of that building database. 10 00:00:33,810 --> 00:00:36,630 So we have use of the Django building database. 11 00:00:36,630 --> 00:00:38,220 That is the name as is collate. 12 00:00:38,550 --> 00:00:43,410 So as I told you, this is Goliath is not much a professional of the database right now. 13 00:00:43,410 --> 00:00:45,810 We will work some of the professional database. 14 00:00:46,110 --> 00:00:50,310 So for the professional database, I want to do want to use that our my skill. 15 00:00:50,640 --> 00:00:54,550 So if you want to use that MySQL, first of all, you have to do you have to install that. 16 00:00:55,230 --> 00:00:57,300 And Jambi is one of the local server. 17 00:00:57,300 --> 00:00:59,150 You have to do you have to download it. 18 00:00:59,160 --> 00:01:04,290 OK, so that if you it in Google then it will get a lot of the resources for downloading. 19 00:01:04,290 --> 00:01:05,700 This is totally free. 20 00:01:05,700 --> 00:01:11,670 One of the software you have to do, you have to download it and install it in your system and after 21 00:01:11,670 --> 00:01:14,610 you install it, you can get this tape up one of the popup. 22 00:01:14,610 --> 00:01:17,940 So first of all, here you have to do you have to run your apogee. 23 00:01:18,390 --> 00:01:21,690 So here you have to ram this Apache and the reaction of the MySQL. 24 00:01:22,020 --> 00:01:23,970 So that's all we also needed for the reasons. 25 00:01:24,000 --> 00:01:25,830 First of all, you have to run two of these. 26 00:01:25,950 --> 00:01:32,810 And when you successfully installed the Jambi in your system after installing that, if you don't down 27 00:01:32,910 --> 00:01:33,780 the localhost. 28 00:01:36,190 --> 00:01:41,200 Then you can see that is actually all localhost and under the localhost, you can find out everything. 29 00:01:41,210 --> 00:01:43,140 So if you go to your you version. 30 00:01:43,150 --> 00:01:46,810 So right now I'm using that BHP version, seven point three point seven. 31 00:01:46,900 --> 00:01:49,990 And also, if you want to find out that escrow server. 32 00:01:49,990 --> 00:01:52,560 So his name is as a PSP myat been. 33 00:01:52,870 --> 00:01:55,330 So you have to click on here and here. 34 00:01:55,330 --> 00:02:01,870 You can see that is actually the MySQL server database area and there is all that database server version. 35 00:02:01,890 --> 00:02:03,270 So here I am right now. 36 00:02:03,280 --> 00:02:05,590 I'm using the server version, ten point four. 37 00:02:05,590 --> 00:02:09,070 Make sure you updated your databases, Crossharbour. 38 00:02:09,280 --> 00:02:12,870 And also I'm using the space version, seven point three point seven. 39 00:02:13,210 --> 00:02:18,790 So we will create one of the code application with this advance of the provisional database software. 40 00:02:18,790 --> 00:02:20,170 So that is actually the issue. 41 00:02:20,170 --> 00:02:23,530 I have been so right now I want to work in particular that area. 42 00:02:23,680 --> 00:02:28,600 So if you want to use that MySQL, first of all, you have to do you have to add one of the packets. 43 00:02:29,080 --> 00:02:31,960 So in general, we have to add of the package right now. 44 00:02:31,960 --> 00:02:37,020 I just stream will be open the terminal again, and that is our project. 45 00:02:37,450 --> 00:02:37,700 Right. 46 00:02:37,970 --> 00:02:41,930 So this project, first of all, I want to do is still on the package. 47 00:02:42,040 --> 00:02:44,570 So for the MySQL, they have also on the package. 48 00:02:44,590 --> 00:02:52,510 So if you want to install it, you have to write down as a B and the uninstall and then the MySQL client. 49 00:02:54,520 --> 00:02:59,390 OK, so that is actually the one document as a P install and MySQL client. 50 00:02:59,440 --> 00:03:03,220 So first of all, we have to do we have to install it so not to enter. 51 00:03:06,720 --> 00:03:11,590 And now here you can see, friend, you snowshoeing as a requirement, already satisfied. 52 00:03:11,940 --> 00:03:17,520 That means I have already installed in our system so far the results is not showing as a requirement, 53 00:03:17,520 --> 00:03:18,560 already satisfied. 54 00:03:18,810 --> 00:03:22,380 But if you install it not the first time, it may take a little time. 55 00:03:22,380 --> 00:03:27,510 You will be downloaded all that file from the Internet, then automatically it will be installed the 56 00:03:27,630 --> 00:03:29,370 total package in your system. 57 00:03:29,400 --> 00:03:29,650 OK. 58 00:03:29,670 --> 00:03:32,450 So right now I have already installed it for the reason system. 59 00:03:32,490 --> 00:03:35,440 Legal system showing as a requirement, already satisfied. 60 00:03:35,550 --> 00:03:40,980 So make that you're going to install this by being installed with the MySQL package, then make sure 61 00:03:40,980 --> 00:03:45,330 you are connected to the Internet because it will be downloaded all that file from the Internet. 62 00:03:45,690 --> 00:03:48,160 Now we have to do we have to configure it. 63 00:03:48,180 --> 00:03:51,230 So if you want to configure it, you have to go to your my project. 64 00:03:51,240 --> 00:03:53,590 That means my Fuseproject area. 65 00:03:53,610 --> 00:03:57,690 So I just simply open it seems to this my first project that have the setting, DCPI. 66 00:03:57,720 --> 00:04:06,300 So now go to that setting the by and now here, if you will, get on the database like here, if you 67 00:04:06,550 --> 00:04:09,320 a little bit go here, you can see that the database area. 68 00:04:09,600 --> 00:04:12,440 So by default within installed that can go by default. 69 00:04:12,450 --> 00:04:17,030 We use that is I tried as I told you before, so by default that was actually escalate. 70 00:04:17,040 --> 00:04:18,620 So now I want to change it. 71 00:04:18,900 --> 00:04:23,520 So if you want to change it also to have the database, one of the commandos, so they have some of 72 00:04:23,520 --> 00:04:30,300 the link, if you copy it, I just simply copy it and now go here and open it. 73 00:04:31,080 --> 00:04:35,540 And now here you can see that Django project and they have all the investigation. 74 00:04:35,820 --> 00:04:41,610 So by default, that was actually that this one that was the database default engine at a skylight and 75 00:04:41,610 --> 00:04:44,700 no one to do and to change it without my school. 76 00:04:44,820 --> 00:04:48,120 So if you want to use that MySQL, then you have to do we have to copy it. 77 00:04:48,690 --> 00:04:52,740 So I just simply copy everything from here, OK? 78 00:04:52,770 --> 00:04:54,240 I just simply copy everything. 79 00:04:54,240 --> 00:04:57,620 Before that was actually like that we sat down to do and update it. 80 00:04:58,050 --> 00:05:01,230 So no, I just simply copy and now go to our site. 81 00:05:01,560 --> 00:05:03,390 That means in our setting fire here. 82 00:05:03,390 --> 00:05:05,510 I want to do I want to update it. 83 00:05:05,580 --> 00:05:07,270 I just simply based our new one. 84 00:05:07,590 --> 00:05:09,920 So right now we will use our MySQL. 85 00:05:10,320 --> 00:05:15,090 So for the MySQL configuration, we have to defining it as a database default engine. 86 00:05:15,090 --> 00:05:21,180 And here we have to define our database, name, database, user name, database password, horse name 87 00:05:21,180 --> 00:05:22,080 and the name. 88 00:05:22,530 --> 00:05:25,930 And here now I will use my scale for the reasons here we have to do. 89 00:05:25,930 --> 00:05:26,910 We have to change it. 90 00:05:26,910 --> 00:05:30,900 So here after the backings, I just want to change it as a MySQL. 91 00:05:31,260 --> 00:05:34,890 I name it as a my skill, OK, I just name it as my skill. 92 00:05:35,340 --> 00:05:40,170 And now we have to do we have to create one of the database and we have to also define database, username 93 00:05:40,170 --> 00:05:41,040 and password. 94 00:05:41,430 --> 00:05:47,670 So for creating the database, as I told you, we have to do we have to go to our place, my admin localhost 95 00:05:47,670 --> 00:05:48,150 right now. 96 00:05:48,150 --> 00:05:49,410 I'm using that Sam. 97 00:05:49,590 --> 00:05:53,060 And here I have already opened our aperture and the MySQL. 98 00:05:53,130 --> 00:05:53,460 Right. 99 00:05:53,880 --> 00:05:54,750 So now that is two. 100 00:05:54,870 --> 00:05:55,830 This is it started. 101 00:05:56,170 --> 00:06:01,350 So now if you want to create a new database into my piece, you I mean, you have to do we have to go 102 00:06:01,350 --> 00:06:04,230 to that database and into the database here. 103 00:06:04,230 --> 00:06:06,390 I want to do and create one of the new database. 104 00:06:06,540 --> 00:06:10,860 So I just name it as if my underscore whatever he wants right now. 105 00:06:10,860 --> 00:06:16,010 I'm actually using that my fast my fast under is called Django. 106 00:06:17,430 --> 00:06:22,110 So this type of one of the database name, I want to create software that you have to do. 107 00:06:22,110 --> 00:06:24,150 You have to just simply click as a create. 108 00:06:25,320 --> 00:06:28,210 Now you can see our database is now successfully created. 109 00:06:28,500 --> 00:06:33,990 So now if you have to, do we have to copy your database name so that your database name and now go 110 00:06:33,990 --> 00:06:36,630 to our configuration and that is our database name. 111 00:06:36,660 --> 00:06:40,720 You have to define on particular that position either simply defining it. 112 00:06:40,740 --> 00:06:43,850 OK, so that will be our database name. 113 00:06:43,860 --> 00:06:47,920 And also we have to put our database username and password. 114 00:06:48,300 --> 00:06:51,780 So for right now, I'm using that Zamp and for the Zamp. 115 00:06:51,780 --> 00:06:58,650 If you go your main homepage and if you go to that user account and into the user account here you can 116 00:06:58,650 --> 00:07:01,490 see there is a user name by default at the root. 117 00:07:01,710 --> 00:07:07,290 OK, so user name by default as a rule in your localhost and hostname as a localhost. 118 00:07:07,290 --> 00:07:08,250 And the password. 119 00:07:08,280 --> 00:07:10,520 Right now I, I don't have any password. 120 00:07:10,890 --> 00:07:14,340 So for the reasons I just want to do, I just, just simply copied the fruit. 121 00:07:14,820 --> 00:07:17,920 That bizarre user name will be as a root and password. 122 00:07:17,950 --> 00:07:19,670 Right now I don't have any password. 123 00:07:19,680 --> 00:07:23,120 So for the reasons I just make the things as empty and the holes. 124 00:07:23,160 --> 00:07:25,410 You can also use it either then. 125 00:07:25,650 --> 00:07:29,460 Right now I want to do want to use this hostname as a localhost. 126 00:07:29,970 --> 00:07:33,810 I just simply copied and now here I just simply paste it. 127 00:07:35,530 --> 00:07:41,620 OK, so here I just simply define our hostname and also the port, if you open yourself into the Zamp 128 00:07:41,620 --> 00:07:44,680 here, consider the airport as a three three zero six. 129 00:07:44,800 --> 00:07:48,400 So I don't want to use it as a three three zero six. 130 00:07:48,790 --> 00:07:54,220 So that's all you have to do for configure your MySQL database with your general project. 131 00:07:54,520 --> 00:08:00,250 So in our next video, we have to do we have to migrate our all the table because I have already created 132 00:08:00,250 --> 00:08:06,310 some of the models right into the fast project I have already created to have this model as a musician 133 00:08:06,310 --> 00:08:07,120 and the album. 134 00:08:07,450 --> 00:08:10,990 So now we have to do we have to migrate it and we will migrated. 135 00:08:10,990 --> 00:08:15,060 Then automatically Django will create all the table in our database. 136 00:08:15,100 --> 00:08:20,100 That means here I have already created all the database, so that is the database I have defined. 137 00:08:20,590 --> 00:08:23,850 So that is actually my first Django Django. 138 00:08:23,860 --> 00:08:24,180 Right. 139 00:08:24,640 --> 00:08:26,710 So here automatically it will be created. 140 00:08:26,710 --> 00:08:28,250 All that data, that table. 141 00:08:28,300 --> 00:08:30,010 OK, so how can I get it? 142 00:08:30,010 --> 00:08:33,150 In our next video, I will show that things with a live example. 143 00:08:33,700 --> 00:08:36,850 So thanks for watching and I'll see you the next video.