Guides tagged “mysql”
Step-by-step MdmHost guides about mysql, sorted A-Z.
53 guides · page 3 of 3
Reset a Forgotten MySQL Root Password on Linux
Recover access to MySQL or MariaDB on a Linux VPS by starting the server with skip-grant-tables, setting a new root password and restarting normally.
Restore a MySQL Database from a mysqldump File
Load a.sql or.sql.gz dump back into MySQL or MariaDB on your Linux VPS with the mysql command, including charset options and fixes for the usual import errors.
Restore a MySQL database from JetBackup 5 in cPanel
Roll a WordPress or shop database back to an earlier day with JetBackup 5 in cPanel, download a database dump, and restore files and database together safely.
Restore MariaDB from a mariabackup Backup
Restore MariaDB from a mariabackup backup on a Linux VPS: stop the server, prepare the backup files, copy them back into the data directory, fix ownership and start MariaDB again.
Self-host Nextcloud with Docker Compose, MariaDB and Redis
Run Nextcloud, MariaDB and Redis as containers on one Linux VPS. Build the compose file, set trusted domains and verify the stack end to end.
Set Up a MariaDB Galera Cluster on Multiple VPSs
Install MariaDB with the Galera provider on three Linux VPSs, configure wsrep, bootstrap the first node and confirm every node reports Synced.
Set Up MySQL Primary-Replica Replication on a Linux VPS
GTID-based MySQL replication between two Linux VPS: set server-id and binary logging on the primary, take a consistent snapshot, then point the replica at it and verify.
Troubleshoot MySQL Replication Lag and Broken Replicas
Measure MySQL replication lag, read SHOW REPLICA STATUS, clear SQL thread errors and resync a replica that has fallen too far behind to catch up.
Troubleshooting MySQL deadlocks and transaction failures
Diagnose MySQL deadlocks and transaction failures using the InnoDB deadlock report, live lock queries and safer transaction ordering.
Tune MySQL and MariaDB memory settings for a small VPS
Set innodb_buffer_pool_size, max_connections and other my.cnf values so MySQL or MariaDB fits the RAM on your Linux VPS and stops swapping.
Tune MySQL InnoDB Buffer Pool Size for a VPS
Measure your InnoDB buffer pool hit rate, choose a size that fits your VPS memory, and apply innodb_buffer_pool_size safely in my.cnf.
Upgrade MySQL or MariaDB on a cPanel server in WHM (root guide)
Safely upgrade MySQL or MariaDB on cPanel as root with WHM's MySQL/MariaDB Upgrade tool: version choice, backups, compatibility checks, running the upgrade and rollback planning.
Where is my.cnf? MySQL and MariaDB config files explained
Find the MySQL or MariaDB config files on Ubuntu, Debian, AlmaLinux and Rocky Linux, learn the order they load in, and confirm which settings are really active.
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.