--- title: "Databases" source: "https://docs.nexcess.com/learn/lamp-stack/databases/" description: "Covers MSSQL, myLittleAdmin, MySQL and PHPMyAdmin. Includes Setup phpMyAdmin on Linux (AlmaLinux), MariaDB vs MySQL: Which database solution is right for you?, Accessing the website database in the Nexcess Client Portal, Nexcess: MySQL & IP Whitelisting for Remote Access and Backup Your MSSQL Database in Cloud Sites. 1…" taxonomy: "lw_resource_category" parent: "LAMP Stack" articles: "106" --- # Databases Covers MSSQL, myLittleAdmin, MySQL and PHPMyAdmin. Includes Setup phpMyAdmin on Linux (AlmaLinux), MariaDB vs MySQL: Which database solution is right for you?, Accessing the website database in the Nexcess Client Portal, Nexcess: MySQL & IP Whitelisting for Remote Access and Backup Your MSSQL Database in Cloud Sites. 1… ## Sections - [MSSQL](https://docs.nexcess.com/learn/lamp-stack/databases/mssql.md): Includes Backup Your MSSQL Database in Cloud Sites, Backup a Cloud Sites MSSQL Database Using a cron, Restore a Cloud Sites MSSQL Database, Remap Cloud Sites MSSQL Users and Log into myLittleAdmin from Cloud Sites. 7 articles. - [myLittleAdmin](https://docs.nexcess.com/learn/lamp-stack/databases/mylittleadmin.md): Includes Backup Your MSSQL Database in Cloud Sites, Restore a Cloud Sites MSSQL Database, Remap Cloud Sites MSSQL Users and Log into myLittleAdmin from Cloud Sites. 4 articles. - [MySQL](https://docs.nexcess.com/learn/lamp-stack/databases/mysql.md): Includes Setup phpMyAdmin on Linux (AlmaLinux), Nexcess: MySQL & IP Whitelisting for Remote Access, MySQL Troubleshooting, MySQL Performance: Converting MySQL to MariaDB and Using phpMyAdmin. 54 articles. - [PHPMyAdmin](https://docs.nexcess.com/learn/lamp-stack/databases/phpmyadmin.md): Includes phpMyAdmin in Cloud Sites, Manual Cloud Sites MariaDB Database Backup, Assign Read-Only Permission for a Database User in Cloud Sites and Compare MyISAM and InnoDB MariaDB Databases in Cloud Sites. 4 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.  - [MariaDB vs MySQL: Which database solution is right for you?](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-vs-mysql-why-we-prefer-mariadb-for-new-installations.md): MariaDB vs. MySQL — choosing MariaDB over MySQL improves performance, adds more features, hardens security, and future-proofs your database on a truly open sour… - [Accessing the website database in the Nexcess Client Portal](https://docs.nexcess.com/sites-stores/flex-plans/database-management/access-website-database.md): You can access your website database from the Site Dashboard within the Nexcess Client Portal by using the phpMyAdmin utility as an excellent tool for database… - [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. - [Backup Your MSSQL Database in Cloud Sites](https://docs.nexcess.com/hosting/cloud-sites/database-management/mssql/backup-your-mssql-database-in-cloud-sites.md): Regularly backing up your database is crucial for site maintenance on Cloud Sites. To manually backup your MSSQL database, access myLittleAdmin from the Cloud S… - [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. - [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… - [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… - [Backup a Cloud Sites MSSQL Database Using a cron](https://docs.nexcess.com/hosting/cloud-sites/database-management/mssql/backup-a-cloud-sites-mssql-database-using-a-cron.md): Follow these steps to create a cron to back up your MSSQL databases. - [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… - [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. - [MariaDB performance tuning tips at Nexcess](https://docs.nexcess.com/hosting/server-administration/database-management/mariadb-mysql/mariadb-performance-tuning.md): Optimize MariaDB performance with our tuning script and expert tips. Learn to use MySQLTuner and benchmarking to get a faster database today. - [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. - [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. - [Restore a Cloud Sites MSSQL Database](https://docs.nexcess.com/hosting/cloud-sites/database-management/mssql/restore-a-cloud-sites-mssql-database.md): Restore your Cloud Sites MSSQL Database from a backup through myLittleAdmin. - [Remap Cloud Sites MSSQL Users](https://docs.nexcess.com/hosting/cloud-sites/database-management/mssql/remap-cloud-sites-mssql-users.md): Remap the server-level logins on Microsoft SQL Server database users on Cloud Sites. - [Log into myLittleAdmin from Cloud Sites](https://docs.nexcess.com/hosting/cloud-sites/database-management/mssql/log-into-mylittleadmin-from-cloud-sites.md): Manage your Windows MSSQL databases with ease. Learn how to quickly access and log into myLittleAdmin directly from your Cloud Sites control panel. - [Invalid MSSQL Cast Exception on Cloud Sites](https://docs.nexcess.com/hosting/cloud-sites/database-management/mssql/invalid-mssql-cast-exception-on-cloud-sites.md): Cloud Sites Windows clusters use specific data types that may introduce errors for some custom applications. The following is a work around for this known issue… - [Manual Cloud Sites MariaDB Database Backup](https://docs.nexcess.com/hosting/cloud-sites/database-management/mariadb-mysql/manual-cloud-sites-mariadb-database-backup.md): Create a manual backup of your MariaDB database from the Cloud Sites control panel. - [MSSQL Cloud Sites Databases](https://docs.nexcess.com/hosting/cloud-sites/database-management/mssql.md): Manage MSSQL in Cloud Sites. Guides for backing up, restoring data, remapping users, and connecting via SQL Server Management Studio. - [Restore Cloud Sites Databases or Content Backups](https://docs.nexcess.com/hosting/cloud-sites/backup-and-restore/restore-a-database-or-content-backup-in-cloud-sites.md): Recover your Cloud Sites data. Learn how to use Restore Points to revert your website files or database to a previous backup version. - [Optimize WordPress Database with WP-CLI Commands](https://docs.nexcess.com/hosting/cms/wordpress/optimize-wordpress-database.md): Optimize your WordPress database with WP-CLI and improve website performance. Learn how to create a searchable database in WordPress today. - [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. - [Assign Read-Only Permission for a Database User in Cloud Sites](https://docs.nexcess.com/hosting/cloud-sites/database-management/assign-read-only-permission-for-a-database-user-in-cloud-sites.md): Limit user access and secure your Cloud Sites data. Learn how to easily assign read-only permissions for your MSSQL and MariaDB database users. - [Change a Database User Password in Cloud Sites](https://docs.nexcess.com/hosting/cloud-sites/database-management/change-a-database-user-password-in-cloud-sites.md): This article will show you how to change database user passwords in Cloud Sites. - [Compare MyISAM and InnoDB MariaDB Databases in Cloud Sites](https://docs.nexcess.com/hosting/cloud-sites/database-management/mariadb-mysql/compare-myisam-and-innodb-mariadb-databasein-cloud-sites.md): Optimize your Cloud Sites database by comparing MyISAM and InnoDB engines in MariaDB. Learn the key differences and how to easily convert your tables. - [Create a Database in Cloud Sites](https://docs.nexcess.com/hosting/cloud-sites/database-management/create-a-database-in-cloud-sites.md): Create your database through your Cloud Sites control panel in just a few clicks. - [Import a Large MariaDB Database into Cloud Sites](https://docs.nexcess.com/hosting/cloud-sites/database-management/mariadb-mysql/import-a-large-mariadb-database-into-cloud-sites.md): Upload databases that are 50MB or less into Cloud Sites using phpMyAdmin or myLittleAdmin database managers. - [MariaDB / MySQL Cloud Sites Databases](https://docs.nexcess.com/hosting/cloud-sites/database-management/mariadb-mysql.md): Manage MariaDB/MySQL in Cloud Sites. Guides for importing large databases, creating manual backups, and choosing between InnoDB vs. MyISAM. - [Windows SQL Server Management Studio for Cloud Sites](https://docs.nexcess.com/hosting/cloud-sites/database-management/mssql/windows-sql-server-management-studio-for-cloud-sites.md): Securely access your MSSQL database for Cloud Sites using Microsoft SQL Server Management Studio. - [Database Management in Cloud Sites](https://docs.nexcess.com/hosting/cloud-sites/database-management.md): Manage Cloud Sites databases easily. Learn to create MySQL and MSSQL databases, assign users, and set permissions directly in your control panel. - [Understanding the WordPress database structure](https://docs.nexcess.com/hosting/cms/wordpress/troubleshooting/understanding-the-wordpress-database-structure.md): Learn about the WordPress database structure, key tables like wp_options, wp_users, & wp_posts, and how wp-config.php connects your site. - [Allowing Remote Database Access in Interworx](https://docs.nexcess.com/hosting/control-panel/interworx/nodeworx/database-management/allowing-remote-database-access-in-interworx.md): The InterWorx Control panel allows the ability to manage multiple external MySQL servers from a single installation of InterWorx, via MySQL server pooling. Once… - [Database Management in NodeWorx](https://docs.nexcess.com/hosting/control-panel/interworx/nodeworx/database-management.md): Your guide to managing the MySQL server in NodeWorx. Learn to control global settings, manage users, and ensure peak database performance. - [Managing Databases in Siteworx](https://docs.nexcess.com/hosting/control-panel/interworx/siteworx/database-management/managing-databases-in-siteworx.md): From the SiteWorx interface, SiteWorx users can create and manage MySQL databases. - [Managing Database Users in Siteworx](https://docs.nexcess.com/hosting/control-panel/interworx/siteworx/database-management/managing-database-users-in-siteworx.md): From the SiteWorx interface, SiteWorx users can create and manage MySQL database users. - [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. - [How to show running MySQL queries in SiteWorx](https://docs.nexcess.com/hosting/control-panel/interworx/siteworx/database-management/how-to-show-running-mysql-queries-in-siteworx.md): If you are a Nexcess client on a physical (non-cloud) server, you can use phpMyAdmin from your SiteWorx account to show running MySQL queries following the guid… - [How to create MySQL database user accounts in SiteWorx](https://docs.nexcess.com/sites-stores/control-panel/interworx/siteworx/database-management/user-accounts.md): How Nexcess clients on Siteworx can create a new MySQL database user account for a MySQL database. - [Creating a Non-Prefixed Database User Assigned to a SiteWorx Account](https://docs.nexcess.com/hosting/control-panel/interworx/siteworx/database-management/creating-a-non-prefixed-database-user-assigned-to-a-siteworx-account.md): While InterWorx allows the ability for SiteWorx accounts to use non-prefixed databases and database users, it is currently not possible to create non-prefixed d… - [Databases Management in Siteworx](https://docs.nexcess.com/hosting/control-panel/interworx/siteworx/database-management.md): Learn how to create, manage, import, and export your website's MySQL databases using the SiteWorx control panel and phpMyAdmin. - [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. - [Database Management in Plesk](https://docs.nexcess.com/hosting/control-panel/plesk/database-management.md): Plesk simplifies database administration, making it accessible for both beginners and experienced users. - [Database Management in WHM](https://docs.nexcess.com/hosting/control-panel/whm/database-management.md): Oversee your server's databases with WHM. Access phpMyAdmin, manage remote MySQL access, and repair tables to keep data running smoothly. - [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… - [Logging into phpMyAdmin from cPanel](https://docs.nexcess.com/hosting/control-panel/whm/cpanel/database-management/logging-into-phpmyadmin-from-cpanel.md): cPanel simplifies database management through phpMyAdmin. Once logged in, users can perform various tasks like adding and deleting data, connecting databases, a… - [Deleting a User From a Database or Account in cPanel](https://docs.nexcess.com/hosting/control-panel/whm/cpanel/database-management/deleting-a-user-from-a-database-or-account-in-cpanel.md): In cPanel, each MySQL database can have multiple users. If needed, you can delete a user from a specific database or remove the MySQL user entirely from your ac… - [Nexcess Flex Plans Database Management](https://docs.nexcess.com/sites-stores/flex-plans/database-management.md): Manage databases on your Flex Plan using the InterWorx control panel. Create users, access phpMyAdmin, and perform essential database tasks. - [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. - [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. - [Nexcess Managed Magento Database Management](https://docs.nexcess.com/sites-stores/managed-magento/database-management.md): Learn to manage your Magento store's database. Connect securely, perform backups and restores, and optimize your e-shop's data. - [Truncating MariaDB/MySQL tables in the Nexcess Cloud](https://docs.nexcess.com/sites-stores/managed-woocommerce/database-management/truncate-mariadb-mysql-tables.md): Truncating MariaDB/MySQL tables allows you to easily remove all data from the chosen MySQL database tables without having to manually delete and recreate them. - [Changing passwords for MariaDB users in the Nexcess Cloud](https://docs.nexcess.com/sites-stores/managed-woocommerce/database-management/change-mariadb-mysql-passwords.md): Nexcess Cloud web hosting plans provide a great way to manage your website databases and database MariaDB users from the Nexcess Client Portal. Learn more in th… - [Nexcess Managed WooCommerce Database Management](https://docs.nexcess.com/sites-stores/managed-woocommerce/database-management.md): Manage your WooCommerce store's database. Learn to access phpMyAdmin, create backups, and optimize your e-shop's database for speed. - [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… - [Nexcess Managed WordPress Database Management](https://docs.nexcess.com/sites-stores/managed-wordpress/database-management.md): Manage your WordPress database on our platform. Learn to access phpMyAdmin, create backups, and optimize your database for site performance. - [Convert MyISAM to InnoDB tables for database performance](https://docs.nexcess.com/sites-stores/performance/server-optimization/convert-mariadb-mysql-database-tables-from-myisam-to-innodb.md): 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 four metho… - [What Does Purge the CDN Mean? Purging the Nexcess CDN](https://docs.nexcess.com/sites-stores/performance/content-delivery-networks-cdns/nexcess/purge-cdn.md): Updated your website but not seeing changes? Learn what purging a CDN cache means and how to clear the Nexcess CDN to deliver your latest content. - [Using rsync for backups on Linux/Unix systems](https://docs.nexcess.com/sites-stores/server-administration/linux/file-management/using-rsync.md): Learn what `rsync` is and how to use it for fast, reliable backups on Linux. Our guide covers incremental file transfers for local and remote syncs. - [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. - [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. - [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 change permissions for MySQL users](https://docs.nexcess.com/sites-stores/control-panel/interworx/siteworx/database-management/mariadb-mysql-user-permissions.md): How Nexcess clients can use SiteWorx to change permissions for MySQL users. - [How to change the password for a MySQL database user in Siteworx](https://docs.nexcess.com/sites-stores/control-panel/interworx/siteworx/database-management/mariadb-mysql-user-passwords.md): How clients can use SiteWorx to change login passwords for MySQL users. - [How to import and export MySQL databases in SiteWorx](https://docs.nexcess.com/hosting/control-panel/interworx/siteworx/database-management/how-to-import-and-export-mysql-databases-in-siteworx.md): Learn how clients on physical (non-cloud) servers can import and export MySQL databases with the phpMyAdmin control panel in SiteWorx. - [How to import and export MySQL databases in SiteWorx](https://docs.nexcess.com/sites-stores/control-panel/interworx/siteworx/database-management/import-or-export-mariadb-mysql-databases.md): Learn how Nexcess clients can import and export MySQL databases with the phpMyAdmin control panel in SiteWorx. - [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. - [Creating a Database in Plesk](https://docs.nexcess.com/hosting/control-panel/plesk/database-management/creating-a-database-in-plesk.md): Plesk simplifies database creation for modern websites during development. - [Creating a Database User in Plesk](https://docs.nexcess.com/hosting/control-panel/plesk/database-management/creating-a-database-user-in-plesk.md): Easily add new database users in Plesk for specific access needs, like database administrators or third-party remote applications. - [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. - [Manage Databases in cPanel](https://docs.nexcess.com/hosting/control-panel/whm/cpanel/database-management.md): Your hub for database management in cPanel. Create MySQL databases and users, manage data with phpMyAdmin, and configure remote access. - [How to create MySQL databases with SiteWorx](https://docs.nexcess.com/sites-stores/control-panel/interworx/siteworx/database-management/create-mariadb-mysql-databases.md): How Nexcess clients on physical (non-cloud) servers can use the SiteWorx control panel to create a MySQL database. - [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… - [How to delete a MySQL database with SiteWorx](https://docs.nexcess.com/sites-stores/control-panel/interworx/siteworx/database-management/delete-a-mariadb-mysql-database.md): Learn how to delete a MySQL database with SiteWorx. - [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… - [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!* - [How to Install MariaDB 5.5 on Ubuntu 14.04 LTS](https://docs.nexcess.com/hosting/server-administration/database-management/how-to-install-mariadb-5-5-on-ubuntu-14-04-lts.md): In our tutorial, we install the database, MariaDB 5.5, otherwise known as MySQL, onto an Ubuntu 14.04 server in a few easy steps. - [Percona](https://docs.nexcess.com/hosting/server-administration/database-management/percona.md): Percona Server on Core-Managed Linux (no cPanel): Install this MySQL alternative, upgrade existing DBs & leverage XtraDB for better performance. - [Understanding Databases](https://docs.nexcess.com/hosting/server-administration/database-management/understanding-databases.md): A database is an organized collection of information. It provides an efficient and organized mechanism for storing, managing, and retrieving data. - [Server Database Management](https://docs.nexcess.com/hosting/server-administration/database-management.md): Master your database with our expert guides on administration, management, and high availability for MySQL, MariaDB, and more.