Articles in this category
Nexcess: MySQL & IP Whitelisting for Remote Access
It’s possible to allow MySQL remote connections from any host. Learn how to whitelist MySQL host IP. Grant MySQL remote access with this article.
Percona
Percona Server on Core-Managed Linux (no cPanel): Install this MySQL alternative, upgrade existing DBs & leverage XtraDB for better performance.
phpMyAdmin Web-Based Database Management
Master phpMyAdmin with our guides. Learn to import/export data, manage users, run queries, and optimize your database with this powerful web interface.
Remote MySQL Connections in cPanel
Liquid Web explains how you can connect to MySQL remotely in cPanel step-by-step. Learn more!
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.…
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…
Server Database Management
Master your database with our expert guides on administration, management, and high availability for MySQL, MariaDB, and more.
Setup phpMyAdmin on Linux (AlmaLinux)
Our helpful guide shows you how to install phpMyAdmin on AlmaLinux to easily manage your MariaDB or MySQL databases.
Unblock site/block site with password protection for dev and staging environments
How do you restrict access to your development or staging website created for testing purposes? The answer is password protection — used as a…
Understanding Databases
A database is an organized collection of information. It provides an efficient and organized mechanism for storing, managing, and retrieving data.
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 optimization, with caution for…
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.