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.
You can easily limit access to database users that you don’t want to have permissions to change the content of your database. Regardless if you have MSSQL or MariaDB, you have this functionality in just a few simple steps. This article will walk you through file permissions in MSSQL and MariaDB.
Upload databases that are 50MB or less into Cloud Sites using phpMyAdmin or myLittleAdmin database managers.
Nexcess Cloud web hosting plans provide a great way to manage your website databases and database MariaDB users from the Nexcess Client Portal. Learn more in this informative article.
Learn how to export and import MySQL databases for backups. This guide covers using the command line (`mysqldump`), phpMyAdmin, and WP-CLI.
How do you restrict access to your development or staging website created for testing purposes? The answer is password protection — used as a way to block a site or unblock a site for visitors.
With regard to database tables and storage engines, after learning why we would want to convert MyISAM to InnoDB for better performance, let’s review four methods for doing so.
You can access your website database from the Site Dashboard within the Nexcess Client Portal by using the phpMyAdmin utility as an excellent tool for database management.
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.