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.
Subscribe to receive weekly cutting edge tips, strategies, and news you need to grow your web business.
No charge. Unsubscribe anytime.
Did you find this article helpful? Then you'll love our support. Experience the A2 Hosting difference today and get a pre-secured, pre-optimized website. Check out our web hosting plans today.