{"id":13227,"date":"2025-12-16T11:14:10","date_gmt":"2025-12-16T05:44:10","guid":{"rendered":"https:\/\/www.youstable.com\/blog\/?p=13227"},"modified":"2025-12-16T11:14:12","modified_gmt":"2025-12-16T05:44:12","slug":"use-mariadb-on-linux","status":"publish","type":"post","link":"https:\/\/www.youstable.com\/blog\/use-mariadb-on-linux","title":{"rendered":"How to Use MariaDB on Linux Server in 2026? &#8211; (Step by Step Tutorial)"},"content":{"rendered":"\n<p><strong>To use MariaDB on a Linux server<\/strong>, install it from your distro\u2019s repositories, start and enable the mariadb service, run mysql_secure_installation to harden access, create a database and a user with least privilege, and connect via the mysql client. <\/p>\n\n\n\n<p>For production, configure backups, remote access, and basic performance tuning. Learning how to <strong>use MariaDB on Linux server<\/strong> environments is essential for hosting websites, applications, analytics, and internal tools. <\/p>\n\n\n\n<p>This guide walks you through installation, security, basic SQL operations, remote connections, backups, and performance tuning with practical commands you can copy-paste. <\/p>\n\n\n\n<p>It\u2019s beginner friendly and production aware, based on real world hosting experience.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-default\"\/>\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<p><strong>MariaDB is a high-performance, open source<\/strong> relational database management system (RDBMS) that\u2019s a drop in replacement for MySQL.<\/p>\n\n\n\n<p>It\u2019s widely used across <strong>LAMP\/LEMP<\/strong> stacks, supports advanced storage engines, and ships with enterprise grade features for replication, security, and scalability. On Linux servers, it\u2019s stable, fast, and well supported by package managers.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"prerequisites\"><strong>Prerequisites<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A Linux server <strong>(Ubuntu\/Debian, Rocky\/AlmaLinux\/CentOS, RHEL, SUSE, Arch)<\/strong> with sudo access<\/li>\n\n\n\n<li>Open ports as needed <strong>(3306\/TCP for remote access)<\/strong><\/li>\n\n\n\n<li>Basic terminal familiarity<\/li>\n\n\n\n<li>Package manager configured and system up to date<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-default\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"install-mariadb-on-popular-linux-distributions\"><strong>Install MariaDB on Popular Linux Distributions<\/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<pre class=\"wp-block-code\"><code>sudo apt update\nsudo apt install mariadb-server mariadb-client\nmysql --version<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"rocky-linux-almalinux-centos-rhel\"><strong>Rocky Linux \/ AlmaLinux \/ CentOS \/ RHEL<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code># RHEL 8+\/Rocky\/Alma\nsudo dnf install mariadb-server mariadb\n# RHEL\/CentOS 7 (legacy)\nsudo yum install mariadb-server mariadb\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>sudo zypper refresh\nsudo zypper install mariadb mariadb-client\nmysql --version<\/code><\/pre>\n\n\n\n<p>For newer major versions, you can also use the official MariaDB repository. Always ensure the repo matches your distro version.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"start-enable-and-verify-the-service\"><strong>Start, Enable, and Verify the Service<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo systemctl enable --now mariadb\nsudo systemctl status mariadb\nsudo ss -tulpn | grep 3306   # Confirm listening port\nsudo mysqladmin ping<\/code><\/pre>\n\n\n\n<p>If your distro uses the mysql service name, replace mariadb with mysql. Most modern systems alias it to mariadb.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"secure-mariadb-mysql_secure_installation\"><strong>Secure MariaDB (mysql_secure_installation)<\/strong><\/h3>\n\n\n\n<p>Run the bundled hardening script to set a root password, remove anonymous users, disallow remote root login, and clean up test databases.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo mysql_secure_installation\n# Steps typically include:\n# - Set root password (if prompted)\n# - Remove anonymous users\n# - Disallow root login remotely\n# - Remove test database\n# - Reload privilege tables<\/code><\/pre>\n\n\n\n<p>On some distros, the root user authenticates via the unix_socket plugin. If so, run sudo mysql without a password for root-level access locally.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"connect-and-run-basic-sql\"><strong>Connect and Run Basic SQL<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code># Connect as root (password auth)\nmysql -u root -p\n\n# Or, if using unix_socket\nsudo mysql<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>-- Inside the MariaDB shell:\nSHOW VARIABLES LIKE 'version%';\nCREATE DATABASE appdb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;\n\n-- Create least-privilege user for the app\nCREATE USER 'appuser'@'localhost' IDENTIFIED BY 'StrongP@ss!';\nGRANT ALL PRIVILEGES ON appdb.* TO 'appuser'@'localhost';\nFLUSH PRIVILEGES;\n\n-- Test access\nEXIT;\nmysql -u appuser -p -D appdb -e \"SHOW TABLES;\"<\/code><\/pre>\n\n\n\n<p>Use utf8mb4 for full Unicode (including emoji) support. Always create a dedicated user per application instead of using root.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-default\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"import-export-and-backups\"><strong>Import, Export, and Backups<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"logical-backups-with-mysqldump\"><strong>Logical backups with mysqldump<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code># Dump 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\n\n# Dump all databases\nmysqldump -u root -p --all-databases --single-transaction &gt; all.sql<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"physical-backups-with-mariabackup-hot-backups\"><strong>Physical backups with mariabackup (hot backups)<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code># Install mariabackup if not present (package name may vary by distro)\n# Example (Debian\/Ubuntu): sudo apt install mariadb-backup\n\n# Create a backup\nsudo mariabackup --backup --target-dir=\/var\/backups\/mariadb\/$(date +%F) --user=root --password=YOURPASS\n\n# Prepare the backup (roll forward)\nsudo mariabackup --prepare --target-dir=\/var\/backups\/mariadb\/2025-01-01\n\n# Restore (service must be stopped)\nsudo systemctl stop mariadb\nsudo mariabackup --copy-back --target-dir=\/var\/backups\/mariadb\/2025-01-01\nsudo chown -R mysql:mysql \/var\/lib\/mysql\nsudo systemctl start mariadb<\/code><\/pre>\n\n\n\n<p>Schedule backups with cron and test restores periodically. Store copies off-server to meet RPO\/RTO goals.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-default\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"allow-remote-access-optional\"><strong>Allow Remote Access (Optional)<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"edit-bind-address-and-create-a-remote-user\"><strong>Edit bind address and create a remote user<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code># Edit server config (path may vary)\nsudo nano \/etc\/mysql\/mariadb.conf.d\/50-server.cnf   # Debian\/Ubuntu\n# or: \/etc\/my.cnf.d\/server.cnf or \/etc\/my.cnf\n\n# Set to listen on all interfaces or a specific IP\nbind-address = 0.0.0.0\n# Save file, then restart\nsudo systemctl restart mariadb<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code># Create a remote user (replace 203.0.113.10 with your app server's IP)\nsudo mysql -e \"CREATE USER 'appuser'@'203.0.113.10' IDENTIFIED BY 'StrongP@ss!';\"\nsudo mysql -e \"GRANT ALL PRIVILEGES ON appdb.* TO 'appuser'@'203.0.113.10'; FLUSH PRIVILEGES;\"<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"open-the-firewall-and-test\"><strong>Open the firewall and test<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code># UFW (Ubuntu)\nsudo ufw allow 3306\/tcp\n\n# firewalld (RHEL\/Alma\/Rocky)\nsudo firewall-cmd --permanent --add-service=mysql\nsudo firewall-cmd --reload\n\n# Test from remote host\nmysql -h your.mariadb.ip -u appuser -p -D appdb -e \"SELECT 1;\"<\/code><\/pre>\n\n\n\n<p>For production, use strong passwords, restrict by source IP, and prefer TLS-encrypted connections (ssl_cert, ssl_key, ssl_ca). Avoid remote root logins.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-default\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"performance-basics-safe-defaults-that-matter\"><strong>Performance Basics: Safe Defaults That Matter<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>innodb_buffer_pool_size:<\/strong> 50\u201370% of server RAM (for dedicated DB hosts)<\/li>\n\n\n\n<li><strong>innodb_log_file_size:<\/strong> suitable for your workload (often 512M\u20132G)<\/li>\n\n\n\n<li><strong>max_connections:<\/strong> right-size to app concurrency<\/li>\n\n\n\n<li><strong>slow_query_log + long_query_time:<\/strong> identify queries to index or optimize<\/li>\n\n\n\n<li>tmpdir on fast storage if heavy temp usage<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code># Example snippet (my.cnf or server.cnf)\n&#91;mysqld]\ninnodb_buffer_pool_size=4G\ninnodb_log_file_size=1G\nmax_connections=300\nslow_query_log=1\nslow_query_log_file=\/var\/log\/mysql\/mariadb-slow.log\nlong_query_time=1<\/code><\/pre>\n\n\n\n<p>Restart MariaDB after changes and monitor memory utilization. Focus on indexing and query design for the biggest gains.<\/p>\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>Service health:<\/strong> <code>systemctl status mariadb<\/code>, <code>journalctl -u mariadb<\/code><\/li>\n\n\n\n<li><strong>Runtime:<\/strong> <code>SHOW PROCESSLIST;<\/code>, <code>SHOW ENGINE INNODB STATUS\\G<\/code><\/li>\n\n\n\n<li><strong>Admin stats:<\/strong> <code>mysqladmin status<\/code>, <code>mysqladmin variables<\/code><\/li>\n\n\n\n<li>Slow query log review to optimize indexes and queries<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"mariadb-vs-mysql-quick-practical-notes\"><strong>MariaDB vs MySQL (Quick Practical Notes)<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Compatibility:<\/strong> MariaDB aims to be a drop-in replacement for MySQL, but features diverge at higher versions.<\/li>\n\n\n\n<li><strong>Performance\/Features:<\/strong> MariaDB offers multiple storage engines and fast improvements; validate compatibility when migrating.<\/li>\n\n\n\n<li><strong>Tools:<\/strong> mysql client and mysqldump work similarly; some plugins and auth methods differ.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-default\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"troubleshooting-common-issues\"><strong>Troubleshooting Common Issues<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"cant-log-in-as-root-after-install\"><strong>Can\u2019t log in as root after install<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Try socket auth:<\/strong> <code>sudo mysql<\/code><\/li>\n\n\n\n<li><strong>Check auth plugin:<\/strong> <code>SELECT user, host, plugin FROM mysql.user;<\/code><\/li>\n\n\n\n<li><strong>Set a password if needed:<\/strong> <code>ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewP@ss!';<\/code><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"service-fails-to-start\"><strong>Service fails to start<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Check logs:<\/strong> <code>journalctl -u mariadb -xe<\/code><\/li>\n\n\n\n<li><strong>Verify data dir permissions:<\/strong> <code>chown -R mysql:mysql \/var\/lib\/mysql<\/code><\/li>\n\n\n\n<li><strong>Port conflicts:<\/strong> confirm 3306 is free; update <code>port<\/code> in configs if needed.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"remote-connection-refused\"><strong>Remote connection refused<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Confirm bind-address allows remote access<\/li>\n\n\n\n<li>Ensure firewall opens 3306\/TCP<\/li>\n\n\n\n<li>Grant privileges to the correct host (IP or %)<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"real-world-best-practices\"><strong>Real World Best Practices<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use separate users per application with least privileges.<\/li>\n\n\n\n<li>Standardize utf8mb4 for new databases and tables.<\/li>\n\n\n\n<li>Automate nightly backups and test restores quarterly.<\/li>\n\n\n\n<li>Capture slow queries and index iteratively.<\/li>\n\n\n\n<li>Keep your OS and MariaDB packages updated with change windows.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"where-mariadb-fits-in-your-stack\"><strong>Where MariaDB Fits in Your Stack<\/strong><\/h2>\n\n\n\n<p>MariaDB powers CMS platforms <strong>(WordPress, Joomla, Drupal)<\/strong>, ecommerce (WooCommerce), CRMs, and internal microservices. Pair it with NGINX\/Apache and PHP-FPM, Node.js, Python, or Go. For heavy workloads, isolate the DB on its own VM or server and scale reads with replicas.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"managed-option-focus-on-your-app-not-the-database\"><strong>Managed Option: Focus on Your App, Not the Database<\/strong><\/h2>\n\n\n\n<p>If you\u2019d rather not manage patches, backups, and tuning yourself, <a href=\"https:\/\/www.youstable.com\/blog\/advantages-of-dedicated-server\/\">YouStable offers optimized VPS and dedicated servers<\/a> with MariaDB-ready images, <strong>24\/7 support<\/strong>, and best-practice hardening. We help you size hardware, secure remote access, and set up automated backups so you can ship features faster.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-default\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"faqs\"><strong>FAQ<\/strong>&#8216;<strong>s<\/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-1765790270287\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \" class=\"rank-math-question \" id=\"how-do-i-install-mariadb-on-ubuntu-and-secure-it\"><strong>How do I install MariaDB on Ubuntu and secure it?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Run sudo apt update &amp;&amp; sudo apt install mariadb-server, then sudo systemctl enable &#8211;now mariadb. Secure it with sudo mysql_secure_installation to set root password, remove anonymous users, disable remote root, and reload privileges.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1765790278737\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \" class=\"rank-math-question \" id=\"whats-the-fastest-way-to-create-a-database-and-user\"><strong>What\u2019s the fastest way to create a database and user?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Connect as root and run: CREATE DATABASE appdb CHARACTER SET utf8mb4; CREATE USER &#8216;appuser&#8217;@&#8217;localhost&#8217; IDENTIFIED BY &#8216;StrongP@ss!&#8217;; GRANT ALL PRIVILEGES ON appdb.* TO &#8216;appuser&#8217;@&#8217;localhost&#8217;; FLUSH PRIVILEGES; Then test with mysql -u appuser -p -D appdb.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1765790285675\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \" class=\"rank-math-question \" id=\"how-can-i-allow-remote-connections-safely\"><strong>How can I allow remote connections safely?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Set bind-address to 0.0.0.0 or the server\u2019s IP, create a user restricted to your app server\u2019s IP, open port 3306 in the firewall, and prefer TLS. Never allow remote root, and avoid using % unless necessary.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1765790292925\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \" class=\"rank-math-question \" id=\"what-backup-method-should-i-use-mysqldump-or-mariabackup\"><strong>What backup method should I use: mysqldump or mariabackup?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Use mysqldump for smaller databases and portability (logical backups). Use mariabackup for large, busy databases requiring hot, consistent physical backups and faster restores. Many teams use both for defense in depth.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1765790300631\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \" class=\"rank-math-question \" id=\"which-mariadb-settings-should-i-tune-first-on-a-new-server\"><strong>Which MariaDB settings should I tune first on a new server?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Start with innodb_buffer_pool_size (50\u201370% RAM for dedicated DB hosts), enable slow_query_log to find bottlenecks, right-size max_connections to app demand, and ensure reliable backups. Then optimize indexes and queries based on real workload data.<\/p>\n\n<\/div>\n<\/div>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>To use MariaDB on a Linux server, install it from your distro\u2019s repositories, start and enable the mariadb service, run [&hellip;]<\/p>\n","protected":false},"author":21,"featured_media":13797,"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-13227","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\/What-is-MariaDB-on-Linux-Server.jpg","author_info":{"display_name":"Sanjeet Chauhan","author_link":"https:\/\/www.youstable.com\/blog\/author\/sanjeet"},"_links":{"self":[{"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/posts\/13227","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\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/comments?post=13227"}],"version-history":[{"count":8,"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/posts\/13227\/revisions"}],"predecessor-version":[{"id":13798,"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/posts\/13227\/revisions\/13798"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/media\/13797"}],"wp:attachment":[{"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/media?parent=13227"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/categories?post=13227"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/tags?post=13227"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}