Category

MySQL

Articles in this category
Upgrading MySQL
Planning a MySQL upgrade? Review supported upgrade paths, understand MariaDB migrations, and find step-by-step guides for WHM, Ubuntu, CentOS, and Plesk.
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 via SSH.
5 min read
Upgrading MySQL on Ubuntu
This tutorial is for the purpose of upgrading MySQL on an unmanaged server with an Ubuntu operating system. If you have CentOS or are…
6 min read
Upgrading MySQL/MariaDB on core managed servers
Safely upgrade MySQL/MariaDB: Step-by-step guide for Core Managed servers. Includes pre-checks, backups (`rsync`, `mysqldump`), upgrade & follow-up.
12 min read
Using MySQL commands with Plesk on Linux
Learn to use MySQL commands as root on a Plesk Linux server, understand /etc/psa/.psa.shadow, and set up passwordless MySQL access via /root/.my.cnf.
5 min read
Using MySQL Tools via Secure Shell (SSH)
Interacting with MySQL Client via command line allows manipulation of databases and their functions. This article covers common commands and their functionalities, facilitating database…
11 min read
What is MySQL Indexing?
What is MySQL indexing? Learn how it speeds up database queries by replacing slow linear searches with efficient binary sorting to improve server performance.
3 min read