Hey folks, are you looking for xampp tutorial for "How to download xampp for windows" & "how to install xampp and create database by using xampp" - If yes, then you have come to the right place!! Here, you will find step-by-step guide to download xampp on windows and also learn "how to create database on xampp".
So, let's start with its introduction;
What is Xampp?
Xampp is a free and open source cross-platform which consists bundles of web server packages including interpreter scripts, Apache HTTP Server and MariaDB database. It was initially launched in 2002 by Apache Friends. Xampp is GNU General Public License software which is written in PHP and Perl Programming Language. In simple words, Xampp is a kind of free server manager that allows to run apache, mqSQL, tomcat, fileZilla FTP and mercury mail servers on the same platform.
How to download xampp for windows
You can easily download and install xampp on your Windows by following the step by step guide which is as follows;
• Open Xampp Official website
First, open the search box and type "download xampp" in it. After that you will see xampp by apache friends in the search result. You simply have to open that link - Download xampp for windows.
As soon as you open it, you will land on xampp official downloading page.
• Click on download " Xampp for windows".
After opening xampp's official downloading page, you will get to see many versions of xampp, select the version of xampp according to your need. Here, Click on "download" Xampp for windows button to continue downloading.
Note : xampp is not supported in Windows XP or 2003.
• Allow app to make changes
After downloading the xampp .exe file, go to the downloads section and extract the xampp file and then open it.
• Setup Xampp
After opening the xampp .exe file, you have to setup it on your Windows PC
- Click on "NEXT'' button which is shown in setup window.
• Select Xampp components
Now select the components that you want to install inside xampp app. You will get the list of xampp attributes in the left side of the computer screen, in which you have to select attributes according to the requirements of your work. You can ignore the remaining attributes or you can also continue with its default settings. After selecting xampp attributes, simply tap on "NEXT" to continue.
• Select installation folder
After selecting xampp attributes, you have to select the path where your xampp will be installed. Browse the path and click on "NEXT" button to continue.
• Select language
In this section you have to select the most preferred language. After selecting language , click on "NEXT" to continue.
• Ready to install xampp
Huraahhh!! Your xampp .exe file is ready to install. Click on "Next" to continue installation of xampp app.
After clicking on next button, it will take few minutes for unpacking xampp files.
After few minutes, your xampp app has installed on your pc. Now click on "Finish" button for finishing xampp setup.
How to create MySQL database (with tables) by using Xampp
You can easily create MySQL database by using Xampp with the help of following steps;
• Open Xampp
Make sure that xampp is properly installed on your windows OS and then open Xampp.
• Start Apache & MySQL modules
Now open the xampp control panel and run "Apache server" and "MySQL". Wait for a while until for module debugging on your system.
• Run localhost on browser
Open your system browser (like Chrome, Mozilla, firefox or Opera) and type "localhost". After typing localhost on your browser you'll land on apache friends page. Now here search "MyPhpAdmin" and click on it.
• Create database
After clicking on MyPhpAdmin button, you have to Create new database on MyPhpAdmin panel. Its very simple process, Firstly search "NEW" button in left side on your computer screen. Then press it after that you'll see Creating database option on your screen.
Enter the database name and hit the "Create" button to continue.
• Add no. of tables & columns
After that, give a table name and choose the number of columns (as per your need) then click on "GO" button to continue.
• Insert datatype & length value
Now, customise your table by adding datatype and length value. After choosing these, drag page down and click on "SAVE" button to continue.
After that, click on "STRUCTURE" and recheck your table datatypes and length values.
• Insert table value
Now Insert the value in the table, Click on "INSERT" button to add table values. For eg. Name, roll no., Address and E-mail id. After inserting these values click on "GO" to Save table values.
• Browse the database
It's all done!!! You have created MySQL database using Xampp. Now click on "BROWSE" button for the live preview of your table.
Conclusion
Above we have discussed about Xampp tutorial for "How to download xampp for windows" & "how to install xampp and create database by using xampp". Through this article you have learnt about How to download xampp for windows and How to create MySQL database (with tables) by using Xampp. Xampp is a free and open source cross-platform which consists bundles of web server packages including interpreter scripts, Apache HTTP Server and MariaDB database. It was initially launched in 2002 by Apache Friends. You can easily download and install xampp on your Windows by following the step by step guide which is mentioned above. And You can easily create MySQL database by using Xampp with the help of above mentioned step to step guide. I hope this information will be helpful to you all.