MySQL database in phpMyAdmin

Photo by Caspar Camille Rubin on Unsplash

Whenever we think of backend, the ‘database’ is the first word that strikes our mind. It acts as a key component in almost all domains. The main aspects of having a database are storing and retrieving data. So here we are going to create a MySQL database and then retrieve the necessary data using SQL queries in phpMyAdmin.

So to get started with creating a database turn on the Apache and MySQL modules from the XAMPP control panel. if you are unfamiliar with the XAMPP server then don’t worry, go through “Temporary Web-Hosting using XAMPP and ngrok”.

Starting Apache and MySQL modules

Now, as our XAMPP server has been started successfully, follow the steps given below to proceed further.

Creating a new MySQL database in phpMyAdmin:

Step-1: Open ‘localhost’ on your browser.

Localhost Dashboard

Step-2: Open ‘phpMyAdmin’ from the navbar of localhost dashboard.

phpMyAdmin is a free and open-source MySQL administration tool. It provides both the features of…