Requirement Software for Learn MySQL Part 1

Here is a list of MySQL or MariaDB Server applications that can be installed for database learning on various operating systems:

1. XAMPP

XAMPP is a server application package that includes Apache, MySQL (or MariaDB in the latest version), PHP, and Perl. XAMPP is very popular for local web development because it is easy to use and provides everything needed to start learning databases.

XAMPP is compatible with various operating systems such as Windows, Linux, and MacOS. we can install and customize it according to the operating system we use.

Main Features:

  • Including MySQL or MariaDB for database management.
  • Providing an Apache server and PHP programming language, suitable for learning database-based web application development.
  • Cross-platform: can be installed on Windows, macOS, and Linux.

SELECT TO DOWANLOAD XAMPP

to install XAMPP, please access the site at https://www.apachefriends.org/download.html and then please select XAMPP with your Operating System version.

1. Please choose this for the Windows Operating System.

2. Choose this for the Linux Operating System

3. Choose this for the MacOS Operating System.

4. And choose this to run the XAMPP Web Browser version.

DOWNLOADING XAMPP

After determining the version of XAMPP to download, the next step is to click the Download button until a new page appears as shown in the image below.

Wait a moment until the Download Process appears.

and Save it to the Storage on your Computer or laptop. and wait until the download process is complete.

to see how to install XAMPP on your computer, please read the tutorial at this link
[ STEP BY STEP INSTALL XAMPP ]

2. LARAGON

Laragon is a lightweight and fast development package for Windows and is currently only compatible with the Windows operating system, designed to support various development stacks including MySQL and MariaDB.

Main Features:
  • Including MySQL and MariaDB for database management.
  • Able to manage multiple versions of PHP, MySQL, and Apache/Nginx simultaneously.
  • Supporting the installation and management of applications quickly.
  • Laragon has a third-party MySQL Editor. Visually, it uses HeidiSQL to simplify the creation and management of databases, tables, and data, as well as the processes of backup, export, and import of databases.

to obtain Laragon, please visit the website address https://laragon.org/download/ and next, there are two download options, namely Download Laragon – Full (173 MB) and Download Laragon – Portable (38 MB)

For the Laragon download process, please click on Download Laragon – Full (173 MB) or Download Laragon – Portable (38 MB) and then wait a moment until the Laragon download process appears.

For the Laragon Installation Process, please read the article here.
[STEP BY STEP INSTALL LARAGON]

AMPPS

AMPPS is a local web development tool that includes Apache, MySQL/MariaDB, PHP, Perl, Python, and over 400 open-source web applications that can be installed with one click. AMPPS is a great tool for learning databases and web development.

Main Features:
  • Including MySQL and MariaDB for database management.
  • Supporting the installation of web applications such as WordPress, Joomla, and others.
  • Cross-platform: available for Windows, macOS, and Linux.

to obtain AMPPS, please visit the website https://ampps.com/ and then click Download

for the guide to install AMPPS on Windows or other operating systems, please read the article here
[STEP BY STEP INSTALL AMPPS]

Besides that, there are still many web servers we can use, and my suggestion is to use only one type of web server on one computer. so that there are no port conflicts between web servers.

If you want to try another web server, it is better to disable or uninstall the installed web server and don’t forget to back up the data that has been created on that web server first, then try installing the desired web server.

Comments

No comments yet. Why don’t you start the discussion?

Leave a Reply

Your email address will not be published. Required fields are marked *