Guides from the NOC

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.

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.

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.

phpMyAdmin import stuck or showing 'MySQL server has gone away'? Fix max_allowed_packet errors on shared cPanel hosting and VPS, with prevention tips.

phpMyAdmin export stuck, blank, or crashing on a large cPanel database? Fix the timeout, memory limit, and CDN causes and get a reliable backup out safely.

phpMyAdmin import stuck, timing out, or erroring on a big .sql file in cPanel? Fix upload limits, timeouts, and packet size, or import via SSH instead.

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 '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.

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.

Learn how to use cPanel's WordPress Toolkit to clone, stage, and safely auto-update WordPress sites without SSH or phpMyAdmin, plus fixes for common errors.

Stuck seeing "Sorry, you are not allowed to access this page" in WordPress? Learn the real causes - lost admin role, plugin lockout, multisite - and the fix.

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.

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.

Locked out of wp-admin and the reset email never arrives? Learn how to reset your WordPress admin password safely through phpMyAdmin in cPanel.