Guides tagged “mysql”
Step-by-step MdmHost guides about mysql, sorted A-Z.
53 guides · page 2 of 3
Fix MySQL or MariaDB error 1045: Access denied for user
Error 1045 means MySQL or MariaDB rejected the login. Find which user and host the client asked for, fix the password or grants, and reset a lost root password safely.
Fix MySQL Socket Error: Can't Connect to Local Server
ERROR 2002 means the MySQL client could not reach the server over its Unix socket. Check the service, find the real socket path, and fix the client config.
Fix MySQL Too Many Connections Errors
Diagnose MySQL error 1040, find which clients are holding connections open, raise max_connections safely and tune wait_timeout to stop the leak coming back.
How to back up and restore MySQL databases with mysqldump
Back up one or all MySQL and MariaDB databases with mysqldump, keep InnoDB dumps consistent, compress them with gzip, and restore them safely with the mysql client.
How to check database and table sizes in MySQL and MariaDB
Find out how much space each MySQL or MariaDB database and table uses, spot the biggest tables, and compare the numbers with real disk use on your VPS.
How to create a database and user for a web app in MySQL or MariaDB
Set up a utf8mb4 database and a dedicated user with a strong password for WordPress, Laravel or any web app, then test the login before you configure the app.
How to create a MySQL user and grant privileges
Create MySQL and MariaDB user accounts, understand the host part, grant only the rights each app needs, and review, revoke or drop access safely.
How to install MariaDB on AlmaLinux and Rocky Linux
Install MariaDB on AlmaLinux or Rocky Linux 8 and 9 from AppStream or the official MariaDB repository, secure it, enable the service and handle SELinux.
How to install MySQL 8.4 on Ubuntu and Debian
Install MySQL on Ubuntu or Debian from the distribution packages or the official MySQL APT repository, secure it and make your first connection.
Import a Large MySQL SQL File Without Timeouts
Import a large MySQL dump from the command line without phpMyAdmin timeouts. Raise packet limits, split oversized files and verify the result.
Import and export a MySQL database with phpMyAdmin in cPanel
Use phpMyAdmin in cPanel to export a database to an .sql file, import a backup, run queries, and handle large files or upload size errors.
Install and configure MySQL Governor on CloudLinux (root guide)
Install CloudLinux MySQL Governor on a cPanel server as root, choose the right database version, set the mode and per-user limits, and monitor restricted users with dbtop.
Install and secure MariaDB or MySQL, and allow remote access safely
Install MariaDB (or MySQL), lock it down, create a least-privilege app user, and connect remotely the safe way: an SSH tunnel or a single allowed IP.
Install WordPress on a LEMP stack (Nginx, MariaDB, PHP)
Build a LEMP stack on Ubuntu or Debian, create the database, configure wp-config.php and Nginx for PHP-FPM, then finish the WordPress installer over HTTPS.
Manage MySQL databases and users in cPanel: create, rename, grant and delete
Use cPanel MySQL Databases to create databases and users, assign the right privileges, rename or delete databases safely, and fix common access denied errors.
MySQL command-line cheat sheet for server admins
The MySQL and MariaDB commands you use most on a VPS, from logging in and listing databases to finding slow queries, killing them and checking server status.
MySQL Point-in-Time Recovery Using Binary Logs
Recover a MySQL or MariaDB database to an exact moment after a bad write or dropped table by restoring a full backup and replaying binary logs up to the incident.
MySQL vs MariaDB: which to use on your VPS
Compare MySQL and MariaDB on compatibility, licensing, features, release support and app support, so you can choose the right database for your VPS.
Optimize MySQL Indexes with Composite and Covering Indexes
Learn how to design MySQL composite and covering indexes for WHERE, JOIN and ORDER BY queries, then verify the plan with EXPLAIN and EXPLAIN ANALYZE.
Repair Corrupted MySQL InnoDB Tables on a Linux VPS
Confirm InnoDB corruption with CHECK TABLE, start MySQL with innodb_force_recovery to dump readable data, then rebuild the tables from that dump.
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.