Guides tagged “database”
Step-by-step MdmHost guides about database, sorted A-Z.
93 guides · page 3 of 5
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 and secure Redis on a Linux VPS
Install Redis on Ubuntu, Debian, AlmaLinux or Rocky Linux, keep it on localhost, require a password or ACL user, and run it under systemd.
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 MongoDB on Ubuntu and secure it
Install MongoDB on Ubuntu from the official repository, enable authentication, create an admin user, and restrict access with bindIp and UFW.
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 PostgreSQL and create your first database
Install PostgreSQL, create a role and database for your app, enable password logins, connect remotely without exposing the port, and take backups with pg_dump.
Install Redis and Secure It with a Password
Install Redis on Ubuntu, Debian, AlmaLinux or Rocky Linux, set a password with requirepass, and confirm the server rejects unauthenticated commands.
Install SQL Server Express on a Windows VPS
Install SQL Server Express and SSMS, create a database and app login, and allow remote connections only from your own IP address.
Install the latest PostgreSQL from the official PGDG repository
Add the PostgreSQL project's own apt or dnf repository to get a current major version on Ubuntu, Debian, AlmaLinux or Rocky Linux, and run more than one version side by side.
Install WordPress manually in cPanel
Install WordPress by hand in cPanel: upload the core files, create a MySQL database and user, run the installer and lock the site down afterwards.
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 database servers in Plesk: local, remote, MariaDB and PostgreSQL
Add local or remote MySQL, MariaDB and PostgreSQL servers in Plesk, set the default database server, change the admin password and upgrade MariaDB safely.
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.
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.