MariaDB, MySQL veritaban\u0131 y\u00f6netim sisteminin topluluk taraf\u0131ndan geli\u015ftirilen, a\u00e7\u0131k kaynakl\u0131 bir “fork”udur (\u00e7atallanm\u0131\u015f versiyonu). MySQL’in Oracle taraf\u0131ndan sat\u0131n al\u0131nmas\u0131n\u0131n ard\u0131ndan, a\u00e7\u0131k kaynak toplulu\u011fu taraf\u0131ndan projenin \u00f6zg\u00fcr ve a\u00e7\u0131k kalmas\u0131n\u0131 sa\u011flamak amac\u0131yla ba\u015flat\u0131lm\u0131\u015ft\u0131r. MariaDB, MySQL ile y\u00fcksek derecede uyumlulu\u011fa sahiptir, bu da mevcut MySQL uygulamalar\u0131n\u0131n MariaDB’ye kolayca ta\u015f\u0131nabilece\u011fi anlam\u0131na gelir. Performans, g\u00fcvenlik ve yeni \u00f6zellikler a\u00e7\u0131s\u0131ndan s\u00fcrekli geli\u015ftirilen MariaDB, \u00f6zellikle web uygulamalar\u0131, kurumsal \u00e7\u00f6z\u00fcmler ve b\u00fcy\u00fck veri projeleri i\u00e7in pop\u00fcler bir se\u00e7imdir.<\/p>\n
Debian 11 (Bullseye) ise, kararl\u0131l\u0131\u011f\u0131, g\u00fcvenilirli\u011fi ve geni\u015f paket deposuyla bilinen pop\u00fcler bir Linux da\u011f\u0131t\u0131m\u0131d\u0131r. MariaDB’yi Debian 11 \u00fczerine kurmak, g\u00fc\u00e7l\u00fc bir veritaban\u0131 altyap\u0131s\u0131n\u0131 sa\u011flam ve g\u00fcncel bir i\u015fletim sistemiyle birle\u015ftirmek anlam\u0131na gelir. Bu rehberde, MariaDB’yi Debian 11 sisteminize ad\u0131m ad\u0131m nas\u0131l kuraca\u011f\u0131n\u0131z\u0131, temel g\u00fcvenlik yap\u0131land\u0131rmalar\u0131n\u0131 nas\u0131l yapaca\u011f\u0131n\u0131z\u0131 ve veritaban\u0131 y\u00f6netiminin temellerini nas\u0131l ger\u00e7ekle\u015ftirece\u011finizi \u00f6\u011freneceksiniz.<\/p>\n
MariaDB kurulumuna ba\u015flamadan \u00f6nce sisteminizin haz\u0131r oldu\u011fundan emin olmak \u00f6nemlidir. Bu ad\u0131mlar, sorunsuz bir kurulum s\u00fcreci i\u00e7in zemin haz\u0131rlar.<\/p>\n
Herhangi bir yaz\u0131l\u0131m kurulumuna ba\u015flamadan \u00f6nce, sisteminizin paket listesini g\u00fcncellemek ve mevcut paketleri y\u00fckseltmek iyi bir uygulamad\u0131r. Bu, en son g\u00fcvenlik yamalar\u0131na ve yaz\u0131l\u0131m d\u00fczeltmelerine sahip olman\u0131z\u0131 sa\u011flar ve olas\u0131 ba\u011f\u0131ml\u0131l\u0131k sorunlar\u0131n\u0131 \u00f6nler.<\/p>\n
sudo apt update\nsudo apt upgrade -y<\/code><\/pre>\n\nsudo apt update<\/code>: Sisteminizin paket indekslerini g\u00fcnceller. Bu, mevcut paketlerin en son s\u00fcr\u00fcmleri ve yeni paketler hakk\u0131nda bilgi edinmek i\u00e7in gereklidir.<\/li>\nsudo apt upgrade -y<\/code>: Mevcut y\u00fckl\u00fc paketleri en son s\u00fcr\u00fcmlerine y\u00fckseltir. -y<\/code> parametresi, y\u00fckseltme s\u0131ras\u0131nda sorulan t\u00fcm onay sorular\u0131na otomatik olarak “evet” yan\u0131t\u0131 verir.<\/li>\n<\/ul>\nAyr\u0131ca, bu rehberdeki komutlar\u0131 \u00e7al\u0131\u015ft\u0131rmak i\u00e7in sudo<\/code> yetkilerine sahip bir kullan\u0131c\u0131 olman\u0131z gerekmektedir. E\u011fer sudo<\/code> yetkilerine sahip de\u011filseniz, sistem y\u00f6neticinizle ileti\u015fime ge\u00e7meniz veya root kullan\u0131c\u0131s\u0131na ge\u00e7meniz gerekebilir (ancak root kullan\u0131c\u0131s\u0131 olarak do\u011frudan \u00e7al\u0131\u015fmak genellikle \u00f6nerilmez).<\/p>\nMariaDB Kurulumu<\/h2>\n
Sisteminiz haz\u0131r oldu\u011funda, MariaDB sunucusunu kurmaya ba\u015flayabiliriz. Debian’\u0131n resmi depolar\u0131, MariaDB’nin kararl\u0131 bir s\u00fcr\u00fcm\u00fcn\u00fc i\u00e7erir, bu da kurulumu son derece basit hale getirir.<\/p>\n
MariaDB Sunucusunun Kurulmas\u0131<\/h3>\n
MariaDB sunucusunu ve gerekli istemci ara\u00e7lar\u0131n\u0131 kurmak i\u00e7in a\u015fa\u011f\u0131daki komutu kullan\u0131n:<\/p>\n
sudo apt install mariadb-server mariadb-client -y<\/code><\/pre>\n\nmariadb-server<\/code>: MariaDB veritaban\u0131 sunucusunun kendisini kurar. Bu paket, veritaban\u0131 motorunu, y\u00f6netim ara\u00e7lar\u0131n\u0131 ve gerekli ba\u011f\u0131ml\u0131l\u0131klar\u0131 i\u00e7erir.<\/li>\nmariadb-client<\/code>: MariaDB veritaban\u0131 sunucusuna ba\u011flanmak ve onunla etkile\u015fim kurmak i\u00e7in kullan\u0131lan istemci ara\u00e7lar\u0131n\u0131 (\u00f6rne\u011fin, mysql<\/code> komut sat\u0131r\u0131 arac\u0131) kurar. Genellikle mariadb-server<\/code> paketi ile birlikte gelir, ancak a\u00e7\u0131k\u00e7a belirtmek zarar vermez.<\/li>\n<\/ul>\nKurulum tamamland\u0131ktan sonra, MariaDB servisi otomatik olarak ba\u015flat\u0131lmal\u0131 ve sistem a\u00e7\u0131l\u0131\u015f\u0131nda otomatik olarak ba\u015flamak \u00fczere yap\u0131land\u0131r\u0131lmal\u0131d\u0131r. Bu durumu kontrol edebiliriz.<\/p>\n
MariaDB Servisini Kontrol Etme<\/h3>\n
MariaDB servisinin durumunu kontrol etmek i\u00e7in systemctl<\/code> komutunu kullan\u0131n:<\/p>\nsystemctl status mariadb<\/code><\/pre>\n\u00c7\u0131kt\u0131, servisin aktif (running) olup olmad\u0131\u011f\u0131n\u0131 g\u00f6stermelidir. Ye\u015fil renkte “active (running)” ifadesini g\u00f6rmelisiniz. E\u011fer servis \u00e7al\u0131\u015fm\u0131yorsa, a\u015fa\u011f\u0131daki komutlarla ba\u015flatabilir ve otomatik ba\u015flatmay\u0131 etkinle\u015ftirebilirsiniz:<\/p>\n
sudo systemctl start mariadb\nsudo systemctl enable mariadb<\/code><\/pre>\n\nsudo systemctl start mariadb<\/code>: MariaDB servisini ba\u015flat\u0131r.<\/li>\nsudo systemctl enable mariadb<\/code>: MariaDB servisinin sistem her ba\u015flat\u0131ld\u0131\u011f\u0131nda otomatik olarak ba\u015flamas\u0131n\u0131 sa\u011flar.<\/li>\n<\/ul>\nMariaDB G\u00fcvenlik Yap\u0131land\u0131rmas\u0131<\/h3>\n
MariaDB kurulumundan sonra yap\u0131lmas\u0131 gereken en kritik ad\u0131mlardan biri g\u00fcvenlik yap\u0131land\u0131rmas\u0131d\u0131r. MariaDB, g\u00fcvenlik a\u00e7\u0131klar\u0131n\u0131 gidermek ve sunucunuzu daha g\u00fcvenli hale getirmek i\u00e7in \u00f6zel bir betik sa\u011flar: mysql_secure_installation<\/code>.<\/p>\nsudo mysql_secure_installation<\/code><\/pre>\nBu beti\u011fi \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda size bir dizi soru sorulacakt\u0131r. \u0130\u015fte bu sorular ve \u00f6nerilen yan\u0131tlar:<\/p>\n
\n- Enter current password for root (enter for none):<\/strong> MariaDB’nin root kullan\u0131c\u0131s\u0131 i\u00e7in mevcut bir \u015fifre isteyecektir. Yeni bir kurulum yapt\u0131\u011f\u0131n\u0131z i\u00e7in genellikle bo\u015f b\u0131rak\u0131p Enter tu\u015funa basabilirsiniz.<\/li>\n
- Set root password? [Y\/n]:<\/strong> MariaDB’nin root kullan\u0131c\u0131s\u0131 i\u00e7in bir \u015fifre belirlemek isteyip istemedi\u011finizi sorar. Kesinlikle
Y<\/code> yaz\u0131p Enter’a bas\u0131n ve g\u00fc\u00e7l\u00fc bir \u015fifre belirleyin. Bu \u015fifre, veritaban\u0131 sunucusunun en yetkili kullan\u0131c\u0131s\u0131 i\u00e7in olacakt\u0131r. \u015eifreyi iki kez girmeniz istenecektir.<\/li>\n- Remove anonymous users? [Y\/n]:<\/strong> Anonim kullan\u0131c\u0131lar, herkesin kullan\u0131c\u0131 ad\u0131 veya \u015fifre olmadan MariaDB’ye ba\u011flanmas\u0131na izin verir. Bu bir g\u00fcvenlik riski oldu\u011fundan,
Y<\/code> yaz\u0131p Enter’a basarak bunlar\u0131 kald\u0131rmal\u0131s\u0131n\u0131z.<\/li>\n- Disallow root login remotely? [Y\/n]:<\/strong> MariaDB root kullan\u0131c\u0131s\u0131n\u0131n sadece
localhost<\/code>‘tan (yani sunucunun kendisinden) ba\u011flanmas\u0131na izin vermek, uzaktan yetkisiz eri\u015fimi engeller. Genellikle Y<\/code> yaz\u0131p Enter’a basarak uzaktan root giri\u015fini devre d\u0131\u015f\u0131 b\u0131rakmak iyi bir g\u00fcvenlik uygulamas\u0131d\u0131r. E\u011fer gelecekte uzaktan root eri\u015fimine ihtiyac\u0131n\u0131z olursa, daha sonra bunu yap\u0131land\u0131rma dosyas\u0131ndan de\u011fi\u015ftirebilirsiniz, ancak ba\u015flang\u0131\u00e7ta devre d\u0131\u015f\u0131 b\u0131rakmak en g\u00fcvenlisidir.<\/li>\n- Remove test database and access to it? [Y\/n]:<\/strong> MariaDB, test ama\u00e7l\u0131 bir veritaban\u0131 ile birlikte gelir. \u00dcretim ortamlar\u0131nda buna ihtiya\u00e7 yoktur ve potansiyel bir g\u00fcvenlik a\u00e7\u0131\u011f\u0131 olabilir.
Y<\/code> yaz\u0131p Enter’a basarak kald\u0131r\u0131n.<\/li>\n- Reload privilege tables now? [Y\/n]:<\/strong> Yukar\u0131daki de\u011fi\u015fikliklerin hemen etkili olmas\u0131 i\u00e7in yetki tablolar\u0131n\u0131n yeniden y\u00fcklenmesi gerekir.
Y<\/code> yaz\u0131p Enter’a basarak onaylay\u0131n.<\/li>\n<\/ol>\nBu ad\u0131mlar\u0131 tamamlad\u0131\u011f\u0131n\u0131zda, MariaDB kurulumunuz temel g\u00fcvenlik \u00f6nlemleriyle g\u00fc\u00e7lendirilmi\u015f olacakt\u0131r. Belirledi\u011finiz root \u015fifresini g\u00fcvenli bir yerde saklamay\u0131 unutmay\u0131n.<\/p>\n
MariaDB Kullan\u0131m\u0131na Ba\u015flama ve Temel Y\u00f6netim<\/h2>\n
MariaDB sunucunuz kurulup g\u00fcvenli hale getirildikten sonra, veritabanlar\u0131yla \u00e7al\u0131\u015fmaya ba\u015flayabilirsiniz.<\/p>\n
MariaDB Kabu\u011funa Ba\u011flanma<\/h3>\n
MariaDB root kullan\u0131c\u0131s\u0131 olarak kabu\u011fa ba\u011flanmak i\u00e7in a\u015fa\u011f\u0131daki komutu kullan\u0131n:<\/p>\n
mysql -u root -p<\/code><\/pre>\nKomutu \u00e7al\u0131\u015ft\u0131rd\u0131ktan sonra, mysql_secure_installation<\/code> s\u0131ras\u0131nda belirledi\u011finiz root \u015fifresini girmeniz istenecektir. Do\u011fru \u015fifreyi girdi\u011finizde MariaDB komut istemine (MariaDB [(none)]><\/code>) y\u00f6nlendirileceksiniz.<\/p>\nYeni Bir Veritaban\u0131 ve Kullan\u0131c\u0131 Olu\u015fturma<\/h3>\n
MariaDB’de do\u011frudan root kullan\u0131c\u0131s\u0131yla \u00e7al\u0131\u015fmak yerine, her uygulama veya proje i\u00e7in ayr\u0131 bir veritaban\u0131 ve buna \u00f6zel bir kullan\u0131c\u0131 olu\u015fturmak en iyi uygulamad\u0131r. Bu, yetkilendirmeyi daha iyi y\u00f6netmenizi ve g\u00fcvenlik risklerini azaltman\u0131z\u0131 sa\u011flar.<\/p>\n
MariaDB kabu\u011funda a\u015fa\u011f\u0131daki SQL komutlar\u0131n\u0131 \u00e7al\u0131\u015ft\u0131r\u0131n:<\/p>\n
CREATE DATABASE ornek_veritabani;<\/code><\/pre>\nBu komut, ornek_veritabani<\/code> ad\u0131nda yeni bir veritaban\u0131 olu\u015fturur.<\/p>\nCREATE USER 'ornek_kullanici'@'localhost' IDENTIFIED BY 'GucluSifreBuraya!';<\/code><\/pre>\nBu komut, ornek_kullanici<\/code> ad\u0131nda ve sadece localhost<\/code>‘tan ba\u011flanabilen yeni bir kullan\u0131c\u0131 olu\u015fturur. 'GucluSifreBuraya!'<\/code> k\u0131sm\u0131n\u0131 kendi g\u00fc\u00e7l\u00fc \u015fifrenizle de\u011fi\u015ftirin.<\/p>\nGRANT ALL PRIVILEGES ON ornek_veritabani.* TO 'ornek_kullanici'@'localhost';<\/code><\/pre>\nBu komut, ornek_kullanici<\/code>‘ya ornek_veritabani<\/code> \u00fczerindeki t\u00fcm yetkileri verir. Bu, kullan\u0131c\u0131n\u0131n bu veritaban\u0131nda tablo olu\u015fturma, veri ekleme, g\u00fcncelleme ve silme gibi t\u00fcm i\u015flemleri yapabilmesini sa\u011flar.<\/p>\nFLUSH PRIVILEGES;<\/code><\/pre>\nBu komut, yetki tablolar\u0131n\u0131 yeniden y\u00fckleyerek yapt\u0131\u011f\u0131n\u0131z de\u011fi\u015fikliklerin hemen etkili olmas\u0131n\u0131 sa\u011flar.<\/p>\n
EXIT;<\/code><\/pre>\nBu komut, MariaDB kabu\u011fundan \u00e7\u0131kar.<\/p>\n
\u015eimdi yeni olu\u015fturdu\u011funuz kullan\u0131c\u0131 ile ba\u011flanmay\u0131 deneyebilirsiniz:<\/p>\n
mysql -u ornek_kullanici -p<\/code><\/pre>\nBelirledi\u011finiz \u015fifreyi girerek ba\u011flanmal\u0131s\u0131n\u0131z. Ba\u011fland\u0131ktan sonra, sadece yetki verdi\u011finiz ornek_veritabani<\/code> \u00fczerinde i\u015flem yapabilirsiniz.<\/p>\nTemel Veritaban\u0131 Y\u00f6netimi Komutlar\u0131<\/h3>\n
MariaDB kabu\u011funda kullanabilece\u011finiz baz\u0131 temel komutlar:<\/p>\n
SHOW DATABASES;<\/code><\/pre>\nSistemdeki t\u00fcm veritabanlar\u0131n\u0131 listeler.<\/p>\n
USE ornek_veritabani;<\/code><\/pre>\nBelirli bir veritaban\u0131n\u0131 se\u00e7er, b\u00f6ylece sonraki komutlar o veritaban\u0131 \u00fczerinde \u00e7al\u0131\u015f\u0131r.<\/p>\n
CREATE TABLE kullanicilar (\n id INT AUTO_INCREMENT PRIMARY KEY,\n ad VARCHAR(50) NOT NULL,\n email VARCHAR(100) UNIQUE NOT NULL,\n kayit_tarihi TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n);<\/code><\/pre>\nSe\u00e7ili veritaban\u0131nda kullanicilar<\/code> ad\u0131nda bir tablo olu\u015fturur.<\/p>\nINSERT INTO kullanicilar (ad, email) VALUES ('Ali Can', 'ali.can@example.com');\nINSERT INTO kullanicilar (ad, email) VALUES ('Ay\u015fe Y\u0131lmaz', 'ayse.yilmaz@example.com');<\/code><\/pre>\nkullanicilar<\/code> tablosuna iki \u00f6rnek kay\u0131t ekler.<\/p>\nSELECT * FROM kullanicilar;<\/code><\/pre>\nkullanicilar<\/code> tablosundaki t\u00fcm kay\u0131tlar\u0131 g\u00f6sterir.<\/p>\nDROP DATABASE ornek_veritabani;<\/code><\/pre>\nornek_veritabani<\/code> adl\u0131 veritaban\u0131n\u0131 ve i\u00e7indeki t\u00fcm tablolar\u0131 ve verileri siler. Bu komutu kullan\u0131rken \u00e7ok dikkatli olun<\/strong>, \u00e7\u00fcnk\u00fc geri al\u0131namaz bir i\u015flemdir.<\/p>\nMariaDB Servisini Y\u00f6netme<\/h3>\n
MariaDB servisini ba\u015flatma, durdurma ve yeniden ba\u015flatma gibi i\u015flemleri systemctl<\/code> ile yapabilirsiniz:<\/p>\nsudo systemctl stop mariadb # MariaDB servisini durdurur\nsudo systemctl start mariadb # MariaDB servisini ba\u015flat\u0131r\nsudo systemctl restart mariadb # MariaDB servisini yeniden ba\u015flat\u0131r (durdurur ve tekrar ba\u015flat\u0131r)\nsudo systemctl disable mariadb # MariaDB servisinin sistem a\u00e7\u0131l\u0131\u015f\u0131nda otomatik ba\u015flamas\u0131n\u0131 engeller (dikkatli kullan\u0131lmal\u0131)<\/code><\/pre>\nSonu\u00e7 ve S\u0131k\u00e7a Sorulan Sorular (SSS)<\/h2>\n
Tebrikler! Debian 11 sisteminize MariaDB’yi ba\u015far\u0131yla kurdunuz, g\u00fcvenlik yap\u0131land\u0131rmalar\u0131n\u0131 yapt\u0131n\u0131z ve temel veritaban\u0131 y\u00f6netimi i\u015flemlerini \u00f6\u011frendiniz. MariaDB, g\u00fc\u00e7l\u00fc, esnek ve g\u00fcvenilir bir veritaban\u0131 \u00e7\u00f6z\u00fcm\u00fcd\u00fcr ve bu rehberle, uygulamalar\u0131n\u0131z i\u00e7in sa\u011flam bir temel atm\u0131\u015f oldunuz. Daha ileri seviye konular i\u00e7in MariaDB’nin resmi belgelerine ba\u015fvurabilir, yedekleme, replikasyon ve performans optimizasyonu gibi konular\u0131 ara\u015ft\u0131rabilirsiniz.<\/p>\n
S\u0131k\u00e7a Sorulan Sorular (SSS)<\/h3>\nQ1: Debian 11’de hangi MariaDB s\u00fcr\u00fcm\u00fc y\u00fcklendi\u011fini nas\u0131l kontrol edebilirim?<\/h4>\n
MariaDB kabu\u011funa ba\u011flanarak veya komut sat\u0131r\u0131ndan kontrol edebilirsiniz:<\/p>\n
mysql -V<\/code><\/pre>\nVeya MariaDB kabu\u011funda:<\/p>\n
SELECT VERSION();<\/code><\/pre>\nBu komutlar y\u00fckl\u00fc MariaDB sunucusunun s\u00fcr\u00fcm\u00fcn\u00fc g\u00f6sterecektir.<\/p>\n
Q2: MariaDB’ye uzaktan ba\u011flant\u0131ya izin vermek i\u00e7in ne yapmal\u0131y\u0131m?<\/h4>\n
Varsay\u0131lan olarak, g\u00fcvenlik nedeniyle MariaDB sadece localhost<\/code>‘tan ba\u011flant\u0131lara izin verir. Uzaktan ba\u011flant\u0131ya izin vermek i\u00e7in:<\/p>\n\n- MariaDB yap\u0131land\u0131rma dosyas\u0131n\u0131 d\u00fczenleyin (genellikle
\/etc\/mysql\/mariadb.conf.d\/50-server.cnf<\/code> veya benzeri bir yolda bulunur).<\/li>\nbind-address = 127.0.0.1<\/code> sat\u0131r\u0131n\u0131 bulun ve bind-address = 0.0.0.0<\/code> olarak de\u011fi\u015ftirin (bu, t\u00fcm aray\u00fczlerden ba\u011flant\u0131ya izin verir) veya sunucunuzun belirli bir IP adresini belirtin.<\/li>\n- MariaDB servisini yeniden ba\u015flat\u0131n:
sudo systemctl restart mariadb<\/code>.<\/li>\n- Ayr\u0131ca, kullan\u0131c\u0131n\u0131za uzaktan ba\u011flanma yetkisi vermeniz gerekir. \u00d6rne\u011fin,
CREATE USER 'kullanici'@'%' IDENTIFIED BY 'sifre';<\/code> komutu, kullan\u0131c\u0131n\u0131n herhangi bir host’tan ba\u011flanmas\u0131na izin verir (%<\/code> wildcard’\u0131 kullanarak). Daha sonra bu kullan\u0131c\u0131ya ilgili yetkileri vermeyi unutmay\u0131n.<\/li>\n- Sunucunuzun g\u00fcvenlik duvar\u0131nda (\u00f6rne\u011fin, UFW) MariaDB’nin varsay\u0131lan portu olan 3306’ya gelen ba\u011flant\u0131lara izin vermelisiniz:
sudo ufw allow 3306\/tcp<\/code>.<\/li>\n<\/ol>\nQ3: MariaDB root \u015fifresini unuttum, nas\u0131l s\u0131f\u0131rlar\u0131m?<\/h4>\n
MariaDB root \u015fifresini s\u0131f\u0131rlamak i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyebilirsiniz:<\/p>\n
\n- MariaDB servisini durdurun:
sudo systemctl stop mariadb<\/code><\/li>\n- MariaDB’yi g\u00fcvenli modda (\u015fifre do\u011frulamas\u0131 olmadan) ba\u015flat\u0131n:
sudo mariadbd_safe --skip-grant-tables &<\/code><\/li>\n- MariaDB kabu\u011funa ba\u011flan\u0131n (\u015fifre girmeden):
mysql -u root<\/code><\/li>\n- \u015eifreyi s\u0131f\u0131rlay\u0131n:\n
FLUSH PRIVILEGES;\nALTER USER 'root'@'localhost' IDENTIFIED BY 'YeniGucluSifre!';\nFLUSH PRIVILEGES;\nEXIT;<\/code><\/pre>\n<\/li>\n- MariaDB g\u00fcvenli mod s\u00fcrecini sonland\u0131r\u0131n (
fg<\/code> ve ard\u0131ndan Ctrl+C<\/code> veya killall mariadbd_safe<\/code>).<\/li>\n- MariaDB servisini normal \u015fekilde ba\u015flat\u0131n:
sudo systemctl start mariadb<\/code><\/li>\n- Yeni \u015fifrenizle root olarak ba\u011flanmay\u0131 deneyin.<\/li>\n<\/ol>\n
Q4: MariaDB yap\u0131land\u0131rma dosyas\u0131 nerede bulunur?<\/h4>\n
MariaDB’nin ana yap\u0131land\u0131rma dosyalar\u0131 genellikle \/etc\/mysql\/<\/code> dizini alt\u0131nda veya \/etc\/mysql\/mariadb.conf.d\/<\/code> gibi alt dizinlerde bulunur. Ana yap\u0131land\u0131rma dosyas\u0131 genellikle my.cnf<\/code> veya 50-server.cnf<\/code> gibi isimlendirilir. Bu dosyalar, port numaras\u0131, bellek ayarlar\u0131, loglama gibi \u00e7e\u015fitli sunucu ayarlar\u0131n\u0131 i\u00e7erir.<\/p>\nQ5: Bir hata al\u0131rsam nereye bakmal\u0131y\u0131m?<\/h4>\n
MariaDB ile ilgili bir sorunla kar\u015f\u0131la\u015ft\u0131\u011f\u0131n\u0131zda, a\u015fa\u011f\u0131daki yerlere bakarak hata ay\u0131klama yapabilirsiniz:<\/p>\n
\n- Sistem g\u00fcnl\u00fckleri:<\/strong> MariaDB servisinin durumunu ve g\u00fcnl\u00fcklerini kontrol edin:
journalctl -xeu mariadb<\/code><\/li>\n- MariaDB hata g\u00fcnl\u00fckleri:<\/strong> MariaDB’nin kendi hata g\u00fcnl\u00fckleri genellikle
\/var\/log\/mysql\/error.log<\/code> veya \/var\/log\/mariadb\/error.log<\/code> konumunda bulunur. Bu dosya, veritaban\u0131 sunucusunun ba\u015flat\u0131lmas\u0131 veya \u00e7al\u0131\u015fmas\u0131 s\u0131ras\u0131nda kar\u015f\u0131la\u015f\u0131lan sorunlar hakk\u0131nda ayr\u0131nt\u0131l\u0131 bilgi i\u00e7erir.<\/li>\n<\/ul>\n<\/body><\/p>\n","protected":false},"excerpt":{"rendered":"MariaDB Nedir ve Neden Tercih Edilir?\nMariaDB, MySQL veritaban\u0131 y\u00f6netim sisteminin topluluk taraf\u0131ndan geli\u015ftirilen, a\u00e7\u0131k kaynakl\u0131 bir “fork”","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":[1],"tags":[],"class_list":{"0":"post-34259","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-genel","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"\n
MariaDB Nedir ve Neden Tercih Edilir? - 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-tercih-edilir\/\" \/>\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 Tercih Edilir?\" \/>\n<meta property=\"og:description\" content=\"MariaDB Nedir ve Neden Tercih Edilir? MariaDB, MySQL veritaban\u0131 y\u00f6netim sisteminin topluluk taraf\u0131ndan geli\u015ftirilen, a\u00e7\u0131k kaynakl\u0131 bir "fork"\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-tercih-edilir\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-11-13T22:41:32+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=\"11 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-tercih-edilir\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-tercih-edilir\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"MariaDB Nedir ve Neden Tercih Edilir?\",\"datePublished\":\"2025-11-13T22:41:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-tercih-edilir\/\"},\"wordCount\":1844,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-tercih-edilir\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-tercih-edilir\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-tercih-edilir\/\",\"name\":\"MariaDB Nedir ve Neden Tercih Edilir? - Kodlar\u0131n Gizemli D\u00fcnyas\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-11-13T22:41:32+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-tercih-edilir\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-tercih-edilir\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-tercih-edilir\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MariaDB Nedir ve Neden Tercih Edilir?\"}]},{\"@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 Tercih Edilir? - 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-tercih-edilir\/","og_locale":"tr_TR","og_type":"article","og_title":"MariaDB Nedir ve Neden Tercih Edilir?","og_description":"MariaDB Nedir ve Neden Tercih Edilir? MariaDB, MySQL veritaban\u0131 y\u00f6netim sisteminin topluluk taraf\u0131ndan geli\u015ftirilen, a\u00e7\u0131k kaynakl\u0131 bir \"fork\"","og_url":"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-tercih-edilir\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-11-13T22:41:32+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"11 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-tercih-edilir\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-tercih-edilir\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"MariaDB Nedir ve Neden Tercih Edilir?","datePublished":"2025-11-13T22:41:32+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-tercih-edilir\/"},"wordCount":1844,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-tercih-edilir\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-tercih-edilir\/","url":"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-tercih-edilir\/","name":"MariaDB Nedir ve Neden Tercih Edilir? - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-11-13T22:41:32+00:00","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-tercih-edilir\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-tercih-edilir\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/mariadb-nedir-ve-neden-tercih-edilir\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MariaDB Nedir ve Neden Tercih Edilir?"}]},{"@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\/34259","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=34259"}],"version-history":[{"count":1,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/34259\/revisions"}],"predecessor-version":[{"id":34260,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/34259\/revisions\/34260"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=34259"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=34259"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=34259"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}