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 10.2 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 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 MariaDB
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 using SET Password
14. How to Create ROLE in MariaDB
15. How to DROP ROLE in MariaDB
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 MariaDB/MySQL using mysqldump
2. Take Backup of Each DB in Timestamp Directory using mysqldump for MariaDB/MySQL
3. How to Take Backup of Specific Databases in MySQL or MariaDB
4. Create Zip Backup Files for Each Database using mysqldump in MySQL or MariaDB
5. How to Take Backup of Single Table in MySQL or MariaDB using mysqldump
6. How to Backup Every Table to Separate File using mysqldump in MySQL or MariaDB
7. How to Backup All Databases to Single File using mysqldump
8. How to Monitor Progress of Backup in MySQL or MariaDB
9. How to Restore Database in MySQL or MariaDB
10. How to Create and Restore Zipped Backup in MySQL or MariaDB
11. Restore Single MySQL Table from Full mysqldump Backup File
12. How to Monitor Restore Progress in MySQL or MariaDB
13. Restoring Single Database from Complete mysqldump

Chapter 4: Databases

1. How to Drop Multiple Databases in MySQL or MariaDB

Chapter 5: Logging

1. What is Error Log and How to Setup in MariaDB
2. What is General Query Log in MariaDB and How to Enable It
3. What is Slow Query Logging in MariaDB or MySQL and How to Enable It
4. What is Binary Logging and How to Enable It in MariaDB

Chapter 6: Graphical Tools - Heidi SQL

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 by Using Heidi SQL
4. How to Create a Table by Using Heidi SQL
5. How to Use SQL Help, Code Examples, Snippets, Templates in Heidi SQL
6. How to Search for Text in Table/Databases in MySQL or MariaDB
7. How to Import CSV File into MariaDB using Heidi SQL
8. Export Results to CSV from MySQL/MariaDB using Heidi SQL
9. Export Results to JSON from MySQL/MariaDB using Heidi SQL
10. Create User and Provide Permission via Heidi SQL
11. Synchronize Two Databases in MySQL or MariaDB via Heidi SQL
12. Load Large SQL File into MySQL or MariaDB via Heidi SQL
13. Generate Script for Entire Database with Data via Heidi SQL
14. Script All Database Objects via Heidi SQL
15. Make Copy of Table in MySQL or MariaDB via Heidi SQL
16. Mark Objects as Favorites in Heidi SQL
17. Get Query History in Heidi SQL
18. Check Currently Running Queries via Heidi SQL
19. Check and Change Server Level Settings via Heidi SQL