welcome back to the mengare it channel this time we will make a tutorial on how to create a mysql database on xampp okay before continuing to create a mysql database don't forget to continue to follow the mengare it channel and don't forget to click the subscribe button and ring the bell for the latest tutorial on the mengare it channel okay, if you want to create a MySQL database on Xampp , first you have to download the application, namely Xampp. You can download the Xampp application on the official website, namely Apachefriends.org. Here you can download Xampp according to the version you want , it's for Windows, Linux and OS. the others for the download link for xampp are in the video description, okay, we just open xampp , then we start apache and mysql, okay, after we start apache and mysql , then we open the browser here, I use mozilla firefox , we type localhost/xampp na, after that we select the parent directory okay this is the xampp la page view lu after that we select phpmyadmin in the top right corner if you are used to it you just have to type localhost/phpmyadmin then it will immediately appear on a page like this phpmyadmin na here is an example of the database that I made okay now we create the database na here above there is a button new we click, to create a new database there is create database, for the database name, you can fill in there then there is a collection and create, for the database name here I will give an example of creating a student database for student databases okay let's create, we'll create the database is complete created na then after that it will immediately appear to create a display table to create a table na here we will create a table with the student table name for the number of columns, for the columns we use 5, not many 5 columns because this is just an example na after that we fill in the fields for the student table, the first one is usually for maha student, student name or student identification number then the name of the student study program or department then we fill in the class, this is the incoming class then the address is okay here the type for nim we just use varchar for the length is twenty for the name of the student, study program and class we use varchar all here the length it 's different, yes, for nim, we use twenty, for the name thirty na, for the product, twenty five length here is used for the length of the number of characters that we will enter, so adjust here according to what you made , then we go to index na index here it is used to create primary keys, unique, indexes and others. Here, let's make a primary key so that later the names are not the same , so the data that we input later cannot be the same, if they are the same, the data will not be saved , okay, after that we save, we wait.. Now the table has been created , we click on the student table, then here in the browser it is empty because we haven't entered the data yet , then we select structure to see in the table view there is a name, name, study program, class and address it looks like this then we try to insert the data na here we fill in the name 121011046 for the student name we use my name for the study program it is the same, informatics engineering that I am engaged in for class of 2010, and for the address is mengare bungah gresik okay, we save na, the data has been added successfully, we check in browes na here then the data that we entered will appear okay that's all for the tutorial for creating a mysql database on xampp more or less I'm sorry okay I hope this is useful and see you soon at next tutorials