How To Install MariaDB On Ubuntu
MariaDB is a popular, open-source relational database management system that is a fork of MySQL. It is highly performant, secure, and compatible with most MySQL tools. In this guide, we will walk you through How To Install MariaDB On Ubuntu step by step.
Steps To Install MariaDB On Ubuntu
1. Update Your System
Before installing MariaDB, make sure your system packages are up to date:
sudo apt update && sudo apt upgrade -y
Updating the system ensures that you have the latest package versions and security patches.
2. Install MariaDB
MariaDB is available from the official Ubuntu repositories, making the installation process straightforward.
Step 1: Install MariaDB Server
To install MariaDB, run the following command:
sudo apt install mariadb-server mariadb-client -y
Step 2: Verify Installation
After the installation completes, check the MariaDB version to ensure it was installed correctly:
mariadb --version
You should see an output similar to:
mariadb Ver 15.1 Distrib 10.6.7-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
3. Start and Enable MariaDB Service
MariaDB should start automatically after installation. To verify its status, use:
sudo systemctl status mariadb
If it’s not running, start the service manually:
sudo systemctl start mariadb
To ensure MariaDB starts on boot, enable it with:
sudo systemctl enable mariadb
4. Secure MariaDB Installation
MariaDB comes with a built-in security script that helps you remove insecure defaults:
sudo mysql_secure_installation
Follow the prompts:
- Set a root password.
- Remove anonymous users.
- Disallow root login remotely.
- Remove test databases.
- Reload privilege tables.
Testing Root Access
After securing the installation, log in to the MariaDB shell to test root access:
sudo mariadb -u root -p
Enter your root password when prompted. You should see the MariaDB command prompt:
Welcome to the MariaDB monitor. Commands end with ; or \g.
MariaDB [(none)]>
MariaDB is a robust, flexible, and highly compatible database solution that can easily replace MySQL in most applications. By following this guide, you have successfully installed and configured MariaDB on Ubuntu, secured the installation, and tested basic database operations.
Follow us for the more helpful posts!
We hope this is a useful post for you.
You can read more useful posts like How To Configure PHP-FPM With Nginx.
Thank you for reading!
