This article describes how to create a MySQL installation that you can use for local testing.
A2 Hosting servers actually use MariaDB, an enhanced drop-in replacement for MySQL.
To install MariaDB on your virtual machine, follow these steps:
yum install mariadb-server
After installation completes, type the following command to start MariaDB:
systemctl start mariadb
To confirm MariaDB is running, type the following command:
systemctl status mariadb
You should see Active: active (running) in the output.
To make MariaDB start automatically on system boot, type the following command:
systemctl enable mariadb
To secure the installation, type the following command:
This program enables you to set the root MySQL password and other security-related settings.
To make sure the root password was set correctly, type the following command:
mysql -u root -p
Type the root password that you set in step 8, and then press Enter. You should see Welcome to the MariaDB monitor in the output.