Articles in this category
MySQL Commands
MySQL command guide: Data dump/restore, password management, admin tasks (upgrades, root reset, slow log) & datadir/tmpdir setup.
MySQL Performance: Converting MySQL to MariaDB
Converting MySQL to MariaDB is beneficial for optimizing your website and database. In our tutorial, we cover how to upgrade your database o…
MySQL Troubleshooting
MySQL troubleshooting guide: Resolve DB corruption, connection problems, full disks, remote access, & advanced errors.
MySQL User Permissions for a Magento/Flex Cloud Plan
For Magento/Flexible Cloud Plans, learn to manage MySQL user permissions in the Nexcess SiteWorx Control Panel. Grant, modify, and delete pr…
Mysqldump
Use `mysqldump` to backup & restore MySQL/MariaDB. Learn to export DBs/tables, restore from SQL, & fix "trigger in wrong schema" errors.
Mysqldump stored procedures
MySQL Stored Procedures: Check for routines & ensure they're in `mysqldump` backups using `–routines`. cPanel's `/scripts/pkgacct` handles…
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…
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 art…
phpMyAdmin in Cloud Sites
Learn how to access phpMyAdmin in Cloud Sites. Follow this guide to log in, manage your MySQL databases, and troubleshoot connection issues.
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…
Remote MySQL Connections in cPanel
Liquid Web explains how you can connect to MySQL remotely in cPanel step-by-step. Learn more!
Resetting Your MySQL Root Password
Reset MySQL root password if security compromised. Change passwords every 90 days for enhanced server security.