{"id":1915,"date":"2026-09-12T13:22:34","date_gmt":"2026-09-12T10:22:34","guid":{"rendered":"https:\/\/narhost.com\/destek\/mariadb-kurulumu-guvenli-yapilandirma\/"},"modified":"2026-09-12T13:22:34","modified_gmt":"2026-09-12T10:22:34","slug":"mariadb-kurulumu-guvenli-yapilandirma","status":"publish","type":"post","link":"https:\/\/narhost.com\/destek\/mariadb-kurulumu-guvenli-yapilandirma\/","title":{"rendered":"MariaDB Kurulumu ve G\u00fcvenli Yap\u0131land\u0131rma (Ubuntu VPS)"},"content":{"rendered":"<p class=\"kb-dogrulama\">Son do\u011frulama: Eyl\u00fcl 2026 \u00b7 Ubuntu 24.04 test sunucusunda denendi<\/p>\n<div id=\"hizli-cozum\" class=\"ai-box ai-box--cozum\">\n<p class=\"ai-box-title\">H\u0131zl\u0131 \u00e7\u00f6z\u00fcm<\/p>\n<p><strong>MariaDB kurulumu<\/strong> Ubuntu tabanl\u0131 bir VPS ya da VDS&#8217;te iki komutla tamamlan\u0131r: <code>apt-get update<\/code> ve ard\u0131ndan <code>apt-get install mariadb-server<\/code>. Kurulum bitince servis kendili\u011finden ba\u015flar; ard\u0131ndan <code>mysql_secure_installation<\/code> sihirbaz\u0131n\u0131 \u00e7al\u0131\u015ft\u0131r\u0131p anonim kullan\u0131c\u0131lar\u0131, uzaktan root giri\u015fini ve test veritaban\u0131n\u0131 kald\u0131r\u0131rs\u0131n\u0131z.<\/p>\n<ol>\n<li>Paket listesini g\u00fcncelleyin: <code>apt-get update<\/code><\/li>\n<li>Sunucuyu kurun: <code>apt-get install mariadb-server<\/code><\/li>\n<li>Servisi do\u011frulay\u0131n: <code>systemctl status mariadb<\/code><\/li>\n<li>G\u00fcvenli h\u00e2le getirin: <code>mysql_secure_installation<\/code><\/li>\n<\/ol>\n<\/div>\n<table class=\"kb-uyg\">\n<tr>\n<th>Panel<\/th>\n<td>Yok (SSH \/ terminal)<\/td>\n<\/tr>\n<tr>\n<th>Sistem<\/th>\n<td>Ubuntu 22.04\/24.04, Debian 12 (VPS\/VDS)<\/td>\n<\/tr>\n<tr>\n<th>Yetki<\/th>\n<td>root ya da sudo<\/td>\n<\/tr>\n<tr>\n<th>Narhost \u00fcr\u00fcn\u00fc<\/th>\n<td><a href=\"https:\/\/narhost.com\/vps-sunucu\" title=\"VPS Sunucu - Narhost\">VPS Sunucu<\/a>, VDS Sunucu<\/td>\n<\/tr>\n<\/table>\n<div class=\"kb-once\">\n<p class=\"label\">Ba\u015flamadan \u00f6nce<\/p>\n<ul>\n<li>Sunucunuza root ya da sudo yetkili bir kullan\u0131c\u0131yla SSH ile ba\u011flanabiliyor olmal\u0131s\u0131n\u0131z; ilk ba\u011flant\u0131y\u0131 hen\u00fcz kurmad\u0131ysan\u0131z \u00f6nce <a href=\"https:\/\/narhost.com\/destek\/vps-vds-ilk-kurulum-rehberi\/\" title=\"VPS VDS Sunucu \u0130lk Kurulum Rehberi - Narhost Destek\">VPS\/VDS ilk kurulum rehberini<\/a> tamamlay\u0131n.<\/li>\n<li>Sunucuda daha \u00f6nce MySQL ya da MariaDB kurulu olmamal\u0131; varsa \u00f6nce kald\u0131r\u0131p <code>\/var\/lib\/mysql<\/code> dizinini temizleyin, aksi h\u00e2lde kurulum eski veritaban\u0131 dosyalar\u0131yla \u00e7ak\u0131\u015f\u0131r.<\/li>\n<li>3306 portunun g\u00fcvenlik duvar\u0131nda sadece uygulaman\u0131z\u0131n \u00e7al\u0131\u015ft\u0131\u011f\u0131 sunucuya a\u00e7\u0131k olaca\u011f\u0131n\u0131 unutmay\u0131n; veritaban\u0131n\u0131 d\u0131\u015far\u0131ya a\u00e7\u0131k b\u0131rakmay\u0131n.<\/li>\n<li>Kurulum yeni bir sunucuya yap\u0131l\u0131yorsa yedek gerekmez; mevcut bir veritaban\u0131n\u0131 y\u00fckseltiyorsan\u0131z \u00f6nce yedek al\u0131n.<\/li>\n<\/ul>\n<\/div>\n<h2>MariaDB kurulumu ne i\u015fe yarar, ne zaman gerekir<\/h2>\n<p>Narhost&#8217;un VPS ve VDS \u00fcr\u00fcnleri y\u00f6netimsizdir: i\u015fletim sistemi haz\u0131r teslim edilir, ama \u00fczerine kuraca\u011f\u0131n\u0131z veritaban\u0131 sunucusu sizin sorumlulu\u011funuzdad\u0131r. WordPress, \u00f6zel bir PHP uygulamas\u0131 ya da Node.js API&#8217;niz i\u00e7in ayr\u0131 bir veritaban\u0131 sunucusuna ihtiya\u00e7 duydu\u011funuzda MariaDB kurulumu bu noktada devreye girer. MariaDB, MySQL&#8217;in a\u00e7\u0131k kaynak \u00e7atal\u0131d\u0131r ve Ubuntu&#8217;nun resmi depolar\u0131nda haz\u0131r paket olarak gelir; ayr\u0131 bir depo eklemeden <code>apt<\/code> ile kurulabilir.<\/p>\n<p>Paket kurulumu tek ba\u015f\u0131na g\u00fcvenli de\u011fildir: varsay\u0131lan h\u00e2lde anonim kullan\u0131c\u0131 hesab\u0131, herkese a\u00e7\u0131k bir test veritaban\u0131 ve baz\u0131 s\u00fcr\u00fcmlerde uzaktan root giri\u015fi bulunur. <code>mysql_secure_installation<\/code> sihirbaz\u0131 tam olarak bu d\u00f6rt noktay\u0131 kapatmak i\u00e7in MariaDB projesi taraf\u0131ndan sa\u011flan\u0131r; sihirbaz\u0131n sordu\u011fu her sorunun ayr\u0131nt\u0131s\u0131 <a href=\"https:\/\/mariadb.com\/kb\/en\/mysql_secure_installation\/\" title=\"MariaDB Knowledge Base \u2014 mysql_secure_installation resmi dok\u00fcmantasyonu\" target=\"_blank\" rel=\"noopener\">MariaDB&#8217;nin resmi belgesinde<\/a> a\u00e7\u0131klan\u0131r.<\/p>\n<figure class=\"nh-sema\"><img src=\"https:\/\/narhost.com\/destek\/wp-content\/uploads\/2026\/09\/mariadb-kurulumu-guvenli-yapilandirma-sema-narhost.webp\" alt=\"MariaDB kurulumu ak\u0131\u015f\u0131 \u2014 apt ile kurulum, servis ba\u015flatma, mysql_secure_installation ile g\u00fcvenli h\u00e2le getirme\" width=\"1200\" height=\"500\" loading=\"lazy\" decoding=\"async\"><figcaption>Kurulumdan g\u00fcvenli yap\u0131land\u0131rmaya d\u00f6rt ad\u0131m: paketi kur, servisi do\u011frula, s\u00fcr\u00fcm\u00fc kontrol et, sihirbazla kapat.<\/figcaption><\/figure>\n<h2>MariaDB kurulumu ad\u0131m ad\u0131m<\/h2>\n<ol class=\"kb-adimlar\">\n<li><strong>Paket listesini g\u00fcncelleyin.<\/strong> Sunucuya SSH ile ba\u011flan\u0131p a\u015fa\u011f\u0131daki komutu \u00e7al\u0131\u015ft\u0131r\u0131n; Ubuntu&#8217;nun resmi depo indekslerini tazeler.\n<pre><code class=\"language-bash\">apt-get update<\/code><\/pre>\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: <code>Hit:1 http:\/\/archive.ubuntu.com\/ubuntu noble InRelease<\/code> sat\u0131rlar\u0131yla depo listesi okunur, hata \u00e7\u0131kmaz.<\/p>\n<\/li>\n<li><strong>MariaDB sunucusunu kurun.<\/strong> A\u015fa\u011f\u0131daki komut sunucu, istemci ve ba\u011f\u0131ml\u0131l\u0131k paketlerinin tamam\u0131n\u0131 indirir ve kurar.\n<pre><code class=\"language-bash\">apt-get install -y mariadb-server<\/code><\/pre>\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: kurulum <code>Setting up mariadb-server (1:10.11.14-0ubuntu0.24.04.1) ...<\/code> sat\u0131r\u0131yla biter ve <code>Created symlink \/etc\/systemd\/system\/multi-user.target.wants\/mariadb.service<\/code> g\u00f6r\u00fcn\u00fcr; servis otomatik ba\u015flar.<\/p>\n<\/li>\n<li><strong>Servisin \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 do\u011frulay\u0131n.<\/strong>\n<pre><code class=\"language-bash\">systemctl status mariadb<\/code><\/pre>\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: <code>Active: active (running)<\/code> ve <code>Status: \"Taking your SQL requests now.\"<\/code> sat\u0131rlar\u0131 g\u00f6r\u00fcn\u00fcr.<\/p>\n<\/li>\n<li><strong>S\u00fcr\u00fcm\u00fc kontrol edin.<\/strong>\n<pre><code class=\"language-bash\">mariadb --version<\/code><\/pre>\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: <code>mariadb Ver 15.1 Distrib 10.11.14-MariaDB, for debian-linux-gnu (x86_64)<\/code> benzeri bir sat\u0131r. Ubuntu 24.04&#8217;te depodan gelen s\u00fcr\u00fcm 10.11&#8217;dir.<\/p>\n<\/li>\n<li><strong>G\u00fcvenli yap\u0131land\u0131rma sihirbaz\u0131n\u0131 \u00e7al\u0131\u015ft\u0131r\u0131n.<\/strong>\n<pre><code class=\"language-bash\">mysql_secure_installation<\/code><\/pre>\n<p>Sihirbaz s\u0131rayla \u015funlar\u0131 sorar: mevcut root kimlik do\u011frulamas\u0131n\u0131 de\u011fi\u015ftirmek isteyip istemedi\u011finiz (Ubuntu&#8217;da root varsay\u0131lan olarak <code>unix_socket<\/code> ile, yani \u015fifresiz ve sadece sunucudaki root kullan\u0131c\u0131s\u0131ndan do\u011frulan\u0131r), anonim kullan\u0131c\u0131lar\u0131 silmek, uzaktan root giri\u015fini kapatmak, test veritaban\u0131n\u0131 kald\u0131rmak ve yetki tablolar\u0131n\u0131 yeniden y\u00fcklemek. Her soruya <code>Y<\/code> ile yan\u0131t vermeniz, sunucuyu bu d\u00f6rt a\u00e7\u0131k noktadan kapat\u0131r.<\/p>\n<\/li>\n<\/ol>\n<div class=\"warn-box\">\n<p class=\"label\">Dikkat<\/p>\n<p>Uzaktan root giri\u015fini kapatt\u0131ktan sonra uygulaman\u0131z veritaban\u0131na root ile ba\u011flanamaz; her uygulama i\u00e7in ayr\u0131, s\u0131n\u0131rl\u0131 yetkili bir kullan\u0131c\u0131 a\u00e7\u0131n (<code>CREATE USER<\/code> ve <code>GRANT<\/code> ile). Root hesab\u0131n\u0131 \u00fcretim uygulamalar\u0131nda kullanmay\u0131n.<\/p>\n<\/div>\n<h2>Do\u011frulama<\/h2>\n<div class=\"success-box\">\n<p class=\"label\">Sonu\u00e7<\/p>\n<p>Sihirbaz bittikten sonra <code>mariadb -u root -p<\/code> ile ba\u011flan\u0131p <code>SHOW DATABASES;<\/code> yaz\u0131n; test veritaban\u0131n\u0131n listede olmad\u0131\u011f\u0131n\u0131 g\u00f6r\u00fcrseniz kurulum g\u00fcvenli h\u00e2le gelmi\u015ftir. S\u00fcr\u00fcm bilgisini de <code>SELECT VERSION();<\/code> ile teyit edebilirsiniz; test sunucusunda bu komut <code>10.11.14-MariaDB-0ubuntu0.24.04.1<\/code> d\u00f6nd\u00fcrd\u00fc.<\/p>\n<\/div>\n<h2>H\u00e2l\u00e2 \u00e7\u00f6z\u00fclmediyse<\/h2>\n<ul>\n<li><strong>&#8220;Can&#8217;t connect to local MySQL server through socket&#8221; hatas\u0131.<\/strong> Servis \u00e7al\u0131\u015fm\u0131yor olabilir; <code>systemctl status mariadb<\/code> ile durumu kontrol edin, kapal\u0131ysa <code>systemctl start mariadb<\/code> ile ba\u015flat\u0131n. Ba\u011flant\u0131 sorunu s\u00fcr\u00fcyorsa <a href=\"https:\/\/narhost.com\/destek\/mysql-sunucuya-nasil-baglanilir\/\" title=\"MySQL sunucuya nas\u0131l ba\u011flan\u0131l\u0131r - Narhost Destek\">MySQL sunucuya nas\u0131l ba\u011flan\u0131l\u0131r<\/a> kart\u0131na bak\u0131n.<\/li>\n<li><strong>Kurulum s\u0131ras\u0131nda paket \u00e7ak\u0131\u015fmas\u0131.<\/strong> Sunucuda eski bir MySQL kurulumu kal\u0131nt\u0131s\u0131 varsa <code>apt-get purge<\/code> ile \u00f6nce onu temizleyin, sonra MariaDB&#8217;yi yeniden kurun.<\/li>\n<li><strong>Uygulama uzun sorgularda zaman a\u015f\u0131m\u0131na d\u00fc\u015f\u00fcyor.<\/strong> Bu genelde yap\u0131land\u0131rma de\u011fil kaynak sorunudur; sunucunun i\u015flemci ve bellek kullan\u0131m\u0131n\u0131 izleyin.<\/li>\n<\/ul>\n<div class=\"cta-box\">\n<p class=\"label\">Narhost deste\u011fi<\/p>\n<p>Kurulum s\u0131ras\u0131nda tak\u0131l\u0131rsan\u0131z destek talebinize sunucunuzun i\u015fletim sistemi s\u00fcr\u00fcm\u00fcn\u00fc, \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131z komutu ve ald\u0131\u011f\u0131n\u0131z tam hata mesaj\u0131n\u0131 ekleyin.<\/p>\n<p><a class=\"cta-btn\" href=\"https:\/\/narhost.com\/submitticket.php\" title=\"Narhost destek talebi a\u00e7\">Destek talebi a\u00e7<\/a><\/div>\n<div class=\"kb-ilgili\">\n<p class=\"label\">Sonraki ad\u0131mlar<\/p>\n<ul>\n<li><a href=\"https:\/\/narhost.com\/destek\/vps-vds-ilk-kurulum-rehberi\/\" title=\"VPS VDS Sunucu \u0130lk Kurulum Rehberi - Narhost Destek\">VPS\/VDS Sunucu \u0130lk Kurulum Rehberi<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/destek\/nginx-kurulumu\/\" title=\"Nginx kurulumu - Narhost Destek\">Nginx Kurulumu<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/destek\/vds-aldim-ama-kasiyor-ne-yapmaliyim\/\" title=\"VDS ald\u0131m ama kas\u0131yor ne yapmal\u0131y\u0131m - Narhost Destek\">VDS Ald\u0131m Ama Kas\u0131yor, Ne Yapmal\u0131y\u0131m<\/a><\/li>\n<\/ul>\n<\/div>\n<div class=\"kb-faq\">\n<h2>S\u0131k\u00e7a sorulan sorular<\/h2>\n<h3>MariaDB kurulumu i\u00e7in \u00f6nce MySQL&#8217;i kald\u0131rmam gerekir mi?<\/h3>\n<p>Sunucuda hi\u00e7 veritaban\u0131 kurulu de\u011filse gerekmez. Eski bir MySQL kurulumu varsa \u00f6nce onu kald\u0131r\u0131p veri dizinini temizlemeniz, iki sunucunun ayn\u0131 3306 portunda \u00e7ak\u0131\u015fmas\u0131n\u0131 \u00f6nler.<\/p>\n<h3>mysql_secure_installation&#8217;\u0131 atlarsam ne olur?<\/h3>\n<p>Sunucu \u00e7al\u0131\u015f\u0131r ama anonim kullan\u0131c\u0131 ve test veritaban\u0131 a\u00e7\u0131kta kal\u0131r; bu, sunucunuza d\u0131\u015far\u0131dan eri\u015fim varsa g\u00fcvenlik a\u00e7\u0131\u011f\u0131d\u0131r. Ad\u0131m\u0131 atlamay\u0131n.<\/p>\n<h3>MariaDB ile MySQL aras\u0131nda hangisini se\u00e7meliyim?<\/h3>\n<p>Ubuntu&#8217;nun resmi deposu MariaDB&#8217;yi \u00f6nerir ve komutlar\u0131n \u00e7o\u011fu (mariadb, mysqldump) iki sistemde de ayn\u0131 \u00e7al\u0131\u015f\u0131r; yeni bir kurulum i\u00e7in MariaDB tercih edilir.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>MariaDB kurulumu Ubuntu 24.04 VPS\/VDS&#8217;te apt ile yap\u0131l\u0131r; servis do\u011frulama, s\u00fcr\u00fcm kontrol\u00fc ve mysql_secure_installation ile anonim kullan\u0131c\u0131, test veritaban\u0131 ve uzak root giri\u015finin kapat\u0131lmas\u0131 ad\u0131mlar\u0131.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,13],"tags":[173],"class_list":["post-1915","post","type-post","status-publish","format-standard","hentry","category-vds-server","category-vps-server","tag-mariadb"],"meta_box":[],"_links":{"self":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts\/1915","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/comments?post=1915"}],"version-history":[{"count":0,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts\/1915\/revisions"}],"wp:attachment":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/media?parent=1915"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/categories?post=1915"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/tags?post=1915"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}