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 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.
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.