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

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

PostgreSQL pgBadger

PostgreSQL Pgbadger Installation On Linux

How to configure Replication Manager (repmgr) ?

How To Schedule PostgreSQL Jobs using pgAgent on Linux plateform