In this tutorial, I will show you how to install MariaDB on Ubuntu. you will learn how to install and start using MariaDB on Ubuntu. In this article, we will implement an installing MariaDB on Ubuntu. This article will give you a simple example of how to install MariaDB from the command line. follow the bellow steps for building MariaDB on Ubuntu.
In this tutorial, we will learn how to install and configure MariaDB on Ubuntu 22.04. MariaDB is an open-source relational database management system compatible with MySQL, created by some of MySQL’s originators as an alternative platform.
Step 1: Update System Dependencies
First of all, open the terminal and execute the following command on the command line to update system dependencies:
sudo apt update
sudo apt upgrade
Step 2: Install MariaDB
Then execute the following command on the command line to install MariaDB on the linux ubuntu system:
sudo apt install mariadb-server mariadb-client
Once the installation is completed, the MariaDB service will start automatically. To verify that the MariaDB server is running, type:
sudo service mariadb status
Step 3: Configure MariaDB
Use the following command to configure mariaDB:
Then prompt will be open; is as follow:
Setting the root password or using the unix_socket ensures that nobody
can log into the MariaDB root user without the proper authorization.
You already have your root account protected, so you can safely answer 'n'.
Switch to unix_socket authentication [Y/n]
On the next prompt, you will be asked to set a password for the MariaDB root user.
If you set up the validate password plugin, the script will show you the strength of your new password. Type y to confirm the password.
Next, you’ll be asked to remove the anonymous user, restrict root user access to the local machine, remove the test database, and reload privilege tables. You should answer y all your questions.
Step 4: Test Installation Of MariaDB
Then execute the following command on the command line to check the status of MariaDB:
sudo mysqladmin version
I hope it can help you...