MariaDB Admin & Dev Tutorial

MariaDB Tutorial for Admins and Developers

Chapter 1 : Installation



  1. How to Install MariaDB on Windows 10
  2. How to Change MariaDB Data Directory on Windows
  3. How to Uninstall MariaDB from Windows 10
  4. How to Install MariaDB on Windows 2012 Server
  5. How to Install MariaDB on Linux Stand Alone
  6. How To Move a MariaDB Data Directory to a New Location on Linux
  7. How to Uninstall MariaDB from Linux CentOS
  8. How To Create a Galera Cluster with MariaDB 10.2 on CentOS Servers
  9. Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock
  10. How to Upgrade MariaDB 10.1 to MariaDB 102. on CentOS
  11. How to migrate from MySQL to MariaDB on Linux


Chapter 2 : Permissions


  1. How to create/Drop User in MariaDB
  2. How to Grant all the permissions to User in MariaDB
  3. How to Grant Full Permission on a Database to a User in MariaDB
  4. How to Grant Select Permission on Table/s  to User in MariaDB
  5. How to Grant Update Permission on Table/s to a User in MariaDB
  6. How to Grant INSERT Permission on Table/s to a User in MariaDB
  7. How to Grant Drop/Create Table Permission to a User in MariaDB
  8. How to Grant Delete Permission on Table/s to a User in MariaDB
  9. How to Grant Permission on Table Columns in MairaDB
  10. What is GRANT OPTION in MariaDB
  11. How to RENAME USER in MariaDB
  12. How to use REVOKE statement in MariaDB
  13. How to Change Password in MariaDB by using SET Password
  14. How to create ROLE in MariaDB
  15. How to DROP ROLE in MairaDB
  16. How to see Permissions of a user in MariaDB


Chapter 3 :  Backup / Restore