How To Install MariaDB on Ubuntu 22.04

MariaDB is a robust open-source relational database management system that emerged as a fork of MySQL. Due to its fault tolerance, speed, and scalability, it is commonly used as a replacement for MySQL.

Prerequisites

• Launch the Ubuntu 22.04 instance on Neevcloud

• Access the server using SSH

Update && Upgrade the system

First, ensure your package list is up to date to avoid any issues with outdated packages

sudo apt-get update -y
sudo apt-get upgrade -y

Installing MariaDB

Install the MariaDB package by running the following command

sudo apt-get install mariadb-server -y

Start and Enable MariaDB

After installation, the MariaDB service starts and enables

Once the MariaDB is installed, start the MariaDB server

sudo systemctl start mariadb

Enable it to start when the system rebooted

sudo systemctl enable mariadb

To check the status

Verify that the database service is active and running. Run the following command

sudo systemctl status mariadb

Network status of the MariaDB Service

The network status of the MariaDB service can also be checked by running the ss command at the terminal prompt

sudo ss -antpl | grep mariadb

Configure MariaDB

Running the mysql_secure_installation script is advisable to set up your database security levels and access privileges.

sudo mysql_secure_installation

To secure MariaDB and access it, we must use the current credentials for login, and password required for the root user. If you recently set up MariaDB and If you haven't created the root password, simply hit the enter key at this point.

Setting the root password or using the unix_socket, You already have your root account protected, so you can safely answer 'n'.

You set the password of your root account and the password should be 8 to 10-bit.

By default, MariaDB installation has an anonymous user, if you want to remove the anonymous user press 'Y' otherwise and click 'n'.

if you disallow root login remotely press Y and otherwise click enter.

By Default. MariaDB comes with a database named 'test' that anyone can access. if you want to remove the test database press 'Y', otherwise 'n'.

All done! If you've completed all of the above steps, your MariaDB installation should now be secure. you can proceed to reopen MariaDB and revert the root user's authentication method to the default, auth_socket. To verify your identity as the main MySQL user with a password, execute this command

sudo mysql -u root -p

After executing the commands, please enter your password

Create a MariaDB User

To create a new MariaDB user, type the following command in the MariaDB console just like

[MariaDB (none)]>

CREATE USER 'username'@localhost IDENTIFIED BY 'password1';

• Grant Privileges to MariaDB User

Once you have set up a new user, you can give them the necessary permissions.

GRANT ALL PRIVILEGES ON *.* TO 'username'@localhost IDENTIFIED BY 'password1';

Creating a MariaDB Database

To create a database in MariaDB, follow these steps:

CREATE DATABASE database_name;

• User and database permission

Once you have set up a new user and database, you can give them the necessary permissions.

GRANT ALL PRIVILEGES ON database_name.*  TO  'username'@'%';

Now, review MariaDB configurations.

sudo mysql -u root -p 

Now check the status databases to run these command

show databases;