MySQL and phpMyAdmin

1. Fix the database connection error in WordPress What to check when WordPress shows Error establishing a database connection after migrating the site or changing its MySQL details. 8 min · Reviewed 09/2026 →
2. Which MySQL variables can be changed on managed hosting Tell MySQL global and session variables apart, learn which settings managed hosting allows and use alternatives that need no administrative privileges. 4 min · Reviewed 09/2026 →
3. Clone a database Duplicate a MySQL database by first creating the destination and its permissions in cPanel, then copying the structure and data from phpMyAdmin. 3 min · Reviewed 09/2026 →
4. MySQL 5.7 support, now deprecated Prepare for the withdrawal of MySQL 5.7 before 31 December 2026 by migrating application and data to staging with tests, backups and a way back. 3 min · Reviewed 09/2026 →
5. MySQL 8, character set change from latin1 to utf8mb4 Fix garbled characters in older applications after moving to MySQL 8 by setting latin1 on the connection when the project still needs it. 3 min · Reviewed 09/2026 →
6. Create a database and its user with the cPanel wizard Create a MySQL database, its user and the permission assignment from the cPanel wizard to get an application's connection details. 3 min · Reviewed 09/2026 →
7. Manage MySQL databases, users and permissions in cPanel Manage MySQL databases, users, permissions, repairs and credential changes from cPanel, keeping each application's configuration up to date. 3 min · Reviewed 09/2026 →
8. Kill running MySQL queries Identify slow or blocked MySQL queries and tell the difference between stopping a statement and closing its connection, with checks before and after. 5 min · Reviewed 09/2026 →
9. Secure remote connection to the MySQL server Protect a remote MySQL connection with an SSH tunnel and configure the SSH credentials and the database credentials separately. 4 min · Reviewed 09/2026 →
10. Convert a MyISAM database to InnoDB by changing the storage engine Convert MyISAM tables to InnoDB on a verified clone, check space, indexes and rows, and keep the original database so you can revert. 4 min · Reviewed 09/2026 →
11. Convert a database from utf8 to utf8mb4 Migrate tables from utf8 to utf8mb4 on a cloned database, checking collations and indexes and keeping a dump and the original database so you can revert. 7 min · Reviewed 09/2026 →
12. Remote MySQL Authorise a specific IP to connect to MySQL from another machine, limit the user's privileges and learn the restrictions of the managed port 3306. 5 min · Reviewed 09/2026 →
13. Check your MySQL version and compatibility Identify the actual version of the MySQL server your application uses, review compatibility and tell managed configuration apart from per-session settings. 2 min · Reviewed 09/2026 →
14. phpMyAdmin separate from cPanel Install phpMyAdmin outside cPanel only temporarily, protect it with HTTPS and IP restrictions, and limit the MySQL user before revoking it when you finish. 3 min · Reviewed 09/2026 →
15. Use phpMyAdmin to query, export and import databases Manage tables and records with phpMyAdmin, run SQL, import or export backups, and use cPanel to create, rename or delete databases. 5 min · Reviewed 09/2026 →
16. Search and replace across all the content of a database or application Run bulk search and replace in WordPress without damaging serialised data, with a verified backup, a trial run, a preview and a way back. 4 min · Reviewed 09/2026 →

No articles match “”.