Databases

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

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

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.

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

If you are using MySQL databases with multiple users, you may need to control database access by deleting database users. You can delete MySQL users using either cPanel or the command line.

Remote database access may be needed for third-party apps but is disabled by default due to security risks. Learn when and how to enable it safely.

Changing MySQL passwords to something new and secure is easy via the command line.

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.

Follow these steps to create a cron to back up your MSSQL databases.

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.

Made a change and something went wrong? Restoring a MySQL database from a backup is the fastest way to get your site back online. Here’s how.

Create a manual backup of your MariaDB database from the Cloud Sites control panel.