Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

HOW TO INSTALL MARIADB

MariaDB server is a community developed fork of MySQL server. Started by core members of the original MySQL team, MariaDB is designed as a drop-in replacement of MySQL(R) with more features, new storage engines, fewer bugs, and better performance.
MariaDB can be an better choice for choice for database professionals looking for a robust, scalable, and reliable SQLserver.
In this tutorial, we will explain how to install the latest version of MariaDB on a CentOS 7 / RHEL 7 server.

Step 1: Add MariaDB Yum Repository

– Create a new repo file /etc/yum.repos.d/mariadb.repo and add the below code changing the base url according to the operating system version and architecture.
# vi /etc/yum.repos.d/mariadb.repo

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.3/centos73-amd64/
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

Step 2 – Install MariaDB Server

– Let’s use the following command to install MariaDB 10.3 .
# yum install MariaDB-server MariaDB-client
– Once the installation is complete, we’ll enable and start the daemon with the following commands:
# systemctl enable mysql.service
# systemctl start mysql.service

Step 3 – Secure MariaDB Install

– MariaDB includes a security script “mysql_secure_installation” to change some of the less secure default options for things like remote root logins and sample users. To do this you can read our previous article Securing MySQL server / Mariadb with mysql_secure_installation from command line guide.

Step 4 – Working with MariaDB

– Once the configuration is complete, connect to MariaDB server using the following command.
# mysql -u root -p

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 16
Server version: 10.3.2-MariaDB MariaDB Server

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>
– Let’s create a new database
## CREATE DATABASE
MariaDB [(none)]> CREATE DATABASE Test_db;
– Create a database user account
## CREATE USER ACCOUNT
MariaDB [(none)]> CREATE USER 'dbuser'@'localhost' IDENTIFIED BY 'Password';
– Grant permissions on the database “Test_db” for the new user “dbuser”, the bellow command allows the user “dbuser” to read, edit, execute and perform all tasks across the database “Test_db”.
## GRANT PERMISSIONS ON DATABASE
MariaDB [(none)]> GRANT ALL ON Test_db.* TO 'dbuser'@'localhost';
– Once you have grant the permissions that you want to set up for your new users, make sure to reload all the privileges using the following command:
 
##  RELOAD PRIVILEGES
MariaDB [(none)]> FLUSH PRIVILEGES;

Comments

Popular posts from this blog

PostgreSQL pgBadger

PostgreSQL Pgbadger Installation On Linux

How to configure Replication Manager (repmgr) ?

What's is the difference between streaming replication Vs hot standby vs warm standby ?

PostgreSQL Sequence