Guides tagged “mariadb”
Step-by-step MdmHost guides about mariadb, sorted A-Z.
23 guides · page 1 of 2
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.
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.
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 WordPress on OpenLiteSpeed with LSCache
Install WordPress on OpenLiteSpeed with the right LSPHP extensions, a MariaDB database and a dedicated virtual host, then turn on the LiteSpeed Cache plugin and confirm cache hits in the response headers.
Install a LAMP stack by hand (Apache, MariaDB, PHP) on AlmaLinux or Ubuntu
Build a LAMP server without a control panel: install Apache, MariaDB and PHP on AlmaLinux 9 or Ubuntu 24.04, create a virtual host, secure it and add free SSL.
Install a LEMP stack by hand (Nginx, MariaDB, PHP-FPM) on Ubuntu or AlmaLinux
Build a fast LEMP server: install Nginx, MariaDB and PHP-FPM on Ubuntu 24.04 or AlmaLinux 9, write a server block for PHP apps, secure it and add Let's Encrypt SSL.
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 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 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.
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.
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.