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.
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.
Have multiple MySQL databases? To avoid editing the wrong one, you must select it first. Here’s how to do it using cPanel or the command line.
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.
Learn how to export and import MySQL databases for backups. This guide covers using the command line (`mysqldump`), phpMyAdmin, and WP-CLI.
You need a way to check the status of your running MariaDB and MySQL queries, and so we will cover how to monitor them directly from your Nexcess Client Portal.