How to Install and Use MariaDB on Ubuntu 22.04?

Sep 02, 2022 . Admin



Hi Guys,

This tutorial will give you example of How to Install and Use MariaDB on Ubuntu 22.04?. This article goes in detailed on Ubuntu 22.04 LTS : MariaDB : Install. This post will give you simple example of MariaDB-Server on Ubuntu 22.04 Example. you can understand a concept of Step-by-step Installation MariaDB for Ubuntu. Here, Creating a basic example of Unable to Install MariaDB on Ubuntu 22.04.

You can use this post for ubuntu 14.04, ubuntu 16.04, ubuntu 18.4, ubuntu 20.04, ubuntu 21 and ubuntu 22.04 versions.

Use the following steps to install and configure MariaDB on Linux ubuntu 22.04:

Step 1: Update System Dependencies

Step 2: Install MariaDB

Step 3: Configure MariaDB

Step 4: Test Installation Of MariaDB

Step 1: Update System Dependencies

Open terminal and execute the following command on command line to update system dependencies:

sudo apt update
sudo apt upgrade
Step 2: Install MariaDB

To install MariaDB on Ubuntu 22.04, utilize the given command in the terminal:

sudo apt install mariadb-server mariadb-client

MariaDB installation will take a few minutes to complete. To verify that the MariaDB server is running, type:

sudo service mariadb status
Step 3: Configure MariaDB

The following command to configure mariaDB:

sudo mysql_secure_installation

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 authorisation.

You already have your root account protected, so you can safely answer 'n'.

Switch to unix_socket authentication [Y/n]

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.

Remove the anonymous user, restrict root user access to the local machine, remove the test database, and reload privilege tables. You should answer y to all questions.

Step 4: Test Installation Of MariaDB

Execute the following command on command line to check the status of mariaDB:

sudo mysqladmin version
#Ubuntu