How to Install the XAMPP Server for PHP and MySQL

Learn how to install the XAMPP Server for PHP and MySQL backend web development projects with this tutorial. XAMPP is the most popular PHP development environment The install includes PHP and MySQL (MariaDB).

(0:00) Intro
(0:35) Download XAMPP
(1:16) A quick note about installing XAMPP on Windows
(1:40) Launching the XAMPP Control Panel
(2:00) Start Apache Web Server and MySQL
(2:20) Apache Admin: PHP Info to verify PHP install version
(3:05) phpMyAdmin to view MySQL database GUI
(3:24) Compare MariaDB vs MySQL differences
(4:17) Confirm Apache with PHP and MySQL with MariaDB are running
(4:40) Downloading a dataset for the database
(5:10) Extracting the world dataset
(5:34) Opening the XAMPP Shell
(6:00) Importing the world dataset into MySQL using the CLI
(6:50) Confirming the MySQL import of the world dataset
(7:30) Querying the world database in the MySQL GUI

✅ Follow Me:

Was this tutorial about how to install the XAMPP Server for PHP and MySQL helpful? If so, please share. Let me know your thoughts in the comments.

#xampp #php #mysql

[DaveGrayTeachesCode]

If you are starting to learn back-end web development, XAMPP is a great tool that will install a PHP dev environment and a MySQL environment with MariaDB. I also walk you through downloading a dataset for MySQL and how to import the data with the shell CLI. By the end of the tutorial, you will have a local server up and running.

[thebilalafsar]

Hey Dave! I've been following you for the last few months and finished your HTML, CSS, and JS playlist. I want to learn PHP, but the tutorials seem outdated since they were built three years ago. Can you update your PHP & MySQL playlist? Thanks!

[CelestialsBnK]

Yet another great tutorial.. setup went like a charm, no hick-ups.. and, voice and speed makes tutorial very pedagogic.. thx!

[frvCars]

Hi Dave,
I had an issue with the command cd ./world.sql but after struggling a little... I realized that the folder name had changed since you made the video.
The command should be cd ./world-db
Anyway, I really enjoyed following this video and XAMPP is now installed on my computer!😃
thanx a lot 👍👍👍

[ahmad-murery]

Some good contents on the way,
I knew it when I first saw the title.
Excited already

[asapkode]

Thanks Dave! Psyched for the PHP tuts!

[HafizRahmanBD]

Hi Dave, do you have any plans for updating your PHP and MySQL course on YouTube or elsewhere? And if so then please let us know the probable time frame. Thank you.

[marcindomanski]

I uses xampp for years. This is very nice app. Some time ago i hear about Laragon. I install and I loved it. You may try it for yourself.

[blxvrks]

I got some problem on xampp, the shell doesn't work properly it's open and close quickly.
I try to reinstall everything, but it still at the same way someone have any clue to fix it?

[drowningpool]

What extensions are you using on google??

[hellokevin_]

Hey Dave, happy new year. I'm an aspiring Web developer and have an understanding of Html, css, Javascript & React, is it a wise choice to learn php and laravel for transitioning into fullstack or I'm better off learning node/python ? Thanks.

[DucMinhTeaching]

could you please make a video about server sent event with PHP? Thank you.

[greatoutdoors]

This is probably a stupid question but should I just leave it (apache and MySQL) running all the time in the background? Does it matter?

[jannahilario]

Why my MYSQL not starting? It just say attempting to start :(

[riponroy]

Want wordpress theme & plugin development project

[immidesign]

ERROR 1045 (28000): Plugin caching_sha2_password could not be loaded: The specified module could not be found. Library path is 'caching_sha2_password.dll' what can I do