Guides tagged “mysql”
Step-by-step MdmHost guides about mysql, sorted A-Z.
53 guides · page 1 of 3
Allow remote MySQL connections in cPanel (Remote Database Access)
Let a desktop tool or another server connect to your cPanel MySQL database by adding its IP in Remote Database Access, with the right host, port and security tips.
Automating MySQL backups with mysqldump and cron
Write a mysqldump backup script, store compressed dumps with rotation, and schedule it with cron so your MySQL or MariaDB data is recoverable.
Back Up MariaDB with mariabackup: Full and Incremental
Take a physical MariaDB backup with mariabackup, prepare it, add incrementals, and restore it safely on a Linux VPS.
Back up MySQL and PostgreSQL databases in Docker containers
Dump MySQL, MariaDB and PostgreSQL databases that run inside Docker containers, compress the files, and ship them off the server with restic.
Back up the WHMCS database automatically
Configure WHMCS daily database backups to email, FTP/SFTP or cPanel backups, add off-site copies, and restore WHMCS from a database backup when needed.
Clean up and optimise the WordPress database
Shrink and speed up a WordPress database: remove revisions, spam, transients and orphaned data, find large tables and autoloaded options, and optimise tables safely.
CloudLinux MySQL Governor explained: database limits on shared hosting
How CloudLinux MySQL Governor tracks and limits database usage per account, why heavy queries get restricted, and how to fix slow queries that hit the limits.
Connect MySQL Workbench, HeidiSQL or DBeaver to your VPS over SSH
Manage the MySQL or MariaDB database on your VPS from a desktop client through an SSH tunnel, without opening port 3306 to the internet.
Create a MySQL database and user in cPanel
Create a MySQL database, a database user and the right privileges in cPanel with the Database Wizard or Manage My Databases, then connect your app with the correct details.
Create and manage MySQL databases in Plesk with phpMyAdmin
Create a MySQL or MariaDB database and user in Plesk, open phpMyAdmin, import and export SQL dumps, allow remote access and repair tables.
Create MySQL databases and users in DirectAdmin
Create a MySQL database and user in DirectAdmin, manage privileges, open phpMyAdmin, import or export SQL dumps and allow remote MySQL hosts.
Docker Compose for WordPress: Nginx, PHP-FPM and MariaDB
Build a WordPress stack with Docker Compose using separate Nginx, PHP-FPM and MariaDB containers, a persistent wp-content volume and a free Let's Encrypt certificate.
Edit, delete, optimise and repair database tables in phpMyAdmin (cPanel)
Open phpMyAdmin from cPanel to edit rows, empty or drop tables, and run Optimize, Check and Repair table to reclaim space and fix crashed tables safely.
Enable MySQL TLS and Require Encrypted Connections
Enable TLS on MySQL or MariaDB, point the server at its certificate files, and force every client to connect over an encrypted channel.
Find and shrink large MySQL databases in cPanel
See which databases and tables use the most space in cPanel, clean logs, sessions, revisions and transients safely, then optimise tables to reclaim disk space.
Find High-Cost MySQL Queries with Performance Schema
Use MySQL Performance Schema to find the statements and wait events that consume the most time on your server, then confirm the fix with fresh measurements.
Find slow queries in MySQL with the slow query log
Turn on the MySQL slow query log, read it with mysqldumpslow and pt-query-digest, then use EXPLAIN to fix the queries that slow your app down.
Fix "Error establishing a database connection" in WordPress
Fix the WordPress database connection error: check wp-config.php credentials, the cPanel database user and privileges, repair tables and rule out server limits.
Fix MariaDB Authentication Plugin Errors After Upgrade
MariaDB upgrades often change how accounts authenticate, so logins that worked yesterday fail with plugin or access-denied errors. This guide shows how to check which plugin a user has and switch it safely.
Fix MySQL Charset and Collation Mismatches
Find where a MySQL charset or collation mismatch lives — server, database, table, column or connection — and fix it without corrupting your data.
Browse by topic
- Getting startedYour first hour with a new server: access, logins and basics.69 guides
- cPanelFiles, databases, email, domains and every cPanel tool, step by step.37 guides
- WHM & resellingWHM, packages, reseller accounts, WHMReseller and running a hosting brand.49 guides
- WordPressInstall, secure, speed up, migrate and fix WordPress sites.40 guides
- Email & webmailMailboxes, webmail, forwarders, spam filters and email delivery.37 guides
- DomainsRegistering, transferring and managing domains and nameservers.20 guides
- SSL certificatesFree AutoSSL, Let's Encrypt, paid certificates and HTTPS.19 guides
- CloudLinuxCloudLinux setup and use: LVE limits, CloudLinux Manager, CageFS and PHP/Node.js selectors.31 guides
- LiteSpeedLiteSpeed Web Server, LSCache and the LiteSpeed Cache plugin: install, settings and tuning.30 guides
- Imunify360Malware scanning, firewall and proactive defence with Imunify360.23 guides
- SoftaculousInstall, update, clone and back up apps with Softaculous.23 guides
- WP SquaredcPanel's WordPress platform: sites, plugins, staging and backups.9 guides
- SitePadBuild and publish websites with the SitePad builder.9 guides
- SitejetDesign, edit and publish sites with the Sitejet builder.9 guides
- WHMResellerAlpha and master resellers with WHMReseller: install, setup and use.12 guides
- VirtFusionInstall, set up and manage VirtFusion: hypervisors, packages, servers and WHMCS integration.7 guides
- VirtualizorManage your VPS with Virtualizor: power, OS reinstall, VNC, IPs and backups.30 guides
- PleskWebsites, email, databases and settings in the Plesk panel.52 guides
- DirectAdminUsers, domains, email and reseller tools in DirectAdmin.40 guides
- WHMCSBilling, automation, products and client management with WHMCS.51 guides
- Control panelscPanel & WHM, Plesk, DirectAdmin and other panels on your VPS.106 guides
- SecurityKeys, passwords, firewalls and keeping a server patched.115 guides
- Networking & DNSIP addresses, reverse DNS, ports and traffic.34 guides
- Websites & appsWeb servers, WordPress, PHP, Node.js, SSL and app hosting.52 guides
- DatabasesMySQL, MariaDB, PostgreSQL, Redis and MongoDB on a VPS.64 guides
- Billing & accountInvoices, renewals, the client area and your account.9 guides
- TroubleshootingWhen something is not working: checks and fixes.68 guides
- Linux VPSSSH, packages, services and everyday Linux administration.70 guides
- Windows VPS & RDPRemote Desktop, Windows Server settings and Admin RDP tips.58 guides
- Docker & DevOpsContainers, Git deploys, automation, monitoring and backups.58 guides
Still stuck?
Ask MdmHost AI for a quick answer, or open a ticket and our team will take a look. We are here 24/7.