{"id":31210,"date":"2025-10-07T07:41:46","date_gmt":"2025-10-07T04:41:46","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/?p=31210"},"modified":"2025-10-07T07:41:46","modified_gmt":"2025-10-07T04:41:46","slug":"mariadb-nedir-ve-neden-debian-9da-kullanmalisiniz","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-debian-9da-kullanmalisiniz\/","title":{"rendered":"MariaDB Nedir ve Neden Debian 9&#8217;da Kullanmal\u0131s\u0131n\u0131z?"},"content":{"rendered":"<p><body><\/p>\n<h2>MariaDB Nedir ve Neden Debian 9&#8217;da Kullanmal\u0131s\u0131n\u0131z?<\/h2>\n<p>MariaDB, MySQL&#8217;in topluluk taraf\u0131ndan geli\u015ftirilen, a\u00e7\u0131k kaynakl\u0131 ve olduk\u00e7a uyumlu bir fork&#8217;udur. Performans\u0131, g\u00fcvenli\u011fi ve yeni nesil \u00f6zellikleriyle \u00f6ne \u00e7\u0131kar. Debian 9 (Stretch) gibi kararl\u0131 ve g\u00fcvenilir bir i\u015fletim sistemi \u00fczerinde MariaDB kullanmak, web uygulamalar\u0131, veri taban\u0131 destekli sistemler ve \u00e7e\u015fitli sunucu hizmetleri i\u00e7in sa\u011flam bir temel olu\u015fturur. Debian 9, uzun s\u00fcreli destek (LTS) sunan bir da\u011f\u0131t\u0131m oldu\u011fu i\u00e7in, bu rehber eski ancak hala kullan\u0131lan sistemler i\u00e7in ge\u00e7erli ve \u00f6nemlidir.<\/p>\n<h2>MariaDB Kurulumuna Ba\u015flamadan \u00d6nce<\/h2>\n<p>MariaDB&#8217;yi Debian 9 sisteminize kurmaya ba\u015flamadan \u00f6nce, baz\u0131 \u00f6n haz\u0131rl\u0131k ad\u0131mlar\u0131n\u0131 tamamlaman\u0131z gerekmektedir. Bu ad\u0131mlar, sorunsuz bir kurulum s\u00fcreci ve g\u00fcvenli bir \u00e7al\u0131\u015fma ortam\u0131 sa\u011flamak i\u00e7in kritik \u00f6neme sahiptir.<\/p>\n<h3>Sistem G\u00fcncellemesi ve \u00d6n Ko\u015fullar<\/h3>\n<p>\u00d6ncelikle, sisteminizin g\u00fcncel oldu\u011fundan emin olun. Bu, hem g\u00fcvenlik yamalar\u0131n\u0131 uygulaman\u0131z\u0131 hem de mevcut paketlerin en son kararl\u0131 s\u00fcr\u00fcmlerini kullanman\u0131z\u0131 sa\u011flar. Ayr\u0131ca, kurulumu ger\u00e7ekle\u015ftirmek i\u00e7in <code>root<\/code> ayr\u0131cal\u0131klar\u0131na sahip olman\u0131z veya <code>sudo<\/code> kullanabilen bir kullan\u0131c\u0131 olman\u0131z gerekmektedir. \u0130nternet ba\u011flant\u0131n\u0131z\u0131n aktif oldu\u011fundan da emin olun.<\/p>\n<pre><code class=\"language-bash\">sudo apt update\nsudo apt upgrade -y<\/code><\/pre>\n<p>Bu komutlar, paket listelerinizi g\u00fcnceller ve mevcut t\u00fcm paketleri y\u00fckseltir. <code>-y<\/code> parametresi, t\u00fcm sorulara otomatik olarak &#8220;evet&#8221; yan\u0131t\u0131 vermenizi sa\u011flar, bu da uzun s\u00fcreli g\u00fcncellemelerde i\u015finize yarar.<\/p>\n<h3>Debian S\u00fcr\u00fcm\u00fcn\u00fc Kontrol Etme<\/h3>\n<p>Kurulum talimatlar\u0131n\u0131n do\u011fru oldu\u011fundan emin olmak i\u00e7in sisteminizin Debian 9 (Stretch) oldu\u011fundan emin olmak iyi bir uygulamad\u0131r. Bunu a\u015fa\u011f\u0131daki komutlarla kontrol edebilirsiniz:<\/p>\n<pre><code class=\"language-bash\">lsb_release -a<\/code><\/pre>\n<p>veya<\/p>\n<pre><code class=\"language-bash\">cat \/etc\/os-release<\/code><\/pre>\n<p>\u00c7\u0131kt\u0131da &#8220;Debian 9&#8221; veya &#8220;Stretch&#8221; ifadelerini g\u00f6rmelisiniz.<\/p>\n<h2>MariaDB Sunucusunu Kurma<\/h2>\n<p>MariaDB&#8217;yi Debian 9&#8217;a kurman\u0131n iki ana yolu vard\u0131r: Debian&#8217;\u0131n varsay\u0131lan depolar\u0131ndan veya MariaDB&#8217;nin resmi depolar\u0131ndan. Genellikle, Debian&#8217;\u0131n varsay\u0131lan depolar\u0131 kararl\u0131 ve iyi test edilmi\u015f bir s\u00fcr\u00fcm sunar. Ancak, daha yeni \u00f6zelliklere veya belirli bir MariaDB s\u00fcr\u00fcm\u00fcne ihtiyac\u0131n\u0131z varsa, resmi depolar\u0131 kullanmak daha uygun olabilir.<\/p>\n<h3>Varsay\u0131lan Debian Depolar\u0131ndan Kurulum<\/h3>\n<p>Debian 9&#8217;un varsay\u0131lan depolar\u0131, genellikle MariaDB&#8217;nin kararl\u0131 bir s\u00fcr\u00fcm\u00fcn\u00fc (genellikle MariaDB 10.1 veya 10.3) i\u00e7erir. Bu y\u00f6ntem, \u00e7o\u011fu kullan\u0131m durumu i\u00e7in yeterince iyi ve en kolay kurulum y\u00f6ntemidir.<\/p>\n<pre><code class=\"language-bash\">sudo apt install mariadb-server mariadb-client -y<\/code><\/pre>\n<ul>\n<li><code>mariadb-server<\/code>: MariaDB veritaban\u0131 sunucusunun kendisini kurar.<\/li>\n<li><code>mariadb-client<\/code>: Veritaban\u0131 ile etkile\u015fim kurmak i\u00e7in gerekli olan istemci ara\u00e7lar\u0131n\u0131 (\u00f6rne\u011fin, <code>mysql<\/code> komut sat\u0131r\u0131 arac\u0131) kurar.<\/li>\n<\/ul>\n<p>Kurulum tamamland\u0131ktan sonra, MariaDB hizmetinin \u00e7al\u0131\u015f\u0131p \u00e7al\u0131\u015fmad\u0131\u011f\u0131n\u0131 kontrol edebilirsiniz:<\/p>\n<pre><code class=\"language-bash\">systemctl status mariadb<\/code><\/pre>\n<p>\u00c7\u0131kt\u0131da &#8220;active (running)&#8221; ifadesini g\u00f6rmeniz, MariaDB&#8217;nin ba\u015far\u0131yla \u00e7al\u0131\u015ft\u0131\u011f\u0131 anlam\u0131na gelir.<\/p>\n<h3>MariaDB Resmi Depolar\u0131ndan Kurulum (Geli\u015fmi\u015f)<\/h3>\n<p>E\u011fer Debian 9&#8217;da MariaDB&#8217;nin daha g\u00fcncel bir s\u00fcr\u00fcm\u00fcn\u00fc (\u00f6rne\u011fin 10.4 veya 10.5) kullanman\u0131z gerekiyorsa, MariaDB&#8217;nin kendi resmi depolar\u0131n\u0131 eklemeniz gerekir. Bu y\u00f6ntem, Debian&#8217;\u0131n varsay\u0131lan depolar\u0131ndan daha yeni s\u00fcr\u00fcmler sunar.<\/p>\n<p>\u00d6ncelikle, MariaDB paketlerinin orijinalli\u011fini do\u011frulamak i\u00e7in GPG anahtar\u0131n\u0131 eklemelisiniz:<\/p>\n<pre><code class=\"language-bash\">sudo apt-get install software-properties-common dirmngr ca-certificates apt-transport-https -y\nsudo apt-key adv --recv-keys --keyserver hkp:\/\/keyserver.ubuntu.com:80 0xF1656F24C74CD10C<\/code><\/pre>\n<p>Ard\u0131ndan, MariaDB deposunu sisteminize ekleyin. Debian 9&#8217;un kod ad\u0131 &#8220;stretch&#8221; oldu\u011fu i\u00e7in, depo URL&#8217;sinde bu ad\u0131 kullanmal\u0131y\u0131z. Bu \u00f6rnekte MariaDB 10.3&#8217;\u00fc ekleyece\u011fiz, \u00e7\u00fcnk\u00fc bu s\u00fcr\u00fcm Debian 9 ile iyi uyumludur. Daha yeni s\u00fcr\u00fcmler i\u00e7in (\u00f6rne\u011fin 10.4 veya 10.5), ilgili s\u00fcr\u00fcm numaras\u0131n\u0131 de\u011fi\u015ftirebilirsiniz, ancak uyumlulu\u011fu kontrol etmeniz \u00f6nemlidir.<\/p>\n<pre><code class=\"language-bash\">sudo add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http:\/\/mirror.mariadb.org\/repo\/10.3\/debian stretch main'<\/code><\/pre>\n<p>Depoyu ekledikten sonra, paket listelerinizi g\u00fcncelleyin ve MariaDB&#8217;yi kurun:<\/p>\n<pre><code class=\"language-bash\">sudo apt update\nsudo apt install mariadb-server mariadb-client -y<\/code><\/pre>\n<p>Kurulumun ard\u0131ndan yine <code>systemctl status mariadb<\/code> komutuyla hizmetin durumunu kontrol edebilirsiniz.<\/p>\n<h2>MariaDB G\u00fcvenlik Ayarlar\u0131 ve Temel Yap\u0131land\u0131rma<\/h2>\n<p>MariaDB&#8217;yi kurduktan sonra yapman\u0131z gereken en \u00f6nemli ad\u0131mlardan biri, veritaban\u0131 sunucunuzu g\u00fcvence alt\u0131na almakt\u0131r. MariaDB, bu i\u015flemi kolayla\u015ft\u0131rmak i\u00e7in bir g\u00fcvenlik beti\u011fi sa\u011flar.<\/p>\n<h3><code>mysql_secure_installation<\/code> Kullan\u0131m\u0131<\/h3>\n<p>Bu betik, veritaban\u0131 sunucunuz i\u00e7in temel g\u00fcvenlik iyile\u015ftirmelerini yapman\u0131za yard\u0131mc\u0131 olur:<\/p>\n<pre><code class=\"language-bash\">sudo mysql_secure_installation<\/code><\/pre>\n<p>Bu komutu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda a\u015fa\u011f\u0131daki sorularla kar\u015f\u0131la\u015facaks\u0131n\u0131z:<\/p>\n<ol>\n<li><strong>Enter current password for root (enter for none):<\/strong> \u0130lk kurulumda root \u015fifresi olmad\u0131\u011f\u0131 i\u00e7in do\u011frudan Enter tu\u015funa basabilirsiniz.<\/li>\n<li><strong>Set root password? [Y\/n]:<\/strong> Root kullan\u0131c\u0131s\u0131 i\u00e7in g\u00fc\u00e7l\u00fc bir \u015fifre belirlemenizi kesinlikle \u00f6neririm. &#8216;Y&#8217; yaz\u0131p Enter&#8217;a bas\u0131n ve \u015fifrenizi iki kez girin.<\/li>\n<li><strong>Remove anonymous users? [Y\/n]:<\/strong> Anonim kullan\u0131c\u0131lar test ama\u00e7l\u0131d\u0131r ve \u00fcretim ortam\u0131nda g\u00fcvenlik riski olu\u015fturur. &#8216;Y&#8217; yazarak bunlar\u0131 kald\u0131r\u0131n.<\/li>\n<li><strong>Disallow root login remotely? [Y\/n]:<\/strong> Root kullan\u0131c\u0131s\u0131n\u0131n yaln\u0131zca yerel olarak ba\u011flanmas\u0131na izin vermek en iyi g\u00fcvenlik uygulamas\u0131d\u0131r. &#8216;Y&#8217; yazarak uzaktan root eri\u015fimini devre d\u0131\u015f\u0131 b\u0131rak\u0131n.<\/li>\n<li><strong>Remove test database and access to it? [Y\/n]:<\/strong> Test veritaban\u0131, g\u00fcvenlik a\u00e7\u0131klar\u0131 yaratabilecek gereksiz bir kaynakt\u0131r. &#8216;Y&#8217; yazarak kald\u0131r\u0131n.<\/li>\n<li><strong>Reload privilege tables now? [Y\/n]:<\/strong> Yap\u0131lan de\u011fi\u015fikliklerin hemen etkinle\u015fmesi i\u00e7in &#8216;Y&#8217; yaz\u0131n.<\/li>\n<\/ol>\n<p>Bu ad\u0131mlar\u0131 tamamlad\u0131ktan sonra MariaDB sunucunuzun temel g\u00fcvenlik ayarlar\u0131 yap\u0131lm\u0131\u015f olacakt\u0131r.<\/p>\n<h3>Yeni Veritaban\u0131 ve Kullan\u0131c\u0131 Olu\u015fturma<\/h3>\n<p>Veritaban\u0131 uygulamalar\u0131n\u0131z i\u00e7in do\u011frudan <code>root<\/code> kullan\u0131c\u0131s\u0131n\u0131 kullanmak yerine, her uygulama i\u00e7in ayr\u0131 bir veritaban\u0131 ve kullan\u0131c\u0131 olu\u015fturmak iyi bir g\u00fcvenlik ve y\u00f6netim uygulamas\u0131d\u0131r. Root kullan\u0131c\u0131s\u0131 ile MariaDB&#8217;ye ba\u011flan\u0131n:<\/p>\n<pre><code class=\"language-bash\">sudo mysql -u root -p<\/code><\/pre>\n<p>\u0130stendi\u011finde, <code>mysql_secure_installation<\/code> s\u0131ras\u0131nda belirledi\u011finiz root \u015fifresini girin.<\/p>\n<p>\u015eimdi bir veritaban\u0131 ve kullan\u0131c\u0131 olu\u015ftural\u0131m:<\/p>\n<pre><code class=\"language-sql\">CREATE DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;\nCREATE USER 'myuser'@'localhost' IDENTIFIED BY 'GucluSifreBuraya!';\nGRANT ALL PRIVILEGES ON mydatabase.* TO 'myuser'@'localhost';\nFLUSH PRIVILEGES;\nEXIT;<\/code><\/pre>\n<ul>\n<li><code>mydatabase<\/code>: Olu\u015fturaca\u011f\u0131n\u0131z veritaban\u0131n\u0131n ad\u0131.<\/li>\n<li><code>myuser<\/code>: Olu\u015fturaca\u011f\u0131n\u0131z kullan\u0131c\u0131n\u0131n ad\u0131.<\/li>\n<li><code>localhost<\/code>: Bu kullan\u0131c\u0131n\u0131n yaln\u0131zca yerel makineden ba\u011flanabilece\u011fini belirtir. Uzaktan eri\u015fim i\u00e7in &#8216;myuser&#8217;@&#8217;%&#8217; kullanabilirsiniz, ancak bu g\u00fcvenlik riski ta\u015f\u0131r ve dikkatli yap\u0131land\u0131r\u0131lmal\u0131d\u0131r.<\/li>\n<li><code>GucluSifreBuraya!<\/code>: Kullan\u0131c\u0131 i\u00e7in belirledi\u011finiz g\u00fc\u00e7l\u00fc \u015fifre.<\/li>\n<li><code>FLUSH PRIVILEGES;<\/code>: Ayr\u0131cal\u0131k tablolar\u0131n\u0131 yenileyerek de\u011fi\u015fikliklerin hemen uygulanmas\u0131n\u0131 sa\u011flar.<\/li>\n<\/ul>\n<p>Yeni kullan\u0131c\u0131 ile ba\u011flanarak test edebilirsiniz:<\/p>\n<pre><code class=\"language-bash\">mysql -u myuser -p<\/code><\/pre>\n<p>\u0130stendi\u011finde <code>myuser<\/code> i\u00e7in belirledi\u011finiz \u015fifreyi girin. Ba\u015far\u0131l\u0131 bir \u015fekilde ba\u011flan\u0131rsan\u0131z, yeni kullan\u0131c\u0131n\u0131z\u0131n \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 do\u011frulam\u0131\u015f olursunuz.<\/p>\n<h2>MariaDB Y\u00f6netimi ve Ek \u0130pu\u00e7lar\u0131<\/h2>\n<p>MariaDB&#8217;yi kurduktan ve g\u00fcvence alt\u0131na ald\u0131ktan sonra, sunucuyu nas\u0131l y\u00f6netece\u011finizi ve performans\u0131n\u0131 nas\u0131l optimize edece\u011finizi bilmek \u00f6nemlidir.<\/p>\n<h3>MariaDB Hizmetini Y\u00f6netme<\/h3>\n<p><code>systemctl<\/code> komutu ile MariaDB hizmetini kolayca y\u00f6netebilirsiniz:<\/p>\n<pre><code class=\"language-bash\"># MariaDB hizmetini ba\u015flatma\nsudo systemctl start mariadb\n\n<h2>MariaDB hizmetini durdurma<\/h2>\nsudo systemctl stop mariadb\n\n<h2>MariaDB hizmetini yeniden ba\u015flatma<\/h2>\nsudo systemctl restart mariadb\n\n<h2>MariaDB hizmetinin durumunu kontrol etme<\/h2>\nsudo systemctl status mariadb\n\n<h2>Sistem ba\u015flang\u0131c\u0131nda MariaDB'nin otomatik ba\u015flamas\u0131n\u0131 sa\u011flama<\/h2>\nsudo systemctl enable mariadb\n\n<h2>Sistem ba\u015flang\u0131c\u0131nda MariaDB'nin otomatik ba\u015flamas\u0131n\u0131 devre d\u0131\u015f\u0131 b\u0131rakma<\/h2>\nsudo systemctl disable mariadb<\/code><\/pre>\n<h3>MariaDB Yap\u0131land\u0131rma Dosyalar\u0131<\/h3>\n<p>MariaDB&#8217;nin ana yap\u0131land\u0131rma dosyas\u0131 genellikle <code>\/etc\/mysql\/my.cnf<\/code> veya <code>\/etc\/mysql\/mariadb.conf.d\/50-server.cnf<\/code> gibi bir konumda bulunur. Bu dosyalar, veritaban\u0131 sunucusunun davran\u0131\u015f\u0131n\u0131 ve performans\u0131n\u0131 etkileyen \u00e7e\u015fitli ayarlar\u0131 i\u00e7erir.<\/p>\n<p>\u00d6rne\u011fin, uzaktan eri\u015fimi etkinle\u015ftirmek isterseniz (g\u00fcvenlik duvar\u0131 kurallar\u0131n\u0131 da ayarlaman\u0131z gerekti\u011fini unutmay\u0131n), <code>bind-address<\/code> sat\u0131r\u0131n\u0131 bulup yorum sat\u0131r\u0131 yapman\u0131z veya sunucunuzun IP adresine ayarlaman\u0131z gerekebilir:<\/p>\n<pre><code class=\"language-ini\">[mysqld]\n#bind-address = 127.0.0.1  # Bu sat\u0131r\u0131 yorum sat\u0131r\u0131 yap\u0131n veya sunucunuzun IP adresine ayarlay\u0131n\nbind-address = 0.0.0.0    # T\u00fcm aray\u00fczlerden dinlemek i\u00e7in (dikkatli kullan\u0131n!)<\/code><\/pre>\n<p>Bu de\u011fi\u015fiklikleri yapt\u0131ktan sonra MariaDB hizmetini yeniden ba\u015flatmay\u0131 unutmay\u0131n: <code>sudo systemctl restart mariadb<\/code>.<\/p>\n<h3>Yedekleme Stratejileri<\/h3>\n<p>Verilerinizin g\u00fcvenli\u011fi i\u00e7in d\u00fczenli yedeklemeler yapmak hayati \u00f6nem ta\u015f\u0131r. <code>mysqldump<\/code> arac\u0131, MariaDB veritabanlar\u0131n\u0131z\u0131 yedeklemek i\u00e7in g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r:<\/p>\n<pre><code class=\"language-bash\"># Belirli bir veritaban\u0131n\u0131 yedekleme\nsudo mysqldump -u root -p mydatabase > mydatabase_yedek.sql\n\n<h2>T\u00fcm veritabanlar\u0131n\u0131 yedekleme<\/h2>\nsudo mysqldump -u root -p --all-databases > tum_veritabanlari_yedek.sql<\/code><\/pre>\n<p>Yedekleri g\u00fcvenli bir yerde saklad\u0131\u011f\u0131n\u0131zdan ve periyodik olarak geri y\u00fckleme testleri yapt\u0131\u011f\u0131n\u0131zdan emin olun.<\/p>\n<h2>Sonu\u00e7<\/h2>\n<p>Bu rehberde, Debian 9 sisteminize MariaDB&#8217;yi nas\u0131l kuraca\u011f\u0131n\u0131z\u0131, temel g\u00fcvenlik ayarlar\u0131n\u0131 nas\u0131l yapaca\u011f\u0131n\u0131z\u0131 ve veritaban\u0131 sunucunuzu nas\u0131l y\u00f6netece\u011finizi ayr\u0131nt\u0131l\u0131 olarak ele ald\u0131k. MariaDB&#8217;nin sa\u011flam bir veritaban\u0131 \u00e7\u00f6z\u00fcm\u00fc oldu\u011funu ve do\u011fru yap\u0131land\u0131rma ile uygulamalar\u0131n\u0131z i\u00e7in g\u00fcvenilir bir temel olu\u015fturdu\u011funu unutmay\u0131n. Her zaman en iyi g\u00fcvenlik uygulamalar\u0131n\u0131 takip edin ve verilerinizi d\u00fczenli olarak yedekleyin.<\/p>\n<h3>S\u0131k\u00e7a Sorulan Sorular (SSS)<\/h3>\n<h4>Q1: MariaDB ve MySQL aras\u0131ndaki fark nedir?<\/h4>\n<p><strong>A1:<\/strong> MariaDB, MySQL&#8217;in a\u00e7\u0131k kaynakl\u0131 bir fork&#8217;udur. Oracle&#8217;\u0131n MySQL&#8217;i sat\u0131n almas\u0131ndan sonra topluluk taraf\u0131ndan geli\u015ftirilmeye devam etmi\u015ftir. Temel olarak uyumlu olsalar da, MariaDB genellikle daha fazla depolama motoru se\u00e7ene\u011fi (\u00f6rne\u011fin Aria, XtraDB), performans iyile\u015ftirmeleri ve yeni \u00f6zellikler sunar. \u00c7o\u011fu uygulama i\u00e7in MySQL ile do\u011frudan de\u011fi\u015ftirilebilir.<\/p>\n<h4>Q2: Root \u015fifresini unutursam ne yapmal\u0131y\u0131m?<\/h4>\n<p><strong>A2:<\/strong> MariaDB root \u015fifresini unutursan\u0131z, MariaDB hizmetini g\u00fcvenli modda (\u015fifresiz eri\u015fimle) ba\u015flatarak \u015fifreyi s\u0131f\u0131rlayabilirsiniz. Bu i\u015flem genellikle MariaDB hizmetini durdurmay\u0131, yap\u0131land\u0131rma dosyas\u0131n\u0131 d\u00fczenleyerek <code>skip-grant-tables<\/code> eklemeyi, hizmeti yeniden ba\u015flatmay\u0131, \u015fifreyi de\u011fi\u015ftirmeyi ve ard\u0131ndan yap\u0131land\u0131rma dosyas\u0131n\u0131 eski haline getirip hizmeti tekrar ba\u015flatmay\u0131 i\u00e7erir.<\/p>\n<h4>Q3: Uzaktan eri\u015fimi nas\u0131l etkinle\u015ftiririm?<\/h4>\n<p><strong>A3:<\/strong> Uzaktan eri\u015fimi etkinle\u015ftirmek i\u00e7in iki ana ad\u0131m vard\u0131r:<\/p>\n<ol>\n<li>MariaDB yap\u0131land\u0131rma dosyas\u0131nda (\u00f6rn. <code>\/etc\/mysql\/mariadb.conf.d\/50-server.cnf<\/code>) <code>bind-address = 127.0.0.1<\/code> sat\u0131r\u0131n\u0131 <code>bind-address = 0.0.0.0<\/code> olarak de\u011fi\u015ftirin veya yorum sat\u0131r\u0131 yap\u0131n. Ard\u0131ndan MariaDB hizmetini yeniden ba\u015flat\u0131n.<\/li>\n<li>Uzak bir IP adresinden ba\u011flanabilen bir MariaDB kullan\u0131c\u0131s\u0131 olu\u015fturun veya mevcut bir kullan\u0131c\u0131n\u0131n ayr\u0131cal\u0131klar\u0131n\u0131 g\u00fcncelleyin (\u00f6rn. <code>GRANT ALL PRIVILEGES ON mydatabase.* TO 'myuser'@'%' IDENTIFIED BY 'password';<\/code>).<\/li>\n<li>Sunucunuzun g\u00fcvenlik duvar\u0131nda (\u00f6rn. UFW veya iptables) MariaDB&#8217;nin varsay\u0131lan portu olan 3306&#8217;ya gelen ba\u011flant\u0131lara izin verin.<\/li>\n<\/ol>\n<h4>Q4: MariaDB hangi portu kullan\u0131r?<\/h4>\n<p><strong>A4:<\/strong> MariaDB, varsay\u0131lan olarak TCP portu <code>3306<\/code>&#8216;y\u0131 kullan\u0131r.<\/p>\n<h4>Q5: Debian 9&#8217;da MariaDB&#8217;nin hangi s\u00fcr\u00fcm\u00fcn\u00fc kurdum?<\/h4>\n<p><strong>A5:<\/strong> Kurdu\u011funuz MariaDB s\u00fcr\u00fcm\u00fcn\u00fc kontrol etmek i\u00e7in MariaDB istemcisine ba\u011flan\u0131p a\u015fa\u011f\u0131daki komutu \u00e7al\u0131\u015ft\u0131rabilirsiniz:<\/p>\n<pre><code class=\"language-sql\">SELECT VERSION();<\/code><\/pre>\n<p>Veya komut sat\u0131r\u0131ndan:<\/p>\n<pre><code class=\"language-bash\">mysql -V<\/code><\/pre>\n<p>Bu komutlar, MariaDB sunucusunun veya istemcisinin s\u00fcr\u00fcm bilgilerini g\u00f6sterecektir.<\/p>\n<p><\/body><\/p>\n","protected":false},"excerpt":{"rendered":"MariaDB Nedir ve Neden Debian 9&#8217;da Kullanmal\u0131s\u0131n\u0131z?\nMariaDB, MySQL&#8217;in topluluk taraf\u0131ndan geli\u015ftirilen, a\u00e7\u0131k kaynakl\u0131 ve olduk\u00e7a uyumlu bir","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_page_header_type":"","csco_page_load_nextpost":"","csco_page_subscribe_form":"","csco_page_contact_form":"","footnotes":""},"categories":[241],"tags":[],"class_list":{"0":"post-31210","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-linux","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.5 (Yoast SEO v25.3.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MariaDB Nedir ve Neden Debian 9&#039;da Kullanmal\u0131s\u0131n\u0131z? - Kodlar\u0131n Gizemli D\u00fcnyas\u0131<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-debian-9da-kullanmalisiniz\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MariaDB Nedir ve Neden Debian 9&#039;da Kullanmal\u0131s\u0131n\u0131z?\" \/>\n<meta property=\"og:description\" content=\"MariaDB Nedir ve Neden Debian 9&#039;da Kullanmal\u0131s\u0131n\u0131z? MariaDB, MySQL&#039;in topluluk taraf\u0131ndan geli\u015ftirilen, a\u00e7\u0131k kaynakl\u0131 ve olduk\u00e7a uyumlu bir\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-debian-9da-kullanmalisiniz\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-10-07T04:41:46+00:00\" \/>\n<meta name=\"author\" content=\"Fatih Soysal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fatih Soysal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-debian-9da-kullanmalisiniz\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-debian-9da-kullanmalisiniz\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"MariaDB Nedir ve Neden Debian 9&#8217;da Kullanmal\u0131s\u0131n\u0131z?\",\"datePublished\":\"2025-10-07T04:41:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-debian-9da-kullanmalisiniz\/\"},\"wordCount\":1613,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"articleSection\":[\"Linux\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-debian-9da-kullanmalisiniz\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-debian-9da-kullanmalisiniz\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-debian-9da-kullanmalisiniz\/\",\"name\":\"MariaDB Nedir ve Neden Debian 9'da Kullanmal\u0131s\u0131n\u0131z? - Kodlar\u0131n Gizemli D\u00fcnyas\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-10-07T04:41:46+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-debian-9da-kullanmalisiniz\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-debian-9da-kullanmalisiniz\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-debian-9da-kullanmalisiniz\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MariaDB Nedir ve Neden Debian 9&#8217;da Kullanmal\u0131s\u0131n\u0131z?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/\",\"name\":\"Fatihsoysal.com\",\"description\":\"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim\",\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\",\"name\":\"Fatih Soysal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"width\":512,\"height\":512,\"caption\":\"Fatih Soysal\"},\"logo\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MariaDB Nedir ve Neden Debian 9'da Kullanmal\u0131s\u0131n\u0131z? - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","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:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-debian-9da-kullanmalisiniz\/","og_locale":"tr_TR","og_type":"article","og_title":"MariaDB Nedir ve Neden Debian 9'da Kullanmal\u0131s\u0131n\u0131z?","og_description":"MariaDB Nedir ve Neden Debian 9'da Kullanmal\u0131s\u0131n\u0131z? MariaDB, MySQL'in topluluk taraf\u0131ndan geli\u015ftirilen, a\u00e7\u0131k kaynakl\u0131 ve olduk\u00e7a uyumlu bir","og_url":"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-debian-9da-kullanmalisiniz\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-10-07T04:41:46+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"10 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-debian-9da-kullanmalisiniz\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-debian-9da-kullanmalisiniz\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"MariaDB Nedir ve Neden Debian 9&#8217;da Kullanmal\u0131s\u0131n\u0131z?","datePublished":"2025-10-07T04:41:46+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-debian-9da-kullanmalisiniz\/"},"wordCount":1613,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"articleSection":["Linux"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-debian-9da-kullanmalisiniz\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-debian-9da-kullanmalisiniz\/","url":"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-debian-9da-kullanmalisiniz\/","name":"MariaDB Nedir ve Neden Debian 9'da Kullanmal\u0131s\u0131n\u0131z? - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-10-07T04:41:46+00:00","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-debian-9da-kullanmalisiniz\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-debian-9da-kullanmalisiniz\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-debian-9da-kullanmalisiniz\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MariaDB Nedir ve Neden Debian 9&#8217;da Kullanmal\u0131s\u0131n\u0131z?"}]},{"@type":"WebSite","@id":"https:\/\/fatihsoysal.com\/blog\/#website","url":"https:\/\/fatihsoysal.com\/blog\/","name":"Fatihsoysal.com","description":"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim","publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1","name":"Fatih Soysal","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","width":512,"height":512,"caption":"Fatih Soysal"},"logo":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/"},"description":"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.","url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/"}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/31210","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/comments?post=31210"}],"version-history":[{"count":1,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/31210\/revisions"}],"predecessor-version":[{"id":31211,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/31210\/revisions\/31211"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=31210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=31210"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=31210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}