Search our site for answers
Help Docs Server Administration Server Database Management MariaDB / MySQL Database Administration

MariaDB / MySQL Database Administration

Your hub for MySQL administration. Find tutorials on installation, user management, backups, optimization, and troubleshooting to master your database.
Databases MySQL Server Management
2 min read

Your database is the beating heart of your website or application, holding everything from crucial customer data to your core content. Because databases are so vital, managing them, especially when running upgrades, dropping tables, or troubleshooting errors, can feel like high-stakes surgery. Fortunately, you don’t have to navigate these critical tasks blindly.

Whether you are provisioning a brand-new server, writing your first mysqldump command, or fine-tuning InnoDB variables to handle massive traffic spikes, this collection of guides provides the technical foundation you need. We cover both user-friendly graphical interfaces like cPanel and powerful command-line (SSH) techniques to help you securely and efficiently manage your MySQL and MariaDB environments.

Explore the guides below to learn how to:

  • Manage Users and Access: Secure your data by safely creating and deleting specific database users, resetting root passwords, and connecting external development tools like VSCode SQLTools.
  • Backup and Restore: Protect your server against catastrophic data loss by mastering manual backups, mysqldump exports, and full database restorations.
  • Maintain and Upgrade: Keep your environment secure and stable by safely upgrading database versions across various operating systems (Ubuntu, CentOS), checking for errors, and repairing corrupted tables.
  • Tune for Performance: Speed up sluggish query times by understanding key MySQL variables, mastering database indexing, and batch-converting legacy storage engines.

MariaDB / MySQL Database Articles

31 results

This collection contains articles and resources for MariaDB / MySQL administration. The topics covered include initial setup, user management, replication, and performance tuning.

  • Understanding the InnoDB storage engine in MySQL

    InnoDB: MySQL/MariaDB’s default engine for performance & reliability. Guide: features, `SHOW ENGINES`, create/alter tables & fix issues.

    Read more: Understanding the InnoDB storage engine in MySQL

  • Upgrading MySQL

    Planning a MySQL upgrade? Review supported upgrade paths, understand MariaDB migrations, and find step-by-step guides for WHM, Ubuntu, CentOS, and Plesk.

    Read more: Upgrading MySQL

  • Upgrading MySQL on CentOS

    Safely upgrade MySQL on an unmanaged CentOS server. Learn how to handle backups, fix old password hashes, update binaries, and import tables via SSH.

    Read more: Upgrading MySQL on CentOS

  • Upgrading MySQL on Ubuntu

    This tutorial is for the purpose of upgrading MySQL on an unmanaged server with an Ubuntu operating system. If you have CentOS or are upgrading via cPanel, please see our articles for instructions on upgrading via CentOS or WHM.

    Read more: Upgrading MySQL on Ubuntu

  • Upgrading MySQL/MariaDB on core managed servers

    Safely upgrade MySQL/MariaDB: Step-by-step guide for Core Managed servers. Includes pre-checks, backups (`rsync`, `mysqldump`), upgrade & follow-up.

    Read more: Upgrading MySQL/MariaDB on core managed servers

  • Using MySQL Tools via Secure Shell (SSH)

    Interacting with MySQL Client via command line allows manipulation of databases and their functions. This article covers common commands and their functionalities, facilitating database management.

    Read more: Using MySQL Tools via Secure Shell (SSH)

  • What is MySQL Indexing?

    What is MySQL indexing? Learn how it speeds up database queries by replacing slow linear searches with efficient binary sorting to improve server performance.

    Read more: What is MySQL Indexing?
Was this article helpful?