Guides from the NOC

Restore MySQL to the exact second before a bad query hit with binary log point-in-time recovery. Setup, restore steps, and mistakes to avoid.

Getting 'Unknown collation utf8mb4_0900_ai_ci' when importing a MySQL 8 database dump into cPanel's older MariaDB? Here's the exact cause and fix, step by step.

MySQL error 1226 'max_user_connections' exceeded on cPanel or WHM hosting? Here's exactly why it happens and how to raise the limit and fix it for good.

Getting 'Access denied for user' connecting to MySQL in cPanel? Fix unlinked users, host mismatches, wrong username prefixes, and stale credentials fast.

Upgrading MySQL or MariaDB from WHM? Here's how to use the built-in upgrade tool safely, without corrupting cPanel databases, phpMyAdmin, or client sites.

Grant cPanel MySQL database users only the privileges they actually need. Read-only, backup, and app-specific access explained with GRANT/REVOKE examples.

Import throwing #1449 'definer does not exist' on MySQL views or triggers? Fix it on shared cPanel hosting without SUPER privileges, step by step, for good.

VPS clock right but cron, WordPress, and MySQL times don't match? Fix timezone settings across OS, PHP, MySQL, cron, and Docker layer by layer.

Getting 'Deadlock found when trying to get lock' in MySQL on WooCommerce or WordPress? Learn why it happens and how to fix and prevent it for good.

Slow WordPress or app on your VPS even with low CPU? Tune innodb_buffer_pool_size, max_connections, and tmp_table_size in my.cnf the right way.

Upgrading MySQL or MariaDB on your VPS? Follow this backup-test-upgrade checklist so WordPress, WooCommerce, or your app doesn't break after the update.

Set up MySQL master-replica replication between two VPS servers step by step - binlog config, CHANGE MASTER TO, verifying sync, and fixing common errors.

phpMyAdmin timing out on a big database? Learn to back up and restore MySQL on your VPS with mysqldump, fix common errors, and automate it with cron.

Getting 'MySQL server has gone away' on WordPress or a PHP app? Learn the real causes - timeouts, packet size, crashes - and fix each one step by step.

Site feels sluggish but CPU looks fine? Learn how to enable the MySQL slow query log, read it with mysqldumpslow, and fix the queries actually slowing you down.

Learn how to allow external MySQL connections in cPanel with Remote MySQL, fix error 1130/2003, and secure remote database access the right way.

MySQL table marked as crashed? Learn how to confirm it, repair it safely via phpMyAdmin or SSH with mysqlcheck, and stop it from happening again.

Getting MySQL error 1040 Too Many Connections on your WordPress site or VPS? Learn how to diagnose the real cause and fix it safely, step by step.

Learn to create MySQL databases and users in cPanel, fix #1045 access denied errors, and import or export large databases through phpMyAdmin without timeouts.

Getting a #1005 or foreign key constraint fails error during a phpMyAdmin import? Here's exactly why it happens on cPanel and the steps to fix it safely.

Fix failed WHM cpmove restores on a new server: username collisions, missing packages, DNS zone conflicts, and MySQL errors, with the exact commands.

phpMyAdmin keeps kicking you back to login or showing 'Loading Failed' mid-query in cPanel? Here's what actually causes it and how to fix it for good.

A bloated wp_options table with too much autoloaded data slows every WordPress page load. Here's how to find the worst offenders and clean it up safely.

Learn why old MyISAM tables cause crashes and locking issues, and how to safely convert them to InnoDB in phpMyAdmin without breaking WordPress or WooCommerce.