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.

12XAMPP AND MARIADB
Step 4: The License Agreement dialogue box appear. Select the ‘I accept the terms in the
License Agreement’ and click on Next button.
Step 5: In Custom Setup clicked the next button.

13XAMPP AND MARIADB
Step 6: For the Database Security or Authentication password is set for the “root” database.
Step 7: In Other properties of Database all the check box is selected and click on the next
botton.

14XAMPP AND MARIADB
Step 8: The MariaDB is then ready to install. The Install button is clicked to install MariaDb.
Step 9: A popup appear for User Account Control (UAC) to enable. In it the Yes button is
clicked.

15XAMPP AND MARIADB

16XAMPP AND MARIADB
Step 10: The Finish button is clicked and the setup is ready for MariaDB.
3. Capabilities of MariaDB
The developers using MySQL can now migrate to MariaDB for the following reason:
1. The development of MariaDB is more open and vibrant.
2. Security releases are quicker and more transparent
3. The features that it has are more cutting edge
4. Storage engine are more
5. Performance are better
6. Galera provide master-master replication
7. Stewardship of oracle is uncertain
8. Popularity has leapt in MariaDB

17XAMPP AND MARIADB
9. Migrating to MariaDB is easy and Compatible
10. After 2015 migration become difficult
4. Approach to conceptual or logical model of the database structure in MariaDB
The commonly approach to conceptual model is the entity-relationship model. Depending
on the requirement and the complexity of the data structure DBMS is chosen. For the logical and
physical design, an attributes need to be added to create a relationship of the entities and the
primary keys. There is no problem in selecting MaraiDB as DBMS. A simple approach can be
made in creating a MariaDB tables. A simple database that will be created using the MariaDb is
as follow:
CREATE DATABASE my_details;
CREATE TABLE profile (
Id INT NOT NULL,
first_name VARCHAR(30),
last_name VARCHAR(40),
address VARCHAR(80),
postal_code VARCHAR(6),
email_id VARCHAR(254),
PRIMARY KEY(Id));

18XAMPP AND MARIADB
5. Bibliography
Friends, A. (2017). XAMPP Apache+ MariaDB+ PHP+ Perl. Haettu osoitteesta https://www.
apachefriends. org/index.html (15.5. 2016).
Installing MariaDB MSI Packages on Windows. (2018). Retrieved from
https://mariadb.com/kb/en/library/installing-mariadb-msi-packages-on-windows/