In this tutorial we ae going to install MariaDB on Ubuntu 18.04 machine
Our Recommended Template : Ubuntu 18.04
Step 1: Use the below command to install MariaDB
sudo apt -y install mariadb-server mariadb-client
Step 2: Enable and Start MariaDb to run on startup
systemctl enable mariadb systemctl start mariadb
Step 3: Secure MariaDB by running mysql_secure_installation.
Step 4: log in to MariaDB as the root user and Creating Database
mysql -u root -p
When prompted, enter the root password you assigned when the mysql_secure_installation script was run.
You’ll then be presented with a welcome header and the MariaDB prompt as shown below:
Use the below command to create a database
(Here the database name is “nextdb” you can use your preferred name)
create database nextdb; grant all on nextdb.* to '<username>' identified by '<password>;