{"id":13329,"date":"2025-12-20T10:58:48","date_gmt":"2025-12-20T05:28:48","guid":{"rendered":"https:\/\/www.youstable.com\/blog\/?p=13329"},"modified":"2025-12-20T10:58:50","modified_gmt":"2025-12-20T05:28:50","slug":"how-to-setup-mariadb-on-linux-server","status":"publish","type":"post","link":"https:\/\/www.youstable.com\/blog\/how-to-setup-mariadb-on-linux-server","title":{"rendered":"How to Setup MariaDB on Linux Server &#8211; Complete Guide"},"content":{"rendered":"\n<p><strong>To set up MariaDB on a Linux server<\/strong>, install the MariaDB server package, enable and start the service, run <code>mysql_secure_installation<\/code> to harden defaults, create a database and user with least-privilege, configure remote access and firewall rules if needed, and apply basic performance tuning for your workload.<\/p>\n\n\n\n<p>In this guide, you\u2019ll learn how to setup MariaDB on Linux Server step by step. We\u2019ll cover installation on Ubuntu\/Debian and RHEL-based distros, secure configuration, user and database creation, remote access, performance tuning, backups, and troubleshooting\u2014everything you need to deploy a production-ready MariaDB instance confidently.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"what-is-mariadb-and-why-use-it-on-linux\"><strong>What is MariaDB and Why Use it on Linux?<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"2848\" height=\"1600\" src=\"https:\/\/www.youstable.com\/blog\/wp-content\/uploads\/2025\/12\/image-74.png\" alt=\"What Is MariaDB and Why Use It on Linux?\" class=\"wp-image-13415\" srcset=\"https:\/\/www.youstable.com\/blog\/wp-content\/uploads\/2025\/12\/image-74.png 2848w, https:\/\/www.youstable.com\/blog\/wp-content\/uploads\/2025\/12\/image-74-150x84.png 150w\" sizes=\"auto, (max-width: 2848px) 100vw, 2848px\" \/><\/figure>\n\n\n\n<p>MariaDB is a high-performance, open-source relational database forked from MySQL, widely used for web apps, WordPress, and enterprise systems. It\u2019s drop-in compatible with most MySQL tooling while offering better licensing, new storage engines, and active community development\u2014making it a robust choice for Linux servers.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"prerequisites-and-system-requirements\"><strong>Prerequisites and System Requirements<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Linux server with sudo or root access (Ubuntu\/Debian, RHEL\/CentOS\/AlmaLinux\/Rocky, openSUSE).<\/li>\n\n\n\n<li>Updated package index and stable network connectivity.<\/li>\n\n\n\n<li>Open local port 3306 (or a custom port) if remote connections are required.<\/li>\n\n\n\n<li>Recommended: 1\u20132 GB RAM minimum for small workloads; more for production.<\/li>\n\n\n\n<li>Accurate system time via NTP for consistent replication and logs.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"quick-start-install-mariadb-on-popular-linux-distros\"><strong>Quick Start: Install MariaDB on Popular Linux Distros<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"ubuntu-debian\"><strong>Ubuntu \/ Debian<\/strong><\/h3>\n\n\n\n<p>Use the distribution packages for stable deployments. For newer features, you can use MariaDB\u2019s official repository, but distro packages are easier to maintain.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># Update package index\nsudo apt update\n\n# Install MariaDB Server and client\nsudo apt install -y mariadb-server mariadb-client\n\n# Enable and start service\nsudo systemctl enable mariadb\nsudo systemctl start mariadb\n\n# Verify status and version\nsystemctl status mariadb --no-pager\nmariadb --version<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"rhel-centos-almalinux-rocky-linux\"><strong>RHEL \/ CentOS \/ AlmaLinux \/ Rocky Linux<\/strong><\/h3>\n\n\n\n<p>On modern RHEL derivatives, use dnf. If AppStream provides an older version, consider the official MariaDB repository for a specific major version.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># Install from AppStream (example: RHEL 9\/AlmaLinux 9)\nsudo dnf install -y mariadb-server\n\n# Enable and start service\nsudo systemctl enable mariadb\nsudo systemctl start mariadb\n\n# Verify status and version\nsystemctl status mariadb --no-pager\nmysql --version<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"opensuse-sles\"><strong>openSUSE \/ SLES<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code># Install on openSUSE\nsudo zypper refresh\nsudo zypper install -y mariadb\n\n# Enable and start service\nsudo systemctl enable mariadb\nsudo systemctl start mariadb<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"secure-the-installation-mandatory\"><strong>Secure the Installation (Mandatory)<\/strong><\/h2>\n\n\n\n<p>Harden defaults immediately to reduce exposure, especially on internet-facing servers.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo mysql_secure_installation<\/code><\/pre>\n\n\n\n<p>Recommended answers during the script:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Set a strong root password (or switch to socket authentication if preferred).<\/li>\n\n\n\n<li>Remove anonymous users.<\/li>\n\n\n\n<li>Disallow remote root login.<\/li>\n\n\n\n<li>Remove test database.<\/li>\n\n\n\n<li>Reload privilege tables.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"mariadb-service-management\"><strong>MariaDB Service Management<\/strong><\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code># Check status\nsudo systemctl status mariadb\n\n# Start\/Stop\/Restart\nsudo systemctl start mariadb\nsudo systemctl stop mariadb\nsudo systemctl restart mariadb\n\n# Enable at boot\nsudo systemctl enable mariadb\n\n# View logs (systemd journal)\nsudo journalctl -u mariadb -e --no-pager<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"create-a-database-user-and-permissions\"><strong>Create a Database, User, and Permissions<\/strong><\/h2>\n\n\n\n<p>Use least-privilege accounts for apps. Avoid using <code>root<\/code> in application connection strings.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># Log in as root (socket auth on many distros)\nsudo mariadb\n\n# Or:\n# mysql -u root -p\n\n-- Inside the MariaDB shell:\nCREATE DATABASE appdb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;\nCREATE USER 'appuser'@'localhost' IDENTIFIED BY 'StrongP@ssw0rd!';\nGRANT ALL PRIVILEGES ON appdb.* TO 'appuser'@'localhost';\nFLUSH PRIVILEGES;\nEXIT;<\/code><\/pre>\n\n\n\n<p>Test the connection:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mariadb -u appuser -p -D appdb -e \"SELECT 1;\"<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"enable-remote-access-optional\"><strong>Enable Remote Access (Optional)<\/strong><\/h2>\n\n\n\n<p>By default, MariaDB listens on localhost. To allow remote connections, bind to a network interface, open the firewall, and grant remote user access. Only do this on trusted networks or over TLS.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"1-configure-bind-address\"><strong>1) Configure bind-address<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code># Edit the server config (path may vary):\nsudo nano \/etc\/mysql\/mariadb.conf.d\/50-server.cnf   # Ubuntu\/Debian\n# or\nsudo nano \/etc\/my.cnf.d\/server.cnf                  # RHEL derivatives\n\n# Set:\nbind-address = 0.0.0.0          # or a specific server IP\nport = 3306\n\n# Save, then:\nsudo systemctl restart mariadb<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"2-open-the-firewall\"><strong>2) Open the firewall<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code># UFW (Ubuntu)\nsudo ufw allow 3306\/tcp\nsudo ufw status\n\n# firewalld (RHEL family)\nsudo firewall-cmd --permanent --add-service=mysql\nsudo firewall-cmd --reload<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"3-grant-a-remote-user\"><strong>3) Grant a remote user<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo mariadb\n\n-- Replace 203.0.113.10 with your app server's IP or use '%'\nCREATE USER 'appuser'@'203.0.113.10' IDENTIFIED BY 'StrongP@ssw0rd!';\nGRANT ALL PRIVILEGES ON appdb.* TO 'appuser'@'203.0.113.10';\nFLUSH PRIVILEGES;\nEXIT;<\/code><\/pre>\n\n\n\n<p>For production, consider enabling SSL\/TLS for client connections and restricting by IP ranges instead of using the wildcard host <code>%<\/code>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"basic-performance-tuning\"><strong>Basic Performance Tuning<\/strong><\/h2>\n\n\n\n<p>MariaDB\u2019s defaults are conservative. Align memory and connection settings with your workload. Always backup before changes and apply incrementally.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>innodb_buffer_pool_size<\/strong>: 50\u201370% of RAM on dedicated DB servers.<\/li>\n\n\n\n<li><strong>max_connections<\/strong>: Set based on application concurrency and RAM.<\/li>\n\n\n\n<li><strong>query_cache<\/strong>: Deprecated in MariaDB 10.1+; avoid for most workloads.<\/li>\n\n\n\n<li><strong>tmp_table_size<\/strong> and <strong>max_heap_table_size<\/strong>: Increase for complex queries.<\/li>\n\n\n\n<li><strong>slow_query_log<\/strong>: Enable to identify expensive queries.<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code># Example: \/etc\/mysql\/mariadb.conf.d\/50-server.cnf (Debian\/Ubuntu)\n# or \/etc\/my.cnf.d\/server.cnf (RHEL)\n&#91;mysqld]\ninnodb_buffer_pool_size = 2G\nmax_connections = 200\nslow_query_log = 1\nslow_query_log_file = \/var\/log\/mysql\/mariadb-slow.log\nlong_query_time = 1\n\n# Apply changes\nsudo systemctl restart mariadb<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"backups-and-restores\"><strong>Backups and Restores<\/strong><\/h2>\n\n\n\n<p>Backups are non-negotiable. Use <code>mysqldump<\/code> for logical backups (portable, slower) or <code>mariabackup<\/code> for physical backups (faster, consistent, ideal for large datasets).<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"mysqldump-logical\"><strong>mysqldump (logical)<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code># Backup a single database\nmysqldump -u root -p --routines --triggers --single-transaction appdb &gt; appdb.sql\n\n# Restore\nmysql -u root -p appdb &lt; appdb.sql<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"mariabackup-physical\"><strong>mariabackup (physical)<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code># Install if not present\n# Ubuntu\/Debian package often: mariadb-backup; RHEL: MariaDB-backup\nsudo apt install -y mariadb-backup || sudo dnf install -y MariaDB-backup\n\n# Full backup\nmariabackup --backup --target-dir=\/backups\/full-$(date +%F) --user=root --password\n\n# Prepare and restore\nmariabackup --prepare --target-dir=\/backups\/full-2025-01-01\nsudo systemctl stop mariadb\nsudo rsync -a \/backups\/full-2025-01-01\/ \/var\/lib\/mysql\/\nsudo chown -R mysql:mysql \/var\/lib\/mysql\nsudo systemctl start mariadb<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"monitoring-and-logs\"><strong>Monitoring and Logs<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Error log<\/strong>: Usually at <code>\/var\/log\/mysql\/error.log<\/code> or <code>\/var\/log\/mariadb\/mariadb.log<\/code>.<\/li>\n\n\n\n<li><strong>Systemd journal<\/strong>: <code>journalctl -u mariadb -e<\/code>.<\/li>\n\n\n\n<li><strong>Slow query log<\/strong>: Analyze with <code>pt-query-digest<\/code> (Percona toolkit) or manual review.<\/li>\n\n\n\n<li><strong>Metrics<\/strong>: Consider Prometheus exporters or <code>mysqladmin status<\/code> for quick checks.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"common-errors-and-quick-fixes\"><strong>Common Errors and Quick Fixes<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Can\u2019t connect (ECONNREFUSED)<\/strong>: Ensure <code>bind-address<\/code> is correct, service is running, and firewall allows the port.<\/li>\n\n\n\n<li><strong>Access denied<\/strong>: Check user host (e.g., <code>@'localhost'<\/code> vs <code>@'%'<\/code>), password, and <code>FLUSH PRIVILEGES<\/code>.<\/li>\n\n\n\n<li><strong>Port in use<\/strong>: Verify no other service is listening on 3306; change <code>port<\/code> if needed.<\/li>\n\n\n\n<li><strong>SELinux\/AppArmor blocks<\/strong>: Permit MariaDB to bind network ports and read the data directory.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"selinux-and-apparmor-considerations\"><strong>SELinux and AppArmor Considerations<\/strong><\/h2>\n\n\n\n<p>On RHEL-based systems with SELinux enforcing, use appropriate booleans and contexts rather than disabling SELinux.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># Allow network connections if needed\nsudo setsebool -P mysql_connect_any 1\n\n# If moving data directory, relabel\nsudo semanage fcontext -a -t mysqld_db_t \"\/data\/mysql(\/.*)?\"\nsudo restorecon -Rv \/data\/mysql<\/code><\/pre>\n\n\n\n<p>On Ubuntu, if AppArmor profiles restrict MariaDB, adjust <code>\/etc\/apparmor.d\/usr.sbin.mysqld<\/code> to permit new paths and reload the profile.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"migrating-the-data-directory-optional\"><strong>Migrating the Data Directory (Optional)<\/strong><\/h2>\n\n\n\n<p>If you need storage on a larger disk, move <code>\/var\/lib\/mysql<\/code> safely.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo systemctl stop mariadb\nsudo rsync -av \/var\/lib\/mysql\/ \/data\/mysql\/\nsudo chown -R mysql:mysql \/data\/mysql\n\n# Update the config (server.cnf)\n&#91;mysqld]\ndatadir = \/data\/mysql\nsocket  = \/data\/mysql\/mysql.sock\n\n# Update AppArmor\/SELinux contexts as needed (see prior section)\nsudo systemctl start mariadb<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"integrate-with-web-stacks-lamp-lemp-and-wordpress\"><strong>Integrate with Web Stacks (LAMP\/LEMP) and WordPress<\/strong><\/h2>\n\n\n\n<p>MariaDB is a drop-in backend for PHP applications and WordPress. Create a dedicated database and user per site, store credentials in your application\u2019s config, and restrict privileges to that database only. For WordPress, ensure UTF8MB4 encoding for full emoji and multilingual support.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"when-to-consider-managed-hosting\"><strong>When to Consider Managed Hosting<\/strong><\/h2>\n\n\n\n<p>If you prefer focusing on your application instead of database administration, consider a managed server or VPS with expert support. At YouStable, our hosting engineers can provision, harden, and monitor MariaDB for you, apply performance tuning, and set up automated backups\u2014so your stack stays stable under load.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"best-practices-summary\"><strong>Best Practices Summary<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use the latest stable MariaDB available from your distro or the official repo.<\/li>\n\n\n\n<li>Run <code>mysql_secure_installation<\/code> immediately after install.<\/li>\n\n\n\n<li>Create least-privilege users per application and avoid remote root logins.<\/li>\n\n\n\n<li>Enable slow query logging and tune based on evidence.<\/li>\n\n\n\n<li>Automate backups and test restores periodically.<\/li>\n\n\n\n<li>Restrict network access, enforce SSL\/TLS, and monitor logs\/metrics.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"faqs-how-to-setup-mariadb-on-linux-server\"><strong>FAQs: How to Setup MariaDB on Linux Server<\/strong><\/h2>\n\n\n<div id=\"rank-math-faq\" class=\"rank-math-block\">\n<div class=\"rank-math-list \">\n<div id=\"faq-question-1765794206071\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \" class=\"rank-math-question \" id=\"how-do-i-check-my-mariadb-version-on-linux\"><strong>How do I check my MariaDB version on Linux?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Run <code>mariadb --version<\/code> or <code>mysql --version<\/code> in the terminal. Inside the MariaDB shell, run <code>SELECT VERSION();<\/code> to confirm the exact server version running.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1765794217881\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \" class=\"rank-math-question \" id=\"whats-the-difference-between-mariadb-and-mysql\"><strong>What\u2019s the difference between MariaDB and MySQL?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>MariaDB is a community-driven fork of MySQL with open licensing, frequent updates, additional storage engines, and broad MySQL compatibility. Many commands and clients are interchangeable, making migration straightforward for most workloads.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1765794226028\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \" class=\"rank-math-question \" id=\"how-do-i-allow-remote-connections-securely\"><strong>How do I allow remote connections securely?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Set <code>bind-address<\/code> to a reachable IP, open port 3306 in your firewall, create a user bound to the client\u2019s IP, and enable SSL\/TLS. Avoid using <code>%<\/code> for hosts in production and consider VPN or SSH tunnels for added security.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1765794234378\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \" class=\"rank-math-question \" id=\"how-can-i-change-or-reset-the-mariadb-root-password\"><strong>How can I change or reset the MariaDB root password?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>If you have access, run <code>sudo mariadb<\/code> and use <code>ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPass'<\/code>. If locked out, start MariaDB with <code>--skip-grant-tables<\/code> temporarily, reset the password, then restart normally and run <code>FLUSH PRIVILEGES<\/code>.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1765794243161\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \" class=\"rank-math-question \" id=\"how-do-i-upgrade-mariadb-safely-on-linux\"><strong>How do I upgrade MariaDB safely on Linux?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Back up databases first, read the MariaDB release notes, then upgrade via your package manager (<code>apt<\/code> or <code>dnf<\/code>). After upgrade, check logs, run <code>mysql_upgrade<\/code> if prompted, and verify application compatibility in a staging environment before production rollout.<\/p>\n\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"conclusion\"><strong>Conclusion<\/strong><\/h2>\n\n\n\n<p>Setting up MariaDB on a Linux server is straightforward: install, secure, create least-privilege users, and tune based on real metrics. With disciplined backups and monitoring, you get a stable, scalable database for WordPress and modern web apps. Need hands-off reliability? YouStable can provision, optimize, and manage MariaDB so you can focus on growth.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To set up MariaDB on a Linux server, install the MariaDB server package, enable and start the service, run mysql_secure_installation [&hellip;]<\/p>\n","protected":false},"author":13,"featured_media":15503,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[350],"tags":[],"class_list":["post-13329","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-knowledgebase"],"acf":[],"featured_image_src":"https:\/\/www.youstable.com\/blog\/wp-content\/uploads\/2025\/12\/How-to-Setup-MariaDB-on-Linux-Server.jpg","author_info":{"display_name":"Prahlad Prajapati","author_link":"https:\/\/www.youstable.com\/blog\/author\/prahladblog"},"_links":{"self":[{"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/posts\/13329","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/comments?post=13329"}],"version-history":[{"count":4,"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/posts\/13329\/revisions"}],"predecessor-version":[{"id":15504,"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/posts\/13329\/revisions\/15504"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/media\/15503"}],"wp:attachment":[{"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/media?parent=13329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/categories?post=13329"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/tags?post=13329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}