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.

Adding MySQL Users to Databases
You can create MySQL users to help you organize your database management, giving each user access to specific databases and specific privileges. You can assign MySQL users to databases and give them permissions using: cPanel or the command line.
Read more: Adding MySQL Users to Databases
Backing Up a MySQL Database
Protect your website data before making major changes. Learn how to manually back up your MySQL databases using cPanel, the command line, or Plesk.
Read more: Backing Up a MySQL Database
Batch converting MySQL table engines
MySQL batch table engine conversion: MyISAM InnoDB. Get CLI scripts, rollback prep, & robust methods. *Always backup data first!*
Read more: Batch converting MySQL table engines
Change a MySQL User Password
Changing MySQL passwords to something new and secure is easy via the command line.
Read more: Change a MySQL User Password
Checking a MySQL Database for Errors and Repairing
To check and repair MySQL database errors in cPanel, navigate to the MySQL Databases section after logging in. From there, you can access the home screen to manage databases and users.
Read more: Checking a MySQL Database for Errors and Repairing
Checking Your MySQL Version
If you are using MySQL databases, you might need to occasionally check the version of MySQL that is installed on your server. It’s easy to check your MySQL version using either cPanel or the command line.
Read more: Checking Your MySQL Version
Creating a MySQL User
Control MySQL database access by creating user-specific restrictions for databases, tables, and privileges. Use cPanel or the command line to create MySQL users.
Read more: Creating a MySQL User
Deleting a MySQL Database
Deleting unused databases frees up space but the action is permanent! We strongly recommend backing up your database before you delete it, just in case.
Read more: Deleting a MySQL Database