XAMPP and MariaDB: Installation, Capabilities, and Database Structure

This assignment provides a detailed guide on installing XAMPP and MariaDB, beginning with step-by-step instructions for installing XAMPP to open MySQL, followed by a comprehensive walkthrough of installing the MariaDB MSI package, also to open MySQL. It highlights the capabilities of MariaDB, emphasizing its open development, quicker security releases, cutting-edge features, diverse storage engines, improved performance, master-master replication via Galera, and ease of migration from MySQL. The document concludes with an approach to conceptual or logical database modeling in MariaDB, utilizing the entity-relationship model and providing a simple example of creating a database and table using MariaDB syntax. This resource offers valuable insights for developers looking to set up and utilize MariaDB for database management.

Running head: XAMPP AND MARIADB
Xampp and Mariadb
Name of student
Name of University
Author’s Note

1XAMPP AND MARIADB
Table of Contents
1. Installation of Xampp to open Mysql.......................................................................................2
2. Installation of MariaDB MSI Package to open Mysql.............................................................9
3. Capabilities of MariaDB........................................................................................................15
4. Approach to conceptual or logical model of the database structure in MariaDB..................16
5. Bibliography...........................................................................................................................17

2XAMPP AND MARIADB
1. Installation of Xampp to open Mysql
Step 1: The link https://www.apachefriends.org/index.html is open on the web browser.
Step 2: The XAMPP for Windows option is selected for download.
Step 3: Double-click on ‘xampp-win32-7.2.7-0-VC15-installer’

3XAMPP AND MARIADB
Step 4: The OK button is clicked.
Step 5: The Xampp Setup dialogue box appear. Clicked on the ‘Next’ button.
Step 6: Clicked on the ‘Next’ button.

4XAMPP AND MARIADB
Step 7: The installation folder location is selected and clicked on the ‘Next’ button.
Step 8: Clicked the ‘Next’ button.

5XAMPP AND MARIADB
Step 9: Clicked the ‘Next’ button.
Step 10: Installation is processing.

6XAMPP AND MARIADB
Step 11: Clicked on the Finish button.
Step 12: Selected the Language option Clicked on ‘Save’.
Step 13: ‘Start’ option is selected for MySql.

7XAMPP AND MARIADB
Step 14: ‘Start’ option is selected for Apache
Step 15: Both Apache and MySQL is running on XAMPP.

8XAMPP AND MARIADB
Step 16: On the web browser ‘localhost’ is search to open the Xampp.
Step 17: The ‘MySQL’ dashboard’ is open.

9XAMPP AND MARIADB

10XAMPP AND MARIADB
Step 18: The new database will be created by click on the ‘New’ option.
2. Installation of MariaDB MSI Package to open Mysql
Step 1: MariaDB website need to open from the link https://downloads.mariadb.org/ in the
web browser. Then had clicked on the green box shown in figure.

11XAMPP AND MARIADB
Step 2: The link that open https://downloads.mariadb.org/mariadb/10.3.8/ from it, MSI
Package for Win 64 is selected.
Step 3: The MaraiDB 5.2 (x64) set up dialogue box appear. Then clicked on next.