Databases

Plesk simplifies database creation for modern websites during development.

Many modern websites rely on databases to store important data. When these databases get large, your server can slow down when there are a lot of requests (queries) that the database has to handle. Speeding these queries up requires knowledge of MySQL indexing.

This tutorial is for the purpose of upgrading MySQL on an unmanaged server with a CentOS operating system. This tutorial assumes that you are already logged in as root via Secure Shell. Make sure you complete the backup process before making any changes to your MySQL.

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.

Making sure that your server software is up to date is one of the best ways to protect yourself from malicious attacks. This includes updating your database software, like MySQL. MySQL upgrades involve a number of steps, including planning, backups, upgrading binaries, upgrading tables, and cleanup.

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.

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.

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.

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

This article will show you how to change database user passwords in Cloud Sites.