Articles in this category
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…