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
  17. How to change Root Password for MariaDB


Chapter 3 :  Backup / Restore

  1. How to perform backup of a database in MairaDB/MySQL by using mysqldump
  2. Take backup of each DB in newly created timestamp directory by using mysqldump for MairaDB /MySQL
  3. How to take backup of specific databases in MySQL or MariaDB
  4. Create Zip Backup files for each Database by using mysqldump in MySQL or MairaDB
  5. How to take a backup of single table in MySQL or MairaDB by using mysqldump
  6. How to backup every table from a database to separate file by using mysqldump in mysql or Mairadb
  7. How to backup all Databases to single file in MySQL or MairaDB by using mysqldump
  8. How to monitor the progress of backup in MySQL or MariaDB
  9. How to Restore a database in MySQL or MariaDB
  10. How to create zipped Backup and Restored zipped Backup in MySQL or MariaDB
  11. Restore single MySQL table from a full mysqldump backup file
  12. How to monitor the Restore progress in MySQL or MariaDB
  13. Restoring a single database from a complete MySQL database dump

Chapter 4: Databases


Chapter 5 : Logging

  1. How to download and Install Heidi SQL for MySQL or MariaDB
  2. How to connect to MySQL or MariaDB from Heidi SQL
  3. How to create a Database in MySQL or MariaDB by using Heidi SQL
  4. How to create a table in MySQL or MariaDB by using Heidi SQL
  5. How to use SQL Help , Code Examples , Snippets , Templates in Heidi SQL
  6. How to search for text in a table or databases or entire MySQL or MariaDB
  7. How to Import CSV file into MySQL or MairaDB Table by using Heidi SQL
  8. Export Results to CSV file from MySQL or MairaDB by using Heidi SQL
  9. How to Export Results To JSON from MySQL or MariaDB by using Heidi SQL
  10. Create User and Provide Permission by using User Manager in MySQL or MariaDB by using Heidi SQL
  11. How to Synchronize two database in MySQL or MariaDB by using Heidi SQL
  12. How to load large size sql file into MySQL or MariaDB without opening it by using Heidi SQL
  13. How to generate script for entire database with Data for MySQL or MariaDB by using Heidi SQL
  14. How to Script all database objects for MySQL or MariaDB by using Heidi SQL
  15. How to make a copy of a table in MySQL or MariaDB by using Heidi SQL
  16. How to mark different objects such as tables views as Favorite in Heidi SQL for MySQL or MariaDB
  17. How to get Query History in Heidi SQL for MySQL or MairaDB
  18. How to Check Currently Running Queries / Processes on MySQL or MariaDB by using Heidi SQL
  19. How to Check and Change Server Level Setting for MySQL or MariaDB by using Heidi SQL