---
title: "MySQL"
source: "https://docs.nexcess.com/learn/lamp-stack/databases/mysql/"
description: "Includes Setup phpMyAdmin on Linux (AlmaLinux), Nexcess: MySQL & IP Whitelisting for Remote Access, MySQL Performance: Converting MySQL to MariaDB, MySQL Troubleshooting and MariaDB Databases & MariaDB Setup in the Nexcess Cloud. 54 articles."
taxonomy: "lw_resource_category"
parent: "Databases"
articles: "54"
---

# MySQL

Includes Setup phpMyAdmin on Linux (AlmaLinux), Nexcess: MySQL & IP Whitelisting for Remote Access, MySQL Performance: Converting MySQL to MariaDB, MySQL Troubleshooting and MariaDB Databases & MariaDB Setup in the Nexcess Cloud. 54 articles.

## Articles

- [Setup phpMyAdmin on Linux (AlmaLinux)](https://docs.nexcess.com/hosting/server-administration/database-management/phpmyadmin/setup-on-almalinux.md): Our helpful guide shows you how to install phpMyAdmin on AlmaLinux to easily manage your MariaDB or MySQL databases. 
- [Nexcess: MySQL & IP Whitelisting for Remote Access](https://docs.nexcess.com/sites-stores/managed-magento/database-management/whitelist-ips.md): 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.
- [MySQL Performance: Converting MySQL to MariaDB](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/upgrading-mysql-mariadb.md): Converting MySQL to MariaDB is beneficial for optimizing your website and database. In our tutorial, we cover how to upgrade your database on your Ubuntu and Ce…
- [MySQL Troubleshooting](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/mysql-troubleshooting.md): MySQL troubleshooting guide: Resolve DB corruption, connection problems, full disks, remote access, & advanced errors.
- [MariaDB Databases & MariaDB Setup in the Nexcess Cloud](https://docs.nexcess.com/sites-stores/flex-plans/database-management/user-access.md): Learn how to create and manage MariaDB databases and users in the Nexcess Client Portal. This guide covers setup, password retrieval, and assigning user permiss…
- [MySQL Commands](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/mysql-commands.md): MySQL command guide: Data dump/restore, password management, admin tasks (upgrades, root reset, slow log) & datadir/tmpdir setup.
- [Setup phpMyAdmin on Linux (Ubuntu)](https://docs.nexcess.com/hosting/server-administration/linux/setup-phpmyadmin-on-linux-ubuntu.md): This tutorial shows you how to install and configure phpMyAdmin on Ubuntu to easily manage MariaDB or MySQL databases from a web browser.
- [Using phpMyAdmin](https://docs.nexcess.com/sites-stores/server-administration/database-management/phpmyadmin/faq.md): Some website admins have trouble leveraging phpMyAdmin as a MySQL/MariaDB management tool, but Nexcess Hosting makes it easy to use from the Nexcess Client Port…
- [MySQL User Permissions for a Magento/Flex Cloud Plan](https://docs.nexcess.com/sites-stores/managed-magento/database-management/mariadb-mysql-user-accounts.md): For Magento/Flexible Cloud Plans, learn to manage MySQL user permissions in the Nexcess SiteWorx Control Panel. Grant, modify, and delete privileges.
- [phpMyAdmin in Cloud Sites](https://docs.nexcess.com/hosting/cloud-sites/phpmyadmin-in-cloud-sites.md): Learn how to access phpMyAdmin in Cloud Sites. Follow this guide to log in, manage your MySQL databases, and troubleshoot connection issues.
- [What is MySQL Indexing?](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/what-is-mysql-indexing.md): What is MySQL indexing? Learn how it speeds up database queries by replacing slow linear searches with efficient binary sorting to improve server performance.
- [How to show running MySQL queries in SiteWorx](https://docs.nexcess.com/sites-stores/control-panel/interworx/siteworx/database-management/show-running-mariadb-mysql-queries.md): Use phpMyAdmin from your SiteWorx account to show running MySQL queries following the guidance in the article.
- [Using MySQL commands with Plesk on Linux](https://docs.nexcess.com/hosting/control-panel/plesk/database-management/using-mysql-commands-with-plesk-on-linux.md): 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.
- [Upgrade MySQL 5.x in Plesk for Windows](https://docs.nexcess.com/hosting/control-panel/plesk/database-management/upgrade-mysql-5-x-in-plesk-for-windows.md): On Plesk servers, all software upgrades must be done within the control panel. This guide shows how to upgrade MySQL 5.x to MariaDB on Plesk for Windows.
- [Upgrading MySQL in WHM](https://docs.nexcess.com/hosting/control-panel/whm/database-management/upgrading-mysql-in-whm.md): Safely upgrade MySQL or MariaDB in WHM. Learn how to create database backups, repair crashed tables, and navigate the WHM upgrade interface.
- [Setting Up a Database with MySQL Database Wizard in cPanel](https://docs.nexcess.com/hosting/control-panel/whm/cpanel/database-management/setting-up-a-database-with-mysql-database-wizard-in-cpanel.md): Databases are an important part of most modern, dynamic websites. This article provides instructions for setting up a database with MySQL Database Wizard in cPa…
- [How to monitor running MariaDB and MySQL queries](https://docs.nexcess.com/sites-stores/managed-magento/database-management/show-running-mariadb-mysql-queries.md): You need a way to check the status of your running MariaDB and MySQL queries, and so we will cover how to monitor them directly from your Nexcess Client Portal.
- [New Relic monitoring of WordPress and database performance](https://docs.nexcess.com/sites-stores/managed-woocommerce/plugin-management/new-relic-monitoring.md): Application Performance Monitoring (APM), the New Relic monitoring product, integrates with our Nexcess platform to help online store owners find performance bo…
- [Show (List) MySQL Databases via Command Line on Linux](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/list-mysql-databases-command-line-linux.md): Find out how to easily show (list) all MySQL databases on Linux via command line with our comprehensive tutorial.
- [Selecting a MySQL Database via Command Line and cPanel](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/selecting-a-mysql-database.md): 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 command line.
- [Restoring a MySQL Database from a Backup](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/restoring-a-mysql-database-from-a-backup.md): Made a change and something went wrong? Restoring a MySQL database from a backup is the fastest way to get your site back online. Here's how.
- [Resetting Your MySQL Root Password](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/resetting-your-mysql-root-password.md): Reset MySQL root password if security compromised. Change passwords every 90 days for enhanced server security.
- [Mysqldump](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/mysqldump.md): Use `mysqldump` to backup & restore MySQL/MariaDB. Learn to export DBs/tables, restore from SQL, & fix "trigger in wrong schema" errors.
- [Moving the MySQL Data Directory](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/moving-the-mysql-data-directory.md): Move MySQL `datadir`: Step-by-step guide using `rsync`, symlinks, & `my.cnf` updates. Includes CloudLinux notes & critical backup advice.
- [Importing and exporting a MySQL database](https://docs.nexcess.com/sites-stores/server-administration/database-management/mariadb-mysql/import-or-export-a-mariadb-mysql-database.md): Learn how to export and import MySQL databases for backups. This guide covers using the command line (`mysqldump`), phpMyAdmin, and WP-CLI.
- [How to connect to MySQL/MariaDB using SQLTools in VSCode](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/connect-to-mysql-mariadb-using-sqltools-vscode.md): With SQLTools in VSCode, you can streamline your database workflow, making it a valuable tool for developers who interact with MySQL or MariaDB databases regula…
- [Deleting MySQL Users](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/deleting-mysql-users.md): If you are using MySQL databases with multiple users, you may need to control database access by deleting database users. You can delete MySQL users using eithe…
- [Creating a MySQL User](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/creating-a-mysql-user.md): Control MySQL database access by creating user-specific restrictions for databases, tables, and privileges. Use cPanel or the command line to create MySQL users…
- [Checking Your MySQL Version](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/checking-your-mysql-version.md): If you are using MySQL databases, you might need to occasionally check the version of MySQL that is installed on your server. It's easy to check your MySQL vers…
- [Checking a MySQL Database for Errors and Repairing](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/checking-a-mysql-database-for-errors-and-repairing.md): To check and repair MySQL database errors in cPanel, navigate to the MySQL Databases section after logging in. From there, you can access the home screen to man…
- [Change a MySQL User Password](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/change-a-mysql-user-password.md): Changing MySQL passwords to something new and secure is easy via the command line.
- [Modifying Fields in Database Tables with PhpMyAdmin](https://docs.nexcess.com/hosting/server-administration/database-management/phpmyadmin/modifying-fields-in-database-tables-with-phpmyadmin.md): Our tutorial walks you through examples of how to modify a field within your MySQL or MariaDB database. Learn to edit a field within a database table with phpMy…
- [How to Repair MySQL Tables](https://docs.nexcess.com/sites-stores/server-administration/database-management/phpmyadmin/repair-mariadb-mysql-tables.md): Learn how to repair MySQL tables in this helpful article using either phpMyAdmin or the MySQL CLI. Learn about MySQL database repair and table repair here.
- [Upgrading MySQL/MariaDB on core managed servers](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/upgrading-mysql-mariadb-on-core-managed-servers.md): Safely upgrade MySQL/MariaDB: Step-by-step guide for Core Managed servers. Includes pre-checks, backups (`rsync`, `mysqldump`), upgrade & follow-up.
- [Upgrading MySQL on CentOS](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/upgrading-mysql-on-centos.md): Safely upgrade MySQL on an unmanaged CentOS server. Learn how to handle backups, fix old password hashes, update binaries, and import tables via SSH.
- [Upgrading MySQL](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/upgrading-mysql.md): Planning a MySQL upgrade? Review supported upgrade paths, understand MariaDB migrations, and find step-by-step guides for WHM, Ubuntu, CentOS, and Plesk.
- [Installing MySQL community edition on new AlmaLinux 8 servers](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/installing-mysql-community-edition-on-new-almalinux-8-servers.md): Install MySQL Community on new AlmaLinux 8. *NEW SERVERS ONLY* (data loss risk). Steps: prep, repo, install, secure.
- [Remote MySQL Connections in cPanel](https://docs.nexcess.com/hosting/control-panel/whm/cpanel/database-management/remote-mysql-connections-in-cpanel.md): Liquid Web explains how you can connect to MySQL remotely in cPanel step-by-step. Learn more!
- [How to Delete a MySQL Database in cPanel](https://docs.nexcess.com/hosting/control-panel/whm/cpanel/database-management/how-to-delete-a-mysql-database-in-cpanel.md): Whether getting rid of an unneeded database or a corrupted one, this tutorial walks through how to delete a MySQL database in cPanel.
- [Adding MySQL Users to Databases](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/adding-mysql-users-to-databases.md): You can create MySQL users to help you organize your database management, giving each user access to specific databases and specific privileges. You can assign…
- [Allowing Remote Database Access](https://docs.nexcess.com/hosting/server-administration/database-management/allowing-remote-database-access.md): Remote database access may be needed for third-party apps but is disabled by default due to security risks. Learn when and how to enable it safely.
- [Deleting a MySQL Database](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/deleting-a-mysql-database.md): Deleting unused databases frees up space but the action is permanent! We strongly recommend backing up your database before you delete it, just in case.
- [Backing Up a MySQL Database](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/backing-up-a-mysql-database.md): Protect your website data before making major changes. Learn how to manually back up your MySQL databases using cPanel, the command line, or Plesk.
- [Change a MySQL User Password via cPanel](https://docs.nexcess.com/hosting/control-panel/whm/cpanel/database-management/change-a-mysql-user-password-via-cpanel.md): If you aren't familiar with using the command line interface, using cPanel makes it easy to change MySQL user passwords.
- [MariaDB / MySQL Database Administration](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql.md): Your hub for MySQL administration. Find tutorials on installation, user management, backups, optimization, and troubleshooting to master your database.
- [phpMyAdmin Web-Based Database Management](https://docs.nexcess.com/hosting/server-administration/database-management/phpmyadmin.md): Master phpMyAdmin with our guides. Learn to import/export data, manage users, run queries, and optimize your database with this powerful web interface.
- [How to truncate MySQL tables in SiteWorx](https://docs.nexcess.com/sites-stores/control-panel/interworx/siteworx/database-management/truncate-mariadb-mysql-tables.md): Learn how Nexcess clients on physical (non-cloud) accounts can perform the truncate table operation for MySQL tables from SiteWorx.
- [Upgrading MySQL on Ubuntu](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/upgrading-mysql-on-ubuntu.md): This tutorial is for the purpose of upgrading MySQL on an unmanaged server with an Ubuntu operating system. If you have CentOS or are upgrading via cPanel, plea…
- [Interworx: MariaDB and MySQL troubleshooting](https://docs.nexcess.com/hosting/control-panel/interworx/nodeworx/database-management/interworx-mariadb-and-mysql-troubleshooting.md): Fix InterWorx "replyCode: 500" on MySQL DB/user creation. Issue: empty MySQL user. Guide: diagnose via iworx.log, then remove from `mysql.user`.
- [Mysqldump stored procedures](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/mysqldump-stored-procedures.md): MySQL Stored Procedures: Check for routines & ensure they're in `mysqldump` backups using `--routines`. cPanel's `/scripts/pkgacct` handles this.
- [Understanding key MySQL variables](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/understanding-key-mysql-variables.md): This guide explains key MySQL variables, their purpose, impact, and default values. It's a reference for understanding server behavior and optimization, with ca…
- [Using MySQL Tools via Secure Shell (SSH)](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/using-mysql-tools-via-secure-shell-ssh.md): Interacting with MySQL Client via command line allows manipulation of databases and their functions. This article covers common commands and their functionaliti…
- [Understanding the InnoDB storage engine in MySQL](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/understanding-the-innodb-storage-engine-in-mysql.md): InnoDB: MySQL/MariaDB's default engine for performance & reliability. Guide: features, `SHOW ENGINES`, create/alter tables & fix issues.
- [Batch converting MySQL table engines](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/batch-converting-mysql-table-engines.md): MySQL batch table engine conversion: MyISAM InnoDB. Get CLI scripts, rollback prep, & robust methods. *Always backup data first!*