How to Grant all the permissions to User in MariaDB

How to Grant all the permissions to User in MariaDB explains all the steps which are required to create a user in MariaDB and provide him all the permissions like root in MariaDB.




How to Create/Drop User in MariaDB - MariaDB Admin Tutorial

In this video demo, you will learn how to create and drop user in MariaDB.

Below items are covered in video
  • How to Create/Drop User in MariaDB video demo shows
  • How to create user in MariaDB without password
  • How to create user in MairaDB with Password
  • How to check existing users in MariaDB
  • How to login to MariaDB by using new user account
  • How to drop the user account in MariaDB

How to Migrate from MySQL to MariaDB on Linux CentOS - MariaDB Admin Training

How to migrate from MySQL to MariaDB on Linux CentOS video demo explains all the steps which you need to take to migrate from MySQL 5.6 to MariaDB 10.2.
  • Remove all MySQL installed packages
  • The steps are below. For Script visit www.techbrotherstutorials.com
  • Check the version of MySQL
  • Create MariaDB.Repo
  • Stop MySQL Service
  • Install MariaDB 10.2 to replace MySQL
  • Login to MariaDB and Validate databases

How to Upgrade MariaDB 10.1 to MariaDB 10.2 on CentOS server

How to Upgrade MariaDB 10.1 to MariaDB 10.2 on CentOS server is detailed video demo how to upgrade MariaDB from 10.1 to 10.2. Below items are covered in demo
  • Run the Installation with new version 10.2
  • Check the Current Version of MariaDB
  • Stop MariaDB (Mysql) service
  • Uninstall MariaDB 10.1
  • Update the Repo file with new version
  • Start MariaDB service
  • Run mysql_upgrade to update databases from MariaDB 10.1 to MariaDB 10.2
  • Check the version of MariaDB
  • Validation

How To Create a Galera Cluster with MariaDB 10.2 on CentOS Servers - MariaDB Admin Tutorial

How to Create a Galera Cluster with MariaDB 10 2 on CentOS Servers video demo covers below items


  • How to  check Linux version for MariaDB installation
  • Create or Edit MairaDB.repo
  • Install MariaDB Server and MariaDB Client
  • Start MariaDB Service
  • Run secure Installation of MariaDB 
  • Log into MariaDB by using root and create database to test if installation of MariaDB went fine.
  • How to make changes to sever.cnf to enable Galera Cluster
  • How to start Galera Cluster on firest Node
  • How to start MariaDB service on 2nd node to join Galera Cluster
  • Create Database on each of the node and check if Replication is working fine in Galera Cluster.

How to install and configure Galera Cluster with MariaDB step by step

How to Uninstall MairaDB from Linux CentOS

The video demo explains all the steps that you need to take to Uninstall MairaDB from Linux CentOS.

How to Uninstall MariaDB from CentOS step by step

How To Move a MariaDB Data Directory to a New Location on Linux

How To Move a MariaDB Data Directory to a New Location on Linux

The demo video covers all the steps which are required to move MariaDB data Directory to New Location.
Below are the items covered in the demo video. For scripts you can visit www.techbrotherstutorials.com

  • Check the current Location of Data Directory in MariaDB
  • How to Stop the MariaDB Service 
  • Check the MariaDB service status by using below command
  • Copy Entire mysql directory to new location in MariaDB
  • How to edit my.cnf configuration file in MariaDB to change data directory
  • How to Start MariaDB Service
  • Create a database to test new location is working fine in MariaDB after data directory moved to new location

How to Install MariaDB on Linux CentOS Step by Step

How to Install MariaDB on Linux Centos, video covers these topics
  • Create or Edit MairaDB.repo
  • How to check Linux version for MariaDB installation
  • Install MariaDB Server and MariaDB Client
  • Start MariaDB Service
  • Run secure Installation of MariaDB 
  • Login to MariaDB and validate if everything looking good by creating Database, creating table and inserting data into table.

How to Install MariaDB on Windows 2012 Server Step by Step

How to Install MariaDB on Windows 2012 Server video demo explains all the steps from downloading to installation of MariaDB on Windows Server.

How to Change MariaDB Data Directory on Windows 10

In this video you will learn how to change data directory for MariaDB from current/default to new data directory.
Below steps are required when you perform this action.

  • Find current/default data directory location
  • Stop MySQL Service
  • Check my.ini file
  • Update my.ini to new Data Directory
  • Move existing files to new Data Directory
  • Restart MySQL Service
  • Validate if Data Directory is changed successfully by creating Database and Test tables



How to Install MariaDB on Windows 10

MariaDB Administration Tutorial 

How to Install MariaDB on Windows 10

TechBrothers has started a new Tutorial " MariaDB Administration". This is first video of Tutorial which covers below topics

  • How to download MariaDB for Windows Installation
  • How to Run Installation Process for MariaDB on Windows 10.
  • How to provide location for MariaDB installation directory
  • Provide the Root Password during MariaDB installation on Windows 10

Choose the features while installing MariaDB on Windows 10
  • MySQL Client
  • MySQL Database service
  • HeidiSQL Third Party interface to connect to MariaDB

At the end of the video, I showed
  • How to create the database by using MySQL Client interace
  • How to connect to HeidiSQL and connect to MariaDB
  • How to use mysql -uroot -p to connect to MariaDB