Guides tagged “mariadb”
Step-by-step MdmHost guides about mariadb, sorted A-Z.
38 guides · page 2 of 2
Install PrestaShop on a Linux VPS with Nginx and PHP-FPM
Set up PrestaShop 8 on an Ubuntu or AlmaLinux VPS with Nginx, PHP-FPM and MariaDB, including the right PHP extensions, an Nginx config, SSL and post-install security.
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.
Install WordPress on a Linux VPS with Nginx (LEMP)
Install WordPress on your own VPS: PHP-FPM and extensions, a MariaDB database, WP-CLI download, an Nginx server block with security rules, SSL, real cron and caching.
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.
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 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.
Reset a forgotten MySQL or MariaDB root password
Regain access to MySQL 8 or MariaDB when the root password is lost: check socket login first, then use skip-grant-tables safely and set a new password.
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.
Run WordPress with Docker Compose: WordPress, MariaDB and Redis
Build a WordPress stack with Docker Compose: MariaDB, Redis object cache, persistent volumes, environment secrets, a reverse proxy with SSL and simple backups.
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 separate MySQL/MariaDB database server for your web servers
Move the database to its own server: bind MariaDB to a private IP, create users restricted to app servers, firewall port 3306, enable TLS and connect your application.
Set up MySQL or MariaDB primary-replica replication
Configure asynchronous primary-replica replication with GTIDs on MySQL 8 or MariaDB, seed the replica from a dump, and monitor and repair replication.
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 and MariaDB performance on a VPS
Size the InnoDB buffer pool, connections and logs for your VPS RAM, find slow queries and add indexes so MySQL or MariaDB stops being the bottleneck.
Upgrade MariaDB or MySQL to a new major version safely
Plan and run a MariaDB or MySQL major version upgrade on a Linux VPS: check compatibility, back up, switch repositories, upgrade packages and verify the result.
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.83 guides
- cPanelFiles, databases, email, domains and every cPanel tool, step by step.67 guides
- WHM & resellingWHM, packages, reseller accounts, WHMReseller and running a hosting brand.53 guides
- WordPressInstall, secure, speed up, migrate and fix WordPress sites.49 guides
- Email & webmailMailboxes, webmail, forwarders, spam filters and email delivery.67 guides
- DomainsRegistering, transferring and managing domains and nameservers.27 guides
- SSL certificatesFree AutoSSL, Let's Encrypt, paid certificates and HTTPS.41 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.35 guides
- Imunify360Malware scanning, firewall and proactive defence with Imunify360.24 guides
- SoftaculousInstall, update, clone and back up apps with Softaculous.24 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.28 guides
- VirtualizorManage your VPS with Virtualizor: power, OS reinstall, VNC, IPs and backups.44 guides
- PleskWebsites, email, databases and settings in the Plesk panel.53 guides
- DirectAdminUsers, domains, email and reseller tools in DirectAdmin.41 guides
- WHMCSBilling, automation, products and client management with WHMCS.52 guides
- Control panelscPanel & WHM, Plesk, DirectAdmin and other panels on your VPS.107 guides
- SecurityKeys, passwords, firewalls and keeping a server patched.138 guides
- Networking & DNSIP addresses, reverse DNS, ports and traffic.72 guides
- Websites & appsWeb servers, WordPress, PHP, Node.js, SSL and app hosting.83 guides
- DatabasesMySQL, MariaDB, PostgreSQL, Redis and MongoDB on a VPS.80 guides
- Billing & accountInvoices, renewals, the client area and your account.9 guides
- TroubleshootingWhen something is not working: checks and fixes.127 guides
- Linux VPSSSH, packages, services and everyday Linux administration.265 guides
- Windows VPS & RDPRemote Desktop, Windows Server settings and Admin RDP tips.73 guides
- Docker & DevOpsContainers, Git deploys, automation, monitoring and backups.82 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.