hello guys welcome to amit things in this video we will see how we can create a new database on xampp so installed xampp you can see the control panel here so to work with database you need to start the mysql here by clicking start we did it on the xampp control panel to reach xampp control panel go to start type xampp control panel after installing exam here you can see we just clicked on open and the same is visible here we started the server and mysql database now to create a new database go to browser type localhost first press enter you can see on typing localhost pse admin is visible click on it you can straight away click on localhost phm admin here you can see to open phm admin so here in you can see all the databases are visible the default databases on phpmyadmin visible here we want to create a new database so what we'll do guys we will just click on new now add the database name i'll mention let's say the database name is amid db click on create on clicking create you can see ami db database is visible when you click on it nothing will be visible because we haven't added any table or column right now so you can create a new table let's say employee table columns let's say we want three and go this will create a new table we can add fields here let's say i'll add emp id type i'll keep it as int only length values keep the default herein you can add constraints if you want i'll keep it as give it as primary key next let's keep it as employee name emp name i'll give it as text rest keep as it is it's fine next i'll add emph this will be in end only init only that's it rest keep the same and i'll just click on save here here you can see we created our first table employee with the with the columns employee id employee name age here it is you can change it from here you can drop it from here and and when i'll go to amid db you can see we have our employee table here click on it you can see you can edit it from here by clicking edit so guys so now we have a ram db database if you want to export the database click on export here it is you can straight away select the format and let's say my format i want to export is sql i'll i'll select sql here and click on go on clicking go it will download ami db.sql this is our database if you want to import a new database you can select the file from here the file format should be in sql and in compressed form the same is visible here you need to compress your database first and you need to just import it here by clicking choose file after that you need to just click on go here so guys in this video we saw how we can create a new database in xampp if you like the video do subscribe to our channel and make things