Articles in this category
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&hellip…
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 & fo…
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…
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…
Using phpMyAdmin
Some website admins have trouble leveraging phpMyAdmin as a MySQL/MariaDB management tool, but Nexcess Hosting makes it easy to use from the…
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 s…