How to Install MariaDB on Ubuntu 20.04

MariaDB is a community-developed, open-source fork of the popular MySQL relational database management system. It is designed to be a drop-in replacement for MySQL and offers enhanced performance, scalability, and security features.

Step 1: Update System Packages

Before installing MariaDB, it is recommended to update the system packages to their latest versions. Open a terminal and run the following command:

Step 2: Install MariaDB

To install MariaDB on Ubuntu 20.04, execute the following command in the terminal:

This will install the MariaDB server along with the necessary dependencies.

Step 3: Secure MariaDB Installation

After the installation is complete, run the security script to set up the MariaDB root password and other security-related options:

Follow the prompts to set a strong password, remove anonymous users, disallow root login remotely, remove the test database, and reload the privilege tables.

Step 4: Start and Enable MariaDB

Once the installation process is finished, start the MariaDB service and enable it to automatically start at boot time:

You can verify the status of the service by running:

Step 5: Accessing MariaDB

To access the MariaDB command-line interface, run the following command:

You can now start interacting with the MariaDB server through its command prompt. To exit the MariaDB console, type "exit" and press Enter.

Conclusion

Congratulations! You have successfully installed MariaDB on Ubuntu 20.04. You can now use it to store and manage your relational databases efficiently and securely.