Category

MySQL

Articles in this category
Restoring a MySQL Database from a Backup
Made a change and something went wrong? Restoring a MySQL database from a backup is the fastest way to get your site back online.…
2 min read
Selecting a MySQL Database via Command Line and cPanel
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…
3 min read
Setting Up a Database with MySQL Database Wizard in cPanel
Databases are an important part of most modern, dynamic websites. This article provides instructions for setting up a database with MySQL Da…
3 min read
Setup phpMyAdmin on Linux (AlmaLinux)
Our helpful guide shows you how to install phpMyAdmin on AlmaLinux to easily manage your MariaDB or MySQL databases. 
13 min read
Setup phpMyAdmin on Linux (Ubuntu)
This tutorial shows you how to install and configure phpMyAdmin on Ubuntu to easily manage MariaDB or MySQL databases from a web browser.
4 min read
Show (List) MySQL Databases via Command Line on Linux
Find out how to easily show (list) all MySQL databases on Linux via command line with our comprehensive tutorial.
2 min read
Understanding key MySQL variables
This guide explains key MySQL variables, their purpose, impact, and default values. It's a reference for understanding server behavior and o…
9 min read
Understanding the InnoDB storage engine in MySQL
InnoDB: MySQL/MariaDB's default engine for performance & reliability. Guide: features, `SHOW ENGINES`, create/alter tables & fix issues.
3 min read
Upgrade MySQL 5.x in Plesk for Windows
On Plesk servers, all software upgrades must be done within the control panel. This guide shows how to upgrade MySQL 5.x to MariaDB on&helli…
2 min read
Upgrading MySQL
Planning a MySQL upgrade? Review supported upgrade paths, understand MariaDB migrations, and find step-by-step guides for WHM, Ubuntu, CentO…
2 min read
Upgrading MySQL in WHM
Safely upgrade MySQL or MariaDB in WHM. Learn how to create database backups, repair crashed tables, and navigate the WHM upgrade interface.
4 min read
Upgrading MySQL on CentOS
Safely upgrade MySQL on an unmanaged CentOS server. Learn how to handle backups, fix old password hashes, update binaries, and import tables…
5 min read