{"id":131849,"date":"2026-04-09T16:40:49","date_gmt":"2026-04-09T20:40:49","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/?p=131849"},"modified":"2026-04-09T16:40:52","modified_gmt":"2026-04-09T20:40:52","slug":"how-to-set-up-mariadb-on-a-vps-installation","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/","title":{"rendered":"How to Set Up MariaDB on a VPS: Installation and Initial Configuration"},"content":{"rendered":"<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"538\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2026\/04\/How-to-set-up-mariadb-on-a-vps-1024x538.png\" alt=\"How to Set Up MariaDB on a VPS: Installation and Initial Configuration\" class=\"wp-image-131850\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2026\/04\/How-to-set-up-mariadb-on-a-vps-1024x538.png 1024w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2026\/04\/How-to-set-up-mariadb-on-a-vps-300x158.png 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2026\/04\/How-to-set-up-mariadb-on-a-vps-768x403.png 768w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2026\/04\/How-to-set-up-mariadb-on-a-vps.png 1200w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><\/figure>\n\n\n<div class=\"wp-block-post-excerpt\"><p class=\"wp-block-post-excerpt__excerpt\">MariaDB has become the go-to MySQL-compatible database for many developers and system administrators. <\/p><\/div>\n\n\n<p>As a true open-source fork of MySQL with active development and performance improvements, it\u2019s an excellent choice for WordPress sites, web applications, and data-driven projects.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Why Mariadb?<\/strong><\/h2>\n\n\n\n<p>MariaDB maintains binary drop-in compatibility with MySQL, meaning most applications work without modification. It also ships with features like Aria storage engine for crash recovery, thread pool for better concurrency, and Galera Cluster for multi-master replication.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Installing Mariadb<\/strong><\/h2>\n\n\n\n<p>On Ubuntu\/Debian:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono-NL.ttf\" style=\"font-size:clamp(16px, 1rem, 24px);font-family:Code-Pro-JetBrains-Mono-NL,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:clamp(26px, 1.625rem, 39px);--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><pre class=\"shiki dark-plus\" style=\"background-color: #1E1E1E\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #9CDCFE\">sudo<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">apt<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">update<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9CDCFE\">sudo<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">apt<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">install<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">mariadb<\/span><span style=\"color: #D4D4D4\">-<\/span><span style=\"color: #9CDCFE\">server<\/span><span style=\"color: #D4D4D4\"> -<\/span><span style=\"color: #9CDCFE\">y<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9CDCFE\">sudo<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">systemctl<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">start<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">mariadb<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9CDCFE\">sudo<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">systemctl<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">enable<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">mariadb<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>On AlmaLinux\/RHEL:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono-NL.ttf\" style=\"font-size:clamp(16px, 1rem, 24px);font-family:Code-Pro-JetBrains-Mono-NL,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:clamp(26px, 1.625rem, 39px);--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><pre class=\"shiki dark-plus\" style=\"background-color: #1E1E1E\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #9CDCFE\">sudo<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">dnf<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">install<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">mariadb<\/span><span style=\"color: #D4D4D4\">-<\/span><span style=\"color: #9CDCFE\">server<\/span><span style=\"color: #D4D4D4\"> -<\/span><span style=\"color: #9CDCFE\">y<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9CDCFE\">sudo<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">systemctl<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">start<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">mariadb<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9CDCFE\">sudo<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">systemctl<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">enable<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">mariadb<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Securing Mariadb<\/strong><\/h2>\n\n\n\n<p>After installation, run the security script:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono-NL.ttf\" style=\"font-size:clamp(16px, 1rem, 24px);font-family:Code-Pro-JetBrains-Mono-NL,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:clamp(26px, 1.625rem, 39px);--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><pre class=\"shiki dark-plus\" style=\"background-color: #1E1E1E\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #9CDCFE\">sudo<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">mariadb<\/span><span style=\"color: #D4D4D4\">-<\/span><span style=\"color: #9CDCFE\">secure<\/span><span style=\"color: #D4D4D4\">-<\/span><span style=\"color: #9CDCFE\">installation<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>You\u2019ll be prompted to:<br>\u2022 Set root password<br>\u2022 Remove anonymous users<br>\u2022 Disallow root login remotely<br>\u2022 Remove test database<br>\u2022 Reload privilege tables<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Initial Configuration<\/strong><\/h2>\n\n\n\n<p>Edit the configuration file to optimize performance:<br>\/etc\/mysql\/mariadb.conf.d\/50-server.cnf (Ubuntu)<br>\/etc\/my.cnf.d\/server.cnf (AlmaLinux)<\/p>\n\n\n\n<p>Key settings:<br>innodb_buffer_pool_size = 2G\u00a0 # 50-70% of RAM<br>max_connections = 150<br>slow_query_log = 1<br>slow_query_log_file = \/var\/log\/mysql\/slow-query.log<br>long_query_time = 2<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Creating Databases And Users<\/strong><\/h2>\n\n\n\n<p>Log into MariaDB:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono-NL.ttf\" style=\"font-size:clamp(16px, 1rem, 24px);font-family:Code-Pro-JetBrains-Mono-NL,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:clamp(26px, 1.625rem, 39px);--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><pre class=\"shiki dark-plus\" style=\"background-color: #1E1E1E\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #9CDCFE\">sudo<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">mariadb<\/span><span style=\"color: #D4D4D4\"> -<\/span><span style=\"color: #9CDCFE\">u<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">root<\/span><span style=\"color: #D4D4D4\"> -<\/span><span style=\"color: #9CDCFE\">p<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>Create database:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono-NL.ttf\" style=\"font-size:clamp(16px, 1rem, 24px);font-family:Code-Pro-JetBrains-Mono-NL,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:clamp(26px, 1.625rem, 39px);--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><pre class=\"shiki dark-plus\" style=\"background-color: #1E1E1E\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #4FC1FF\">CREATE<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #4FC1FF\">DATABASE<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">myapp_db<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #4FC1FF\">CHARACTER<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #4FC1FF\">SET<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">utf8mb4<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #4FC1FF\">COLLATE<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">utf8mb4_unicode_ci<\/span><span style=\"color: #D4D4D4\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>Create user and grant privileges:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono-NL.ttf\" style=\"font-size:clamp(16px, 1rem, 24px);font-family:Code-Pro-JetBrains-Mono-NL,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:clamp(26px, 1.625rem, 39px);--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><pre class=\"shiki dark-plus\" style=\"background-color: #1E1E1E\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #4FC1FF\">CREATE<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #4FC1FF\">USER<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #CE9178\">'appuser'<\/span><span style=\"color: #D4D4D4\">@<\/span><span style=\"color: #CE9178\">'localhost'<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #4FC1FF\">IDENTIFIED<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #4FC1FF\">BY<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #CE9178\">'secure_password'<\/span><span style=\"color: #D4D4D4\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #4FC1FF\">GRANT<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #4FC1FF\">ALL<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #4FC1FF\">PRIVILEGES<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #4FC1FF\">ON<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">myapp_db<\/span><span style=\"color: #D4D4D4\">.* <\/span><span style=\"color: #4FC1FF\">TO<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #CE9178\">'appuser'<\/span><span style=\"color: #D4D4D4\">@<\/span><span style=\"color: #CE9178\">'localhost'<\/span><span style=\"color: #D4D4D4\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #4FC1FF\">FLUSH<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #4FC1FF\">PRIVILEGES<\/span><span style=\"color: #D4D4D4\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>ENABLING REMOTE ACCESS (Optional)<\/p>\n\n\n\n<p>Edit configuration and change bind-address to 0.0.0.0<br>Configure firewall to allow port 3306<br>Restart MariaDB<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Setting Up Automated Backups<\/strong><\/h2>\n\n\n\n<p>Create backup script at \/usr\/local\/bin\/mariadb-backup.sh:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono-NL.ttf\" style=\"font-size:clamp(16px, 1rem, 24px);font-family:Code-Pro-JetBrains-Mono-NL,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:clamp(26px, 1.625rem, 39px);--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><pre class=\"shiki dark-plus\" style=\"background-color: #1E1E1E\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #6A9955\">#!\/bin\/bash<\/span><\/span>\n<span class=\"line\"><span style=\"color: #4FC1FF\">BACKUP_DIR<\/span><span style=\"color: #D4D4D4\">=<\/span><span style=\"color: #CE9178\">\"\/var\/backups\/mariadb\"<\/span><\/span>\n<span class=\"line\"><span style=\"color: #4FC1FF\">DATE<\/span><span style=\"color: #D4D4D4\">=<\/span><span style=\"color: #DCDCAA\">$<\/span><span style=\"color: #D4D4D4\">(<\/span><span style=\"color: #9CDCFE\">date<\/span><span style=\"color: #D4D4D4\"> +%<\/span><span style=\"color: #4FC1FF\">Y<\/span><span style=\"color: #D4D4D4\">%<\/span><span style=\"color: #9CDCFE\">m<\/span><span style=\"color: #D4D4D4\">%<\/span><span style=\"color: #9CDCFE\">d<\/span><span style=\"color: #D4D4D4\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9CDCFE\">mysqldump<\/span><span style=\"color: #D4D4D4\"> -<\/span><span style=\"color: #9CDCFE\">u<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">root<\/span><span style=\"color: #D4D4D4\"> -<\/span><span style=\"color: #9CDCFE\">p<\/span><span style=\"color: #CE9178\">'password'<\/span><span style=\"color: #D4D4D4\"> --<\/span><span style=\"color: #9CDCFE\">all<\/span><span style=\"color: #D4D4D4\">-<\/span><span style=\"color: #9CDCFE\">databases<\/span><span style=\"color: #D4D4D4\"> | <\/span><span style=\"color: #9CDCFE\">gzip<\/span><span style=\"color: #D4D4D4\"> &gt; <\/span><span style=\"color: #9CDCFE\">$BACKUP_DIR<\/span><span style=\"color: #D4D4D4\">\/<\/span><span style=\"color: #9CDCFE\">backup_$DATE<\/span><span style=\"color: #D4D4D4\">.<\/span><span style=\"color: #9CDCFE\">sql<\/span><span style=\"color: #D4D4D4\">.<\/span><span style=\"color: #9CDCFE\">gz<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9CDCFE\">find<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #9CDCFE\">$BACKUP_DIR<\/span><span style=\"color: #D4D4D4\"> -<\/span><span style=\"color: #9CDCFE\">mtime<\/span><span style=\"color: #D4D4D4\"> +<\/span><span style=\"color: #B5CEA8\">7<\/span><span style=\"color: #D4D4D4\"> -<\/span><span style=\"color: #569CD6\">delete<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>Schedule with cron for daily 2 AM backups:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono-NL.ttf\" style=\"font-size:clamp(16px, 1rem, 24px);font-family:Code-Pro-JetBrains-Mono-NL,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:clamp(26px, 1.625rem, 39px);--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><pre class=\"shiki dark-plus\" style=\"background-color: #1E1E1E\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #B5CEA8\">0<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #B5CEA8\">2<\/span><span style=\"color: #D4D4D4\"> * * * \/<\/span><span style=\"color: #9CDCFE\">usr<\/span><span style=\"color: #D4D4D4\">\/<\/span><span style=\"color: #9CDCFE\">local<\/span><span style=\"color: #D4D4D4\">\/<\/span><span style=\"color: #9CDCFE\">bin<\/span><span style=\"color: #D4D4D4\">\/<\/span><span style=\"color: #9CDCFE\">mariadb<\/span><span style=\"color: #D4D4D4\">-<\/span><span style=\"color: #9CDCFE\">backup<\/span><span style=\"color: #D4D4D4\">.<\/span><span style=\"color: #9CDCFE\">sh<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>Need managed MariaDB hosting? <a href=\"https:\/\/www.inmotionhosting.com\/vps-hosting\">InMotion Hosting VPS plans<\/a> include root access for <a href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/how-to-install-maria-db\/\">MariaDB installation<\/a>, and our managed VPS tier includes database optimization and monitoring as part of Launch Assist.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p><a href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/what-is-mariadb\/\">MariaDB<\/a> has become the go-to MySQL-compatible database for many developers and system administrators. <\/p>\n","protected":false},"author":57037,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4324],"tags":[],"class_list":["post-131849","post","type-post","status-publish","format-standard","hentry","category-vps-hosting"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Set Up MariaDB on a VPS: Installation and Initial Configuration | InMotion Hosting<\/title>\n<meta name=\"description\" content=\"In this article we walk you through how to set up MariaDB on a VPS from InMotion Hosting\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Set Up MariaDB on a VPS: Installation and Initial Configuration | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"In this article we walk you through how to set up MariaDB on a VPS from InMotion Hosting\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/\" \/>\n<meta property=\"og:site_name\" content=\"InMotion Hosting Support Center\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inmotionhosting\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-04-09T20:40:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-04-09T20:40:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2026\/04\/How-to-set-up-mariadb-on-a-vps.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Sam Page\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sam Page\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/\"},\"author\":{\"name\":\"Sam Page\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/18aba2647808ba3ddaf4406008b92ec1\"},\"headline\":\"How to Set Up MariaDB on a VPS: Installation and Initial Configuration\",\"datePublished\":\"2026-04-09T20:40:49+00:00\",\"dateModified\":\"2026-04-09T20:40:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/\"},\"wordCount\":243,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2026\/04\/How-to-set-up-mariadb-on-a-vps-1024x538.png\",\"articleSection\":[\"VPS Hosting\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/\",\"name\":\"How to Set Up MariaDB on a VPS: Installation and Initial Configuration | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2026\/04\/How-to-set-up-mariadb-on-a-vps-1024x538.png\",\"datePublished\":\"2026-04-09T20:40:49+00:00\",\"dateModified\":\"2026-04-09T20:40:52+00:00\",\"description\":\"In this article we walk you through how to set up MariaDB on a VPS from InMotion Hosting\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2026\/04\/How-to-set-up-mariadb-on-a-vps.png\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2026\/04\/How-to-set-up-mariadb-on-a-vps.png\",\"width\":1200,\"height\":630},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Set Up MariaDB on a VPS: Installation and Initial Configuration\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"name\":\"InMotion Hosting Support Center\",\"description\":\"Web Hosting Support &amp; Tutorials\",\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\",\"name\":\"InMotion Hosting\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"width\":696,\"height\":696,\"caption\":\"InMotion Hosting\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/inmotionhosting\/\",\"https:\/\/x.com\/InMotionHosting\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/18aba2647808ba3ddaf4406008b92ec1\",\"name\":\"Sam Page\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/author\/samp\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Set Up MariaDB on a VPS: Installation and Initial Configuration | InMotion Hosting","description":"In this article we walk you through how to set up MariaDB on a VPS from InMotion Hosting","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/","og_locale":"en_US","og_type":"article","og_title":"How to Set Up MariaDB on a VPS: Installation and Initial Configuration | InMotion Hosting","og_description":"In this article we walk you through how to set up MariaDB on a VPS from InMotion Hosting","og_url":"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2026-04-09T20:40:49+00:00","article_modified_time":"2026-04-09T20:40:52+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2026\/04\/How-to-set-up-mariadb-on-a-vps.png","type":"image\/png"}],"author":"Sam Page","twitter_card":"summary_large_image","twitter_creator":"@InMotionHosting","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"Sam Page","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/"},"author":{"name":"Sam Page","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/18aba2647808ba3ddaf4406008b92ec1"},"headline":"How to Set Up MariaDB on a VPS: Installation and Initial Configuration","datePublished":"2026-04-09T20:40:49+00:00","dateModified":"2026-04-09T20:40:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/"},"wordCount":243,"commentCount":0,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2026\/04\/How-to-set-up-mariadb-on-a-vps-1024x538.png","articleSection":["VPS Hosting"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/","url":"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/","name":"How to Set Up MariaDB on a VPS: Installation and Initial Configuration | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2026\/04\/How-to-set-up-mariadb-on-a-vps-1024x538.png","datePublished":"2026-04-09T20:40:49+00:00","dateModified":"2026-04-09T20:40:52+00:00","description":"In this article we walk you through how to set up MariaDB on a VPS from InMotion Hosting","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2026\/04\/How-to-set-up-mariadb-on-a-vps.png","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2026\/04\/How-to-set-up-mariadb-on-a-vps.png","width":1200,"height":630},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/how-to-set-up-mariadb-on-a-vps-installation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to Set Up MariaDB on a VPS: Installation and Initial Configuration"}]},{"@type":"WebSite","@id":"https:\/\/www.inmotionhosting.com\/support\/#website","url":"https:\/\/www.inmotionhosting.com\/support\/","name":"InMotion Hosting Support Center","description":"Web Hosting Support &amp; Tutorials","publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.inmotionhosting.com\/support\/#organization","name":"InMotion Hosting","url":"https:\/\/www.inmotionhosting.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","width":696,"height":696,"caption":"InMotion Hosting"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/inmotionhosting\/","https:\/\/x.com\/InMotionHosting"]},{"@type":"Person","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/18aba2647808ba3ddaf4406008b92ec1","name":"Sam Page","url":"https:\/\/www.inmotionhosting.com\/support\/author\/samp\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"primary_category":{"id":4324,"name":"VPS Hosting","slug":"vps-hosting","link":"https:\/\/www.inmotionhosting.com\/support\/product-guides\/vps-hosting\/"},"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/131849","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/users\/57037"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=131849"}],"version-history":[{"count":1,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/131849\/revisions"}],"predecessor-version":[{"id":131851,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/131849\/revisions\/131851"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=131849"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=131849"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=131849"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}