Resource Topic: MySQL
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…
Importing and exporting a MySQL database
Learn how to export and import MySQL databases for backups. This guide covers using the command line (`mysqldump`), phpMyAdmin, and WP-CLI.
Convert MyISAM to InnoDB tables for database performance
With regard to database tables and storage engines, after learning why we would want to convert MyISAM to InnoDB for better performance, let’s review…
How to monitor running MariaDB and MySQL queries
You need a way to check the status of your running MariaDB and MySQL queries, and so we will cover how to monitor them…
MariaDB Databases & MariaDB Setup in the Nexcess Cloud
Learn how to create and manage MariaDB databases and users in the Nexcess Client Portal. This guide covers setup, password retrieval, and assigning user…
New Relic monitoring of WordPress and database performance
Application Performance Monitoring (APM), the New Relic monitoring product, integrates with our Nexcess platform to help online store owners find performance bottlenecks.
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.
Modifying Fields in Database Tables with PhpMyAdmin
Our tutorial walks you through examples of how to modify a field within your MySQL or MariaDB database. Learn to edit a field within…
Installing WordPress using WP-CLI
With your SSH credentials, learn how to install WordPress using the WordPress Command Line Interface (WP-CLI) after creating a database for the new WordPress…