{"id":37547,"date":"2026-01-08T14:41:02","date_gmt":"2026-01-08T11:41:02","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/?p=37547"},"modified":"2026-01-08T14:41:02","modified_gmt":"2026-01-08T11:41:02","slug":"ubuntu-18-04-uzerinden-yonetilen-veritabanlarina-baglanma-rehberi","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/ubuntu-18-04-uzerinden-yonetilen-veritabanlarina-baglanma-rehberi\/","title":{"rendered":"Ubuntu 18.04 \u00dczerinden Y\u00f6netilen Veritabanlar\u0131na Ba\u011flanma Rehberi"},"content":{"rendered":"<p><body><\/p>\n<h2>Ubuntu 18.04 \u00dczerinden Y\u00f6netilen Veritabanlar\u0131na Ba\u011flanma Rehberi<\/h2>\n<p>Y\u00f6netilen veritabanlar\u0131, modern uygulama geli\u015ftirmenin ve altyap\u0131 y\u00f6netiminin ayr\u0131lmaz bir par\u00e7as\u0131 haline gelmi\u015ftir. Geli\u015ftiricilerin ve sistem y\u00f6neticilerinin veritaban\u0131 altyap\u0131s\u0131n\u0131n karma\u015f\u0131k y\u00f6netimiyle u\u011fra\u015fmak yerine, uygulamalar\u0131na odaklanmalar\u0131n\u0131 sa\u011flarlar. Bu teknik makale, Ubuntu 18.04 i\u015fletim sistemi kurulu bir sunucu veya i\u015f istasyonu \u00fczerinden \u00e7e\u015fitli pop\u00fcler y\u00f6netilen veritabanlar\u0131na (MySQL, PostgreSQL, MongoDB, Redis) nas\u0131l g\u00fcvenli ve etkin bir \u015fekilde ba\u011flan\u0131laca\u011f\u0131n\u0131 ad\u0131m ad\u0131m a\u00e7\u0131klamaktad\u0131r. Ubuntu 18.04, uzun s\u00fcreli destek (LTS) s\u00fcr\u00fcm\u00fc olmas\u0131 nedeniyle hala geni\u015f bir kullan\u0131c\u0131 taban\u0131na sahip olsa da, bu makaledeki prensipler ve komutlar, Ubuntu&#8217;nun daha yeni LTS s\u00fcr\u00fcmleri (20.04, 22.04) i\u00e7in de b\u00fcy\u00fck \u00f6l\u00e7\u00fcde ge\u00e7erlidir.<\/p>\n<h3>Giri\u015f: Y\u00f6netilen Veritabanlar\u0131 ve Ubuntu 18.04<\/h3>\n<p>Y\u00f6netilen veritabanlar\u0131 (Managed Databases), Amazon RDS, Google Cloud SQL, Azure Database, DigitalOcean Managed Databases gibi bulut sa\u011flay\u0131c\u0131lar\u0131 taraf\u0131ndan sunulan hizmetlerdir. Bu hizmetler, veritaban\u0131 sunucusu kurulumu, yedekleme, \u00f6l\u00e7eklendirme, g\u00fcvenlik yamalar\u0131 ve genel bak\u0131m gibi operasyonel g\u00f6revleri otomatikle\u015ftirerek veya tamamen devralarak geli\u015ftiricilerin \u00fczerindeki y\u00fck\u00fc hafifletir. Bu sayede, geli\u015ftiriciler veritaban\u0131 altyap\u0131s\u0131 yerine uygulaman\u0131n i\u015f mant\u0131\u011f\u0131na ve \u00f6zelliklerine odaklanabilirler.<\/p>\n<p>Ubuntu 18.04 LTS (Bionic Beaver), kararl\u0131l\u0131\u011f\u0131 ve geni\u015f paket deste\u011fi nedeniyle sunucu ortamlar\u0131nda yayg\u0131n olarak kullan\u0131lan bir i\u015fletim sistemidir. Bu makale, Ubuntu 18.04&#8217;\u00fcn bu avantajlar\u0131ndan yararlanarak, farkl\u0131 t\u00fcrdeki y\u00f6netilen veritabanlar\u0131na g\u00fcvenli bir \u015fekilde nas\u0131l ba\u011flan\u0131laca\u011f\u0131n\u0131 ayr\u0131nt\u0131l\u0131 olarak ele alacakt\u0131r. Ba\u011flant\u0131 y\u00f6ntemleri hem komut sat\u0131r\u0131 aray\u00fcz\u00fc (CLI) hem de grafik kullan\u0131c\u0131 aray\u00fcz\u00fc (GUI) ara\u00e7lar\u0131 \u00fczerinden g\u00f6sterilecektir.<\/p>\n<h3>I. \u00d6n Haz\u0131rl\u0131klar ve Temel Bilgiler<\/h3>\n<p>Y\u00f6netilen bir veritaban\u0131na ba\u011flanmadan \u00f6nce, Ubuntu sisteminizin g\u00fcncel oldu\u011fundan ve gerekli g\u00fcvenlik \u00f6nlemlerinin al\u0131nd\u0131\u011f\u0131ndan emin olman\u0131z \u00f6nemlidir.<\/p>\n<h4>A. Ubuntu 18.04 Sistem G\u00fcncellemesi<\/h4>\n<p>Sisteminizin en g\u00fcncel g\u00fcvenlik yamalar\u0131na ve paket s\u00fcr\u00fcmlerine sahip oldu\u011fundan emin olmak i\u00e7in d\u00fczenli olarak g\u00fcncelleme yapmal\u0131s\u0131n\u0131z.<\/p>\n<pre><code class=\"language-bash\">sudo apt update\nsudo apt upgrade -y<\/code><\/pre>\n<p>Bu komutlar, paket listesini g\u00fcnceller ve mevcut t\u00fcm paketleri en yeni s\u00fcr\u00fcmlerine y\u00fckseltir.<\/p>\n<h4>B. G\u00fcvenlik Duvar\u0131 Ayarlar\u0131 (UFW)<\/h4>\n<p>Ubuntu&#8217;nun varsay\u0131lan g\u00fcvenlik duvar\u0131 olan UFW (Uncomplicated Firewall), sunucunuzu yetkisiz eri\u015fimlerden korumak i\u00e7in kritik \u00f6neme sahiptir. Veritaban\u0131na ba\u011flanmak i\u00e7in ilgili portlar\u0131n a\u00e7\u0131lmas\u0131 gerekebilir.<\/p>\n<pre><code class=\"language-bash\">sudo ufw status # G\u00fcvenlik duvar\u0131 durumunu kontrol edin\nsudo ufw enable # G\u00fcvenlik duvar\u0131n\u0131 etkinle\u015ftirin (ilk kez yap\u0131yorsan\u0131z)\nsudo ufw allow ssh # SSH ba\u011flant\u0131lar\u0131na izin verin (genellikle 22\/tcp)<\/code><\/pre>\n<p>Veritaban\u0131 t\u00fcr\u00fcne g\u00f6re a\u00e7man\u0131z gereken standart portlar \u015funlard\u0131r:<br \/>\n*   <strong>MySQL\/MariaDB:<\/strong> 3306\/tcp<br \/>\n*   <strong>PostgreSQL:<\/strong> 5432\/tcp<br \/>\n*   <strong>MongoDB:<\/strong> 27017\/tcp<br \/>\n*   <strong>Redis:<\/strong> 6379\/tcp<\/p>\n<p>\u00d6rnek olarak, MySQL ba\u011flant\u0131s\u0131 i\u00e7in:<\/p>\n<pre><code class=\"language-bash\">sudo ufw allow 3306\/tcp<\/code><\/pre>\n<p>Bu komut, 3306 numaral\u0131 TCP portundan gelen ba\u011flant\u0131lara izin verir. Ba\u011flant\u0131 sadece belirli bir IP adresinden yap\u0131lacaksa, daha k\u0131s\u0131tl\u0131 bir kural tan\u0131mlayabilirsiniz:<\/p>\n<pre><code class=\"language-bash\">sudo ufw allow from [izin_verilen_ip_adresi] to any port 3306<\/code><\/pre>\n<h4>C. SSH Anahtar \u00c7ifti Olu\u015fturma ve Kullanma<\/h4>\n<p>Veritaban\u0131 ba\u011flant\u0131s\u0131 i\u00e7in do\u011frudan gerekli olmasa da, sunucunuza SSH ile ba\u011flan\u0131rken anahtar \u00e7ifti kullanmak, \u015fifreye dayal\u0131 kimlik do\u011frulamadan \u00e7ok daha g\u00fcvenlidir. Bu, genel bir g\u00fcvenlik en iyi uygulamas\u0131d\u0131r.<\/p>\n<pre><code class=\"language-bash\">ssh-keygen -t rsa -b 4096 # Yeni bir SSH anahtar \u00e7ifti olu\u015fturun<\/code><\/pre>\n<p>Bu komut, <code>~\/.ssh\/id_rsa<\/code> (\u00f6zel anahtar) ve <code>~\/.ssh\/id_rsa.pub<\/code> (genel anahtar) dosyalar\u0131n\u0131 olu\u015fturur. Genel anahtar\u0131n\u0131z\u0131 bulut sa\u011flay\u0131c\u0131n\u0131z\u0131n paneli \u00fczerinden sunucunuza ekleyerek \u015fifresiz ve g\u00fcvenli bir \u015fekilde ba\u011flanabilirsiniz.<\/p>\n<h4>D. Veritaban\u0131 Ba\u011flant\u0131 Bilgilerini Anlama<\/h4>\n<p>Y\u00f6netilen veritaban\u0131n\u0131za ba\u011flanmak i\u00e7in a\u015fa\u011f\u0131daki temel bilgilere ihtiyac\u0131n\u0131z olacakt\u0131r. Bu bilgiler, bulut sa\u011flay\u0131c\u0131n\u0131z\u0131n veritaban\u0131 y\u00f6netim panelinden al\u0131n\u0131r:<br \/>\n*   <strong>Ana Bilgisayar Ad\u0131 (Host Name) veya IP Adresi:<\/strong> Veritaban\u0131 sunucusunun adresi.<br \/>\n*   <strong>Port Numaras\u0131:<\/strong> Veritaban\u0131n\u0131n dinledi\u011fi port (\u00f6rne\u011fin, MySQL i\u00e7in 3306).<br \/>\n*   <strong>Kullan\u0131c\u0131 Ad\u0131:<\/strong> Veritaban\u0131na eri\u015fim i\u00e7in kullan\u0131lan kullan\u0131c\u0131 ad\u0131.<br \/>\n*   <strong>\u015eifre:<\/strong> \u0130lgili kullan\u0131c\u0131 ad\u0131n\u0131n \u015fifresi.<br \/>\n*   <strong>Veritaban\u0131 Ad\u0131:<\/strong> (Opsiyonel) Ba\u011flanmak istedi\u011finiz belirli bir veritaban\u0131n\u0131n ad\u0131.<br \/>\n*   <strong>SSL\/TLS Sertifikalar\u0131:<\/strong> G\u00fcvenli (\u015fifreli) ba\u011flant\u0131 kurmak i\u00e7in gerekli olabilecek CA (Certificate Authority) sertifika dosyalar\u0131. Bulut sa\u011flay\u0131c\u0131n\u0131z genellikle bunlar\u0131 indirmenizi sa\u011flar.<\/p>\n<h3>II. MySQL\/MariaDB Y\u00f6netilen Veritaban\u0131na Ba\u011flanma<\/h3>\n<p>MySQL ve MariaDB, ili\u015fkisel veritaban\u0131 y\u00f6netim sistemleridir ve ba\u011flant\u0131 y\u00f6ntemleri b\u00fcy\u00fck \u00f6l\u00e7\u00fcde benzerdir.<\/p>\n<h4>A. MySQL \u0130stemcisini Kurma<\/h4>\n<p>Ubuntu 18.04 \u00fczerinde MySQL veya MariaDB veritaban\u0131na ba\u011flanmak i\u00e7in <code>mysql-client<\/code> paketini kurman\u0131z gerekir:<\/p>\n<pre><code class=\"language-bash\">sudo apt install mysql-client -y<\/code><\/pre>\n<h4>B. Komut Sat\u0131r\u0131 \u00dczerinden Ba\u011flanma<\/h4>\n<p>MySQL istemcisi ile komut sat\u0131r\u0131ndan ba\u011flanmak i\u00e7in genel format \u015f\u00f6yledir:<\/p>\n<pre><code class=\"language-bash\">mysql -h [host_ad\u0131] -P [port] -u [kullan\u0131c\u0131_ad\u0131] -p<\/code><\/pre>\n<p>*   <code>-h<\/code>: Veritaban\u0131 sunucusunun ana bilgisayar ad\u0131 veya IP adresi.<br \/>\n*   <code>-P<\/code>: Port numaras\u0131 (b\u00fcy\u00fck &#8216;P&#8217; harfine dikkat edin).<br \/>\n*   <code>-u<\/code>: Kullan\u0131c\u0131 ad\u0131.<br \/>\n*   <code>-p<\/code>: \u015eifre girmenizi ister. Komutun sonuna \u015fifreyi do\u011frudan yazmaktan ka\u00e7\u0131n\u0131n (<code>-p[\u015fifre]<\/code>), \u00e7\u00fcnk\u00fc bu \u015fifrenin komut ge\u00e7mi\u015finde g\u00f6r\u00fcnmesine neden olabilir ve g\u00fcvenlik riski olu\u015fturur.<\/p>\n<p><strong>\u00d6rnek Ba\u011flant\u0131:<\/strong><\/p>\n<pre><code class=\"language-bash\">mysql -h my-db-instance.example.com -P 3306 -u admin_user -p<\/code><\/pre>\n<p>Komutu \u00e7al\u0131\u015ft\u0131rd\u0131ktan sonra, sizden \u015fifrenizi girmeniz istenecektir.<\/p>\n<p><strong>SSL\/TLS ile Ba\u011flanma:<\/strong><br \/>\n\u00c7o\u011fu y\u00f6netilen veritaban\u0131, ba\u011flant\u0131 g\u00fcvenli\u011fi i\u00e7in SSL\/TLS kullan\u0131m\u0131n\u0131 zorunlu k\u0131lar veya \u015fiddetle tavsiye eder. Sa\u011flay\u0131c\u0131n\u0131zdan indirdi\u011finiz CA sertifika dosyas\u0131n\u0131 kullanarak g\u00fcvenli ba\u011flant\u0131 kurabilirsiniz:<\/p>\n<pre><code class=\"language-bash\">mysql -h [host_ad\u0131] -P [port] -u [kullan\u0131c\u0131_ad\u0131] -p --ssl-mode=VERIFY_IDENTITY --ssl-ca=[path_to_ca_cert.pem]<\/code><\/pre>\n<p>*   <code>--ssl-mode=VERIFY_IDENTITY<\/code>: Sunucunun sertifikas\u0131n\u0131 CA sertifikas\u0131 ile do\u011frulamas\u0131n\u0131 sa\u011flar.<br \/>\n*   <code>--ssl-ca<\/code>: CA sertifika dosyas\u0131n\u0131n yolu.<\/p>\n<h4>C. GUI Ara\u00e7lar\u0131 ile Ba\u011flanma (DBeaver\/MySQL Workbench)<\/h4>\n<p>Grafiksel aray\u00fcz ara\u00e7lar\u0131, veritabanlar\u0131n\u0131 g\u00f6rsel olarak y\u00f6netmek ve sorgulamak i\u00e7in daha kullan\u0131c\u0131 dostu bir deneyim sunar.<\/p>\n<p><strong>DBeaver (Evrensel Veritaban\u0131 Y\u00f6neticisi):<\/strong><br \/>\nDBeaver, bir\u00e7ok veritaban\u0131 t\u00fcr\u00fcn\u00fc destekleyen pop\u00fcler bir a\u00e7\u0131k kaynakl\u0131 GUI arac\u0131d\u0131r. Ubuntu&#8217;ya Snap paketi veya <code>.deb<\/code> dosyas\u0131 ile kurulabilir.<\/p>\n<pre><code class=\"language-bash\"># Snap ile kurulum\nsudo snap install dbeaver-ce\n\n<h2>.deb dosyas\u0131 ile kurulum (DBeaver web sitesinden indirin)<\/h2>\n<h2>sudo dpkg -i dbeaver-ce_latest_amd64.deb<\/h2>\n<h2>sudo apt install -f # Ba\u011f\u0131ml\u0131l\u0131klar\u0131 d\u00fczeltmek i\u00e7in<\/code><\/pre>\n<\/h2>\n<p>Kurulumdan sonra DBeaver&#8217;\u0131 a\u00e7\u0131n ve yeni bir ba\u011flant\u0131 olu\u015fturun:<br \/>\n1.  <strong>Veritaban\u0131 Ba\u011flant\u0131s\u0131 Sihirbaz\u0131:<\/strong> &#8220;Yeni Veritaban\u0131 Ba\u011flant\u0131s\u0131&#8221; se\u00e7ene\u011fini se\u00e7in.<br \/>\n2.  <strong>Veritaban\u0131 T\u00fcr\u00fc:<\/strong> &#8220;MySQL&#8221; veya &#8220;MariaDB&#8221; se\u00e7in.<br \/>\n3.  <strong>Ba\u011flant\u0131 Ayarlar\u0131:<\/strong><br \/>\n    *   <code>Host<\/code>: Veritaban\u0131 ana bilgisayar ad\u0131.<br \/>\n    *   <code>Port<\/code>: Port numaras\u0131 (\u00f6rne\u011fin, 3306).<br \/>\n    *   <code>Database<\/code>: Ba\u011flanmak istedi\u011finiz veritaban\u0131 ad\u0131 (iste\u011fe ba\u011fl\u0131).<br \/>\n    *   <code>Username<\/code>: Kullan\u0131c\u0131 ad\u0131.<br \/>\n    *   <code>Password<\/code>: \u015eifre.<br \/>\n4.  <strong>SSL Ayarlar\u0131:<\/strong> &#8220;SSL&#8221; sekmesine gidin. Genellikle &#8220;Use SSL&#8221; kutucu\u011funu i\u015faretleyip, bulut sa\u011flay\u0131c\u0131n\u0131zdan indirdi\u011finiz CA sertifika dosyas\u0131n\u0131n yolunu belirtmeniz gerekir.<br \/>\n5.  <strong>Ba\u011flant\u0131y\u0131 Test Et:<\/strong> Ba\u011flant\u0131n\u0131n ba\u015far\u0131l\u0131 olup olmad\u0131\u011f\u0131n\u0131 kontrol edin ve ard\u0131ndan kaydedin.<\/p>\n<p><strong>MySQL Workbench:<\/strong><br \/>\nMySQL Workbench, MySQL&#8217;e \u00f6zel resmi bir GUI arac\u0131d\u0131r.<\/p>\n<pre><code class=\"language-bash\"># MySQL Workbench'i kurmak i\u00e7in \u00f6nce MySQL APT deposunu eklemeniz gerekebilir.\n<h2>Alternatif olarak, MySQL web sitesinden .deb dosyas\u0131n\u0131 indirip kurabilirsiniz.<\/h2>\n<h2>wget https:\/\/dev.mysql.com\/get\/mysql-apt-config_0.8.15-1_all.deb<\/h2>\n<h2>sudo dpkg -i mysql-apt-config_0.8.15-1_all.deb<\/h2>\n<h2>sudo apt update<\/h2>\n<h2>sudo apt install mysql-workbench-community -y<\/code><\/pre>\n<\/h2>\n<p>Kurulumdan sonra MySQL Workbench&#8217;i a\u00e7\u0131n:<br \/>\n1.  <strong>Yeni Ba\u011flant\u0131 Olu\u015ftur:<\/strong> Ana ekranda &#8220;+&#8221; simgesine t\u0131klay\u0131n.<br \/>\n2.  <strong>Ba\u011flant\u0131 Ayarlar\u0131:<\/strong><br \/>\n    *   <code>Connection Name<\/code>: Ba\u011flant\u0131n\u0131z i\u00e7in bir isim.<br \/>\n    *   <code>Hostname<\/code>: Veritaban\u0131 ana bilgisayar ad\u0131.<br \/>\n    *   <code>Port<\/code>: Port numaras\u0131.<br \/>\n    *   <code>Username<\/code>: Kullan\u0131c\u0131 ad\u0131.<br \/>\n    *   <code>Password<\/code>: &#8220;Store in Vault&#8230;&#8221; se\u00e7ene\u011fi ile \u015fifreyi kaydedin.<br \/>\n3.  <strong>SSL Ayarlar\u0131:<\/strong> &#8220;SSL&#8221; sekmesine gidin. &#8220;Use SSL&#8221; se\u00e7ene\u011fini i\u015faretleyip, CA sertifika dosyas\u0131n\u0131n yolunu belirtin.<br \/>\n4.  <strong>Test Connection:<\/strong> Ba\u011flant\u0131y\u0131 test edin ve kaydedin.<\/p>\n<h3>III. PostgreSQL Y\u00f6netilen Veritaban\u0131na Ba\u011flanma<\/h3>\n<p>PostgreSQL, g\u00fc\u00e7l\u00fc ve a\u00e7\u0131k kaynakl\u0131 bir ili\u015fkisel veritaban\u0131 y\u00f6netim sistemidir.<\/p>\n<h4>A. PostgreSQL \u0130stemcisini Kurma<\/h4>\n<p>PostgreSQL veritaban\u0131na ba\u011flanmak i\u00e7in <code>postgresql-client<\/code> paketini kurman\u0131z gerekir:<\/p>\n<pre><code class=\"language-bash\">sudo apt install postgresql-client -y<\/code><\/pre>\n<h4>B. Komut Sat\u0131r\u0131 \u00dczerinden Ba\u011flanma<\/h4>\n<p>PostgreSQL istemcisi (<code>psql<\/code>) ile komut sat\u0131r\u0131ndan ba\u011flanmak i\u00e7in genel format \u015f\u00f6yledir:<\/p>\n<pre><code class=\"language-bash\">psql -h [host_ad\u0131] -p [port] -U [kullan\u0131c\u0131_ad\u0131] -d [veritaban\u0131_ad\u0131]<\/code><\/pre>\n<p>*   <code>-h<\/code>: Veritaban\u0131 sunucusunun ana bilgisayar ad\u0131 veya IP adresi.<br \/>\n*   <code>-p<\/code>: Port numaras\u0131 (k\u00fc\u00e7\u00fck &#8216;p&#8217; harfine dikkat edin).<br \/>\n*   <code>-U<\/code>: Kullan\u0131c\u0131 ad\u0131.<br \/>\n*   <code>-d<\/code>: Ba\u011flanmak istedi\u011finiz veritaban\u0131 ad\u0131.<\/p>\n<p><strong>\u00d6rnek Ba\u011flant\u0131:<\/strong><\/p>\n<pre><code class=\"language-bash\">psql -h my-pg-instance.example.com -p 5432 -U pg_admin -d my_database<\/code><\/pre>\n<p>Komutu \u00e7al\u0131\u015ft\u0131rd\u0131ktan sonra, sizden \u015fifrenizi girmeniz istenecektir.<\/p>\n<p><strong>SSL\/TLS ile Ba\u011flanma:<\/strong><br \/>\nPostgreSQL&#8217;de SSL ba\u011flant\u0131s\u0131 i\u00e7in genellikle ba\u011flant\u0131 dizesinde veya ortam de\u011fi\u015fkenlerinde <code>sslmode<\/code> parametresi kullan\u0131l\u0131r. \u00c7o\u011fu y\u00f6netilen PostgreSQL hizmeti, <code>sslmode=require<\/code> veya <code>sslmode=verify-full<\/code> ayarlar\u0131n\u0131 kullanman\u0131z\u0131 bekler.<\/p>\n<pre><code class=\"language-bash\"># Sadece SSL ba\u011flant\u0131s\u0131 gerektiren durumlar i\u00e7in\npsql \"host=[host_ad\u0131] port=[port] user=[kullan\u0131c\u0131_ad\u0131] password=[\u015fifre] dbname=[veritaban\u0131_ad\u0131] sslmode=require\"\n\n<h2>CA sertifikas\u0131 ile tam do\u011frulama i\u00e7in<\/h2>\npsql \"host=[host_ad\u0131] port=[port] user=[kullan\u0131c\u0131_ad\u0131] password=[\u015fifre] dbname=[veritaban\u0131_ad\u0131] sslmode=verify-full sslrootcert=[path_to_ca_cert.pem]\"<\/code><\/pre>\n<p>\u015eifreyi komut sat\u0131r\u0131nda do\u011frudan belirtmek yerine, <code>~\/.pgpass<\/code> dosyas\u0131n\u0131 kullanmak daha g\u00fcvenlidir. Bu dosya, veritaban\u0131 ba\u011flant\u0131 bilgilerini ve \u015fifrelerini saklar.<\/p>\n<pre><code class=\"language-\">hostname:port:database:username:password<\/code><\/pre>\n<p>\u00d6rnek: <code>my-pg-instance.example.com:5432:my_database:pg_admin:my_secret_password<\/code><br \/>\nDosya izinlerini do\u011fru ayarlamay\u0131 unutmay\u0131n: <code>chmod 0600 ~\/.pgpass<\/code>.<\/p>\n<h4>C. GUI Ara\u00e7lar\u0131 ile Ba\u011flanma (DBeaver\/pgAdmin)<\/h4>\n<p><strong>DBeaver:<\/strong><br \/>\nYukar\u0131da a\u00e7\u0131kland\u0131\u011f\u0131 gibi DBeaver&#8217;\u0131 kurduktan sonra, yeni bir PostgreSQL ba\u011flant\u0131s\u0131 olu\u015fturun:<br \/>\n1.  <strong>Veritaban\u0131 T\u00fcr\u00fc:<\/strong> &#8220;PostgreSQL&#8221; se\u00e7in.<br \/>\n2.  <strong>Ba\u011flant\u0131 Ayarlar\u0131:<\/strong><br \/>\n    *   <code>Host<\/code>, <code>Port<\/code>, <code>Database<\/code>, <code>Username<\/code>, <code>Password<\/code> bilgilerini girin.<br \/>\n3.  <strong>SSL Ayarlar\u0131:<\/strong> &#8220;SSL&#8221; sekmesine gidin. &#8220;Use SSL&#8221; kutucu\u011funu i\u015faretleyip, <code>SSL mode<\/code> olarak <code>require<\/code> veya <code>verify-full<\/code> se\u00e7in ve CA sertifika dosyas\u0131n\u0131n yolunu belirtin.<\/p>\n<p><strong>pgAdmin:<\/strong><br \/>\npgAdmin, PostgreSQL i\u00e7in resmi ve en pop\u00fcler GUI arac\u0131d\u0131r. Ubuntu&#8217;ya kurulumu biraz daha karma\u015f\u0131k olabilir, genellikle resmi depoyu ekleyerek yap\u0131l\u0131r:<\/p>\n<pre><code class=\"language-bash\"># pgAdmin deposunu ekleyin\nsudo curl https:\/\/www.pgadmin.org\/static\/packages_pgadmin_org.pub | sudo apt-key add\nsudo sh -c 'echo \"deb https:\/\/ftp.postgresql.org\/pub\/pgadmin\/apt\/$(lsb_release -cs) pgadmin4 main\" > \/etc\/apt\/sources.list.d\/pgadmin4.list'\nsudo apt update\nsudo apt install pgadmin4 -y # pgAdmin4-web veya pgAdmin4-desktop<\/code><\/pre>\n<p>Kurulumdan sonra pgAdmin&#8217;i a\u00e7\u0131n (genellikle bir web aray\u00fcz\u00fc olarak \u00e7al\u0131\u015f\u0131r veya masa\u00fcst\u00fc uygulamas\u0131d\u0131r):<br \/>\n1.  <strong>Sunucu Ekle:<\/strong> Sol panelde &#8220;Servers&#8221; \u00fczerine sa\u011f t\u0131klay\u0131n ve &#8220;Create&#8221; -> &#8220;Server&#8221; se\u00e7in.<br \/>\n2.  <strong>Genel (General) Sekmesi:<\/strong> Sunucunuz i\u00e7in bir isim verin.<br \/>\n3.  <strong>Ba\u011flant\u0131 (Connection) Sekmesi:<\/strong><br \/>\n    *   <code>Host name\/address<\/code>: Veritaban\u0131 ana bilgisayar ad\u0131.<br \/>\n    *   <code>Port<\/code>: Port numaras\u0131.<br \/>\n    *   <code>Maintenance database<\/code>: Genellikle <code>postgres<\/code> veya varsay\u0131lan veritaban\u0131.<br \/>\n    *   <code>Username<\/code>: Kullan\u0131c\u0131 ad\u0131.<br \/>\n    *   <code>Password<\/code>: \u015eifre.<br \/>\n4.  <strong>SSL Sekmesi:<\/strong> <code>SSL mode<\/code> olarak <code>Require<\/code> veya <code>Verify-full<\/code> se\u00e7in ve CA sertifika dosyas\u0131n\u0131n yolunu belirtin.<br \/>\n5.  <strong>Kaydet:<\/strong> Ba\u011flant\u0131y\u0131 kaydedin.<\/p>\n<h3>IV. MongoDB Y\u00f6netilen Veritaban\u0131na Ba\u011flanma<\/h3>\n<p>MongoDB, pop\u00fcler bir NoSQL (belge tabanl\u0131) veritaban\u0131d\u0131r.<\/p>\n<h4>A. MongoDB Shell Kurulumu<\/h4>\n<p>Ubuntu 18.04&#8217;e MongoDB Shell (<code>mongo<\/code> veya <code>mongosh<\/code>) kurmak i\u00e7in MongoDB&#8217;nin resmi deposunu eklemeniz gerekir. Kurulum ad\u0131mlar\u0131 MongoDB s\u00fcr\u00fcm\u00fcne g\u00f6re de\u011fi\u015febilir. A\u015fa\u011f\u0131da MongoDB 4.4 i\u00e7in \u00f6rnek ad\u0131mlar verilmi\u015ftir (Ubuntu 18.04&#8217;te desteklenen son s\u00fcr\u00fcmlerden biridir):<\/p>\n<pre><code class=\"language-bash\"># GPG anahtar\u0131n\u0131 i\u00e7e aktar\u0131n\nwget -qO - https:\/\/www.mongodb.org\/static\/pgp\/server-4.4.asc | sudo apt-key add -\n\n<h2>MongoDB deposunu olu\u015fturun<\/h2>\necho \"deb [ arch=amd64,arm64 ] https:\/\/repo.mongodb.org\/apt\/ubuntu bionic\/mongodb-org\/4.4 multiverse\" | sudo tee \/etc\/apt\/sources.list.d\/mongodb-org-4.4.list\n\n<h2>Paket listesini g\u00fcncelleyin ve MongoDB Shell'i kurun<\/h2>\nsudo apt update\nsudo apt install mongodb-org-shell -y<\/code><\/pre>\n<p>Yeni <code>mongosh<\/code> kabuk s\u00fcr\u00fcm\u00fc i\u00e7in ad\u0131mlar farkl\u0131l\u0131k g\u00f6sterebilir, MongoDB&#8217;nin resmi belgelerine ba\u015fvurmak en do\u011frusudur.<\/p>\n<h4>B. Komut Sat\u0131r\u0131 \u00dczerinden Ba\u011flanma<\/h4>\n<p>MongoDB&#8217;ye ba\u011flanmak i\u00e7in <code>mongo<\/code> komutu kullan\u0131l\u0131r. Ba\u011flant\u0131 dizeleri (connection string) genellikle URI format\u0131nda olur.<\/p>\n<p><strong>SSL\/TLS Olmadan Ba\u011flant\u0131 (nadiren kullan\u0131l\u0131r, g\u00fcvenli de\u011fildir):<\/strong><\/p>\n<pre><code class=\"language-bash\">mongo --host [host_ad\u0131] --port [port] --username [kullan\u0131c\u0131_ad\u0131] --password [\u015fifre] --authenticationDatabase admin<\/code><\/pre>\n<p><code>--authenticationDatabase admin<\/code> parametresi, kullan\u0131c\u0131n\u0131n <code>admin<\/code> veritaban\u0131nda tan\u0131mland\u0131\u011f\u0131n\u0131 belirtir.<\/p>\n<p><strong>SSL\/TLS ile Ba\u011flant\u0131 (\u00f6nerilen):<\/strong><\/p>\n<pre><code class=\"language-bash\">mongo \"mongodb:\/\/[kullan\u0131c\u0131_ad\u0131]:[\u015fifre]@[host_ad\u0131]:[port]\/[veritaban\u0131_ad\u0131]?authSource=admin&ssl=true&ssl_ca_certs=[path_to_ca_cert.pem]\"<\/code><\/pre>\n<p>Veya ayr\u0131 parametrelerle:<\/p>\n<pre><code class=\"language-bash\">mongo --host [host_ad\u0131] --port [port] --username [kullan\u0131c\u0131_ad\u0131] --password [\u015fifre] --authenticationDatabase admin --ssl --sslCAFile [path_to_ca_cert.pem]<\/code><\/pre>\n<p>*   <code>--ssl<\/code>: SSL\/TLS kullan\u0131larak ba\u011flant\u0131 kurulaca\u011f\u0131n\u0131 belirtir.<br \/>\n*   <code>--sslCAFile<\/code>: CA sertifika dosyas\u0131n\u0131n yolu.<\/p>\n<h4>C. GUI Ara\u00e7lar\u0131 ile Ba\u011flanma (MongoDB Compass\/DBeaver)<\/h4>\n<p><strong>MongoDB Compass:<\/strong><br \/>\nMongoDB Compass, MongoDB i\u00e7in resmi ve g\u00fc\u00e7l\u00fc bir GUI arac\u0131d\u0131r. MongoDB web sitesinden <code>.deb<\/code> dosyas\u0131n\u0131 indirerek veya Snap ile kurulabilir:<\/p>\n<pre><code class=\"language-bash\"># Snap ile kurulum\nsudo snap install mongodb-compass\n\n<h2>.deb dosyas\u0131 ile kurulum (MongoDB Compass web sitesinden indirin)<\/h2>\n<h2>sudo dpkg -i mongodb-compass_latest_amd64.deb<\/h2>\n<h2>sudo apt install -f # Ba\u011f\u0131ml\u0131l\u0131klar\u0131 d\u00fczeltmek i\u00e7in<\/code><\/pre>\n<\/h2>\n<p>Kurulumdan sonra Compass&#8217;\u0131 a\u00e7\u0131n:<br \/>\n1.  <strong>Ba\u011flan:<\/strong> Ana ekranda &#8220;Connect&#8221; -> &#8220;Fill in connection fields individually&#8221; se\u00e7ene\u011fini se\u00e7in.<br \/>\n2.  <strong>Ba\u011flant\u0131 Ayarlar\u0131:<\/strong><br \/>\n    *   <code>Hostname<\/code>: Veritaban\u0131 ana bilgisayar ad\u0131.<br \/>\n    *   <code>Port<\/code>: Port numaras\u0131.<br \/>\n3.  <strong>Authentication:<\/strong> &#8220;Authentication&#8221; sekmesine gidin.<br \/>\n    *   <code>Authentication Method<\/code>: <code>Username \/ Password<\/code> se\u00e7in.<br \/>\n    *   <code>Username<\/code>, <code>Password<\/code> ve <code>Authentication Database<\/code> (genellikle <code>admin<\/code>) girin.<br \/>\n4.  <strong>SSL\/TLS:<\/strong> &#8220;SSL\/TLS&#8221; sekmesine gidin.<br \/>\n    *   <code>SSL<\/code>: <code>Server Validation<\/code> veya <code>CA File<\/code> se\u00e7ene\u011fini i\u015faretleyin.<br \/>\n    *   <code>CA File<\/code>: CA sertifika dosyas\u0131n\u0131n yolunu belirtin.<br \/>\n5.  <strong>Connect:<\/strong> Ba\u011flant\u0131y\u0131 kurun.<\/p>\n<p><strong>DBeaver:<\/strong><br \/>\nDBeaver&#8217;\u0131 kurduktan sonra, yeni bir MongoDB ba\u011flant\u0131s\u0131 olu\u015fturun:<br \/>\n1.  <strong>Veritaban\u0131 T\u00fcr\u00fc:<\/strong> &#8220;MongoDB&#8221; se\u00e7in.<br \/>\n2.  <strong>Ba\u011flant\u0131 Ayarlar\u0131:<\/strong><br \/>\n    *   <code>Host<\/code>, <code>Port<\/code>, <code>Database<\/code>, <code>Username<\/code>, <code>Password<\/code> bilgilerini girin.<br \/>\n    *   <code>Authentication Database<\/code> alan\u0131n\u0131 do\u011fru \u015fekilde ayarlay\u0131n (genellikle <code>admin<\/code>).<br \/>\n3.  <strong>SSL Ayarlar\u0131:<\/strong> &#8220;SSL&#8221; sekmesine gidin. &#8220;Use SSL&#8221; kutucu\u011funu i\u015faretleyip, CA sertifika dosyas\u0131n\u0131n yolunu belirtin.<\/p>\n<h3>V. Redis Y\u00f6netilen Veritaban\u0131na Ba\u011flanma<\/h3>\n<p>Redis, bellek i\u00e7i bir veri yap\u0131s\u0131 deposu olarak kullan\u0131lan h\u0131zl\u0131 bir NoSQL veritaban\u0131d\u0131r.<\/p>\n<h4>A. Redis CLI Kurulumu<\/h4>\n<p>Redis veritaban\u0131na ba\u011flanmak i\u00e7in <code>redis-tools<\/code> paketini kurman\u0131z gerekir:<\/p>\n<pre><code class=\"language-bash\">sudo apt install redis-tools -y<\/code><\/pre>\n<h4>B. Komut Sat\u0131r\u0131 \u00dczerinden Ba\u011flanma<\/h4>\n<p>Redis istemcisi (<code>redis-cli<\/code>) ile komut sat\u0131r\u0131ndan ba\u011flanmak i\u00e7in genel format \u015f\u00f6yledir:<\/p>\n<pre><code class=\"language-bash\">redis-cli -h [host_ad\u0131] -p [port] -a [\u015fifre]<\/code><\/pre>\n<p>*   <code>-h<\/code>: Redis sunucusunun ana bilgisayar ad\u0131 veya IP adresi.<br \/>\n*   <code>-p<\/code>: Port numaras\u0131 (genellikle 6379).<br \/>\n*   <code>-a<\/code>: \u015eifre (do\u011frudan komut sat\u0131r\u0131nda belirtmek g\u00fcvenlik riski ta\u015f\u0131yabilir, ancak <code>redis-cli<\/code> i\u00e7in yayg\u0131n bir kullan\u0131md\u0131r).<\/p>\n<p><strong>\u00d6rnek Ba\u011flant\u0131:<\/strong><\/p>\n<pre><code class=\"language-bash\">redis-cli -h my-redis-instance.example.com -p 6379 -a my_redis_password<\/code><\/pre>\n<p>Ba\u011fland\u0131ktan sonra Redis komutlar\u0131n\u0131 \u00e7al\u0131\u015ft\u0131rabilirsiniz (\u00f6rne\u011fin, <code>PING<\/code>, <code>SET key value<\/code>, <code>GET key<\/code>).<\/p>\n<p><strong>SSL\/TLS ile Ba\u011flanma:<\/strong><br \/>\n<code>redis-cli<\/code> varsay\u0131lan olarak SSL\/TLS deste\u011fi sunmaz. E\u011fer y\u00f6netilen Redis hizmetiniz SSL\/TLS gerektiriyorsa, genellikle <code>stunnel<\/code> gibi bir t\u00fcnelleme arac\u0131 kullanarak veya RedisInsight gibi GUI ara\u00e7lar\u0131n\u0131 kullanarak ba\u011flanman\u0131z gerekir. Baz\u0131 bulut sa\u011flay\u0131c\u0131lar\u0131, Redis i\u00e7in kendi istemci k\u00fct\u00fcphaneleri arac\u0131l\u0131\u011f\u0131yla SSL\/TLS deste\u011fi sunabilir.<\/p>\n<p><strong>Stunnel ile \u00d6rnek Ba\u011flant\u0131 (genel bir yakla\u015f\u0131m):<\/strong><br \/>\n1.  <strong>Stunnel Kurulumu:<\/strong><\/p>\n<pre><code class=\"language-bash\">sudo apt install stunnel4 -y<\/code><\/pre>\n<p>2.  <strong>Stunnel Yap\u0131land\u0131rmas\u0131:<\/strong> <code>\/etc\/stunnel\/redis.conf<\/code> gibi bir dosya olu\u015fturun:<\/p>\n<pre><code class=\"language-ini\">[redis-cli]\n    client = yes\n    accept = 127.0.0.1:6380  # Yerel port\n    connect = [host_ad\u0131]:[port]\n    CAfile = [path_to_ca_cert.pem]\n    verifyChain = yes<\/code><\/pre>\n<p>3.  <strong>Stunnel&#8217;i Ba\u015flat\u0131n:<\/strong><\/p>\n<pre><code class=\"language-bash\">sudo systemctl enable stunnel4\n    sudo systemctl start stunnel4<\/code><\/pre>\n<p>4.  <strong>Redis-cli ile Ba\u011flan\u0131n:<\/strong> \u015eimdi <code>redis-cli<\/code> ile yerel olarak stunnel&#8217;in dinledi\u011fi porta ba\u011flanabilirsiniz:<\/p>\n<pre><code class=\"language-bash\">redis-cli -h 127.0.0.1 -p 6380 -a [\u015fifre]<\/code><\/pre>\n<p>Bu y\u00f6ntem, Redis trafi\u011fini yerel olarak \u015fifreleyip uzak sunucuya g\u00fcvenli bir \u015fekilde iletir.<\/p>\n<h4>C. GUI Ara\u00e7lar\u0131 ile Ba\u011flanma (RedisInsight\/DBeaver)<\/h4>\n<p><strong>RedisInsight:<\/strong><br \/>\nRedisInsight, Redis i\u00e7in resmi bir GUI arac\u0131d\u0131r ve SSL\/TLS ba\u011flant\u0131lar\u0131n\u0131 do\u011frudan destekler. RedisLabs web sitesinden <code>.deb<\/code> dosyas\u0131n\u0131 indirerek kurulabilir:<\/p>\n<pre><code class=\"language-bash\"># RedisInsight web sitesinden .deb dosyas\u0131n\u0131 indirin\n<h2>sudo dpkg -i redisinsight_latest.deb<\/h2>\n<h2>sudo apt install -f # Ba\u011f\u0131ml\u0131l\u0131klar\u0131 d\u00fczeltmek i\u00e7in<\/code><\/pre>\n<\/h2>\n<p>Kurulumdan sonra RedisInsight&#8217;\u0131 a\u00e7\u0131n:<br \/>\n1.  <strong>Add Redis Database:<\/strong> &#8220;Add Redis Database&#8221; se\u00e7ene\u011fini se\u00e7in.<br \/>\n2.  <strong>Ba\u011flant\u0131 Ayarlar\u0131:<\/strong><br \/>\n    *   <code>Host<\/code>, <code>Port<\/code>, <code>Password<\/code> bilgilerini girin.<br \/>\n    *   <code>SSL\/TLS<\/code>: Bu se\u00e7ene\u011fi etkinle\u015ftirin ve CA sertifika dosyas\u0131n\u0131n yolunu belirtin.<br \/>\n3.  <strong>Add Redis Database:<\/strong> Ba\u011flant\u0131y\u0131 ekleyin.<\/p>\n<p><strong>DBeaver:<\/strong><br \/>\nDBeaver&#8217;\u0131 kurduktan sonra, yeni bir Redis ba\u011flant\u0131s\u0131 olu\u015fturun:<br \/>\n1.  <strong>Veritaban\u0131 T\u00fcr\u00fc:<\/strong> &#8220;Redis&#8221; se\u00e7in.<br \/>\n2.  <strong>Ba\u011flant\u0131 Ayarlar\u0131:<\/strong><br \/>\n    *   <code>Host<\/code>, <code>Port<\/code>, <code>Password<\/code> bilgilerini girin.<br \/>\n3.  <strong>SSL Ayarlar\u0131:<\/strong> &#8220;SSL&#8221; sekmesine gidin. &#8220;Use SSL&#8221; kutucu\u011funu i\u015faretleyip, CA sertifika dosyas\u0131n\u0131n yolunu belirtin (DBeaver&#8217;\u0131n Redis i\u00e7in tam SSL deste\u011fi, kullan\u0131lan JDBC s\u00fcr\u00fcc\u00fcs\u00fcne ba\u011fl\u0131 olarak de\u011fi\u015febilir).<\/p>\n<h3>VI. G\u00fcvenlik En \u0130yi Uygulamalar\u0131<\/h3>\n<p>Veritaban\u0131 ba\u011flant\u0131lar\u0131nda g\u00fcvenlik her zaman \u00f6ncelikli olmal\u0131d\u0131r.<\/p>\n<h4>A. G\u00fc\u00e7l\u00fc \u015eifreler ve Periyodik De\u011fi\u015fim<\/h4>\n<p>T\u00fcm veritaban\u0131 kullan\u0131c\u0131lar\u0131 i\u00e7in uzun, karma\u015f\u0131k ve benzersiz \u015fifreler kullan\u0131n. \u015eifreleri d\u00fczenli aral\u0131klarla de\u011fi\u015ftirin. \u015eifreleri asla a\u00e7\u0131k metin olarak kodunuza veya komut ge\u00e7mi\u015finize kaydetmeyin.<\/p>\n<h4>B. En Az Ayr\u0131cal\u0131k Prensibi<\/h4>\n<p>Veritaban\u0131 kullan\u0131c\u0131lar\u0131na yaln\u0131zca g\u00f6revlerini yerine getirmek i\u00e7in kesinlikle gerekli olan minimum ayr\u0131cal\u0131klar\u0131 verin. \u00d6rne\u011fin, bir uygulama kullan\u0131c\u0131s\u0131n\u0131n t\u00fcm veritaban\u0131n\u0131 silme yetkisine ihtiyac\u0131 yoktur.<\/p>\n<h4>C. A\u011f G\u00fcvenli\u011fi (G\u00fcvenlik Gruplar\u0131\/ACL&#8217;ler)<\/h4>\n<p>Bulut sa\u011flay\u0131c\u0131n\u0131z\u0131n g\u00fcvenlik duvar\u0131 veya g\u00fcvenlik grubu \u00f6zelliklerini kullanarak veritaban\u0131na eri\u015fimi yaln\u0131zca belirli IP adresleriyle veya a\u011flarla s\u0131n\u0131rlay\u0131n. Bu, veritaban\u0131n\u0131z\u0131 internetten gelebilecek gereksiz taramalara ve sald\u0131r\u0131lara kar\u015f\u0131 korur. Ubuntu&#8217;daki UFW ile kendi sunucunuzdan d\u0131\u015far\u0131ya a\u00e7\u0131lan ba\u011flant\u0131lar\u0131 kontrol ederken, y\u00f6netilen veritaban\u0131n\u0131z\u0131n kendi g\u00fcvenlik duvar\u0131 kurallar\u0131n\u0131 da yap\u0131land\u0131rman\u0131z gerekir.<\/p>\n<h4>D. SSL\/TLS Kullan\u0131m\u0131<\/h4>\n<p>M\u00fcmk\u00fcn olan her durumda veritaban\u0131 ba\u011flant\u0131lar\u0131 i\u00e7in SSL\/TLS \u015fifrelemesi kullan\u0131n. Bu, veritaban\u0131 ile istemci aras\u0131ndaki t\u00fcm verilerin \u015fifrelenmesini sa\u011flayarak hassas bilgilerin ele ge\u00e7irilmesini \u00f6nler. CA sertifikas\u0131 ile sunucu kimli\u011fini do\u011frulamak, Man-in-the-Middle (MITM) sald\u0131r\u0131lar\u0131na kar\u015f\u0131 ek koruma sa\u011flar.<\/p>\n<h4>E. SSH T\u00fcnelleme (Opsiyonel)<\/h4>\n<p>E\u011fer y\u00f6netilen veritaban\u0131n\u0131z\u0131n do\u011frudan internete a\u00e7\u0131k olmas\u0131n\u0131 istemiyorsan\u0131z veya ek bir g\u00fcvenlik katman\u0131 ar\u0131yorsan\u0131z, bir ara SSH sunucusu \u00fczerinden t\u00fcnelleme yapabilirsiniz.<\/p>\n<pre><code class=\"language-bash\">ssh -L [yerel_port]:[veritaban\u0131_host]:[veritaban\u0131_port] user@remote_ssh_host<\/code><\/pre>\n<p>Bu komut, yerel makinenizdeki <code>[yerel_port]<\/code> \u00fczerinden gelen trafi\u011fi, <code>remote_ssh_host<\/code> adl\u0131 SSH sunucusu arac\u0131l\u0131\u011f\u0131yla <code>veritaban\u0131_host<\/code> \u00fczerindeki <code>veritaban\u0131_port<\/code>&#8216;a y\u00f6nlendirir. B\u00f6ylece, veritaban\u0131na sanki yerel makinenizden eri\u015fiyormu\u015f gibi g\u00fcvenli bir \u015fekilde ba\u011flanabilirsiniz.<\/p>\n<h3>VII. S\u0131k Kar\u015f\u0131la\u015f\u0131lan Sorunlar ve \u00c7\u00f6z\u00fcmleri<\/h3>\n<p>Veritaban\u0131 ba\u011flant\u0131lar\u0131 s\u0131ras\u0131nda \u00e7e\u015fitli sorunlarla kar\u015f\u0131la\u015fmak olas\u0131d\u0131r. \u0130\u015fte en yayg\u0131n olanlar\u0131 ve olas\u0131 \u00e7\u00f6z\u00fcmleri:<\/p>\n<h4>A. Ba\u011flant\u0131 Zaman A\u015f\u0131m\u0131 (Connection Timeout)<\/h4>\n<p>*   <strong>Sorun:<\/strong> Ba\u011flant\u0131 denemesi belirli bir s\u00fcre sonra ba\u015far\u0131s\u0131z oluyor.<br \/>\n*   <strong>Olas\u0131 Nedenler ve \u00c7\u00f6z\u00fcmler:<\/strong><br \/>\n    *   <strong>G\u00fcvenlik Duvar\u0131:<\/strong> Ubuntu sunucunuzdaki UFW veya bulut sa\u011flay\u0131c\u0131n\u0131z\u0131n g\u00fcvenlik grubu\/a\u011f ACL&#8217;leri, veritaban\u0131 portuna giden trafi\u011fi engelliyor olabilir. Gerekli portlar\u0131n (3306, 5432 vb.) a\u00e7\u0131k oldu\u011fundan emin olun.<br \/>\n    *   <strong>IP Adresi K\u0131s\u0131tlamalar\u0131:<\/strong> Y\u00f6netilen veritaban\u0131 hizmeti, yaln\u0131zca belirli IP adreslerinden gelen ba\u011flant\u0131lara izin verecek \u015fekilde yap\u0131land\u0131r\u0131lm\u0131\u015f olabilir. Ba\u011flant\u0131 yapmaya \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131z IP adresinizin izin verilenler listesinde oldu\u011fundan emin olun.<br \/>\n    *   <strong>Veritaban\u0131 Sunucusunun Durumu:<\/strong> Veritaban\u0131 hizmetinin \u00e7al\u0131\u015f\u0131r durumda olup olmad\u0131\u011f\u0131n\u0131 kontrol edin.<\/p>\n<h4>B. Kimlik Do\u011frulama Hatas\u0131 (Authentication Failed)<\/h4>\n<p>*   <strong>Sorun:<\/strong> Ge\u00e7ersiz kullan\u0131c\u0131 ad\u0131 veya \u015fifre hatas\u0131 al\u0131n\u0131yor.<br \/>\n*   <strong>Olas\u0131 Nedenler ve \u00c7\u00f6z\u00fcmler:<\/strong><br \/>\n    *   <strong>Yanl\u0131\u015f Kimlik Bilgileri:<\/strong> Kullan\u0131c\u0131 ad\u0131 ve \u015fifrenin do\u011fru oldu\u011fundan emin olun. B\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf duyarl\u0131l\u0131\u011f\u0131na dikkat edin.<br \/>\n    *   <strong>Veritaban\u0131 Ad\u0131:<\/strong> PostgreSQL veya MongoDB gibi baz\u0131 veritabanlar\u0131nda, kullan\u0131c\u0131lar\u0131n belirli bir veritaban\u0131 veya kimlik do\u011frulama veritaban\u0131 (MongoDB&#8217;de <code>admin<\/code> gibi) ile ili\u015fkilendirilmi\u015f olmas\u0131 gerekebilir. Ba\u011flant\u0131 komutunuzda veya GUI ayarlar\u0131n\u0131zda do\u011fru veritaban\u0131n\u0131 belirtti\u011finizden emin olun.<br \/>\n    *   <strong>Yetkilendirme Sorunlar\u0131:<\/strong> Kullan\u0131c\u0131n\u0131n ba\u011flanmaya \u00e7al\u0131\u015ft\u0131\u011f\u0131 veritaban\u0131na veya verilere eri\u015fim yetkisi olmayabilir. Veritaban\u0131 y\u00f6neticisiyle ileti\u015fime ge\u00e7erek yetkileri kontrol ettirin.<\/p>\n<h4>C. SSL\/TLS Hatas\u0131<\/h4>\n<p>*   <strong>Sorun:<\/strong> SSL\/TLS el s\u0131k\u0131\u015fmas\u0131 ba\u015far\u0131s\u0131z oluyor veya sertifika do\u011frulama hatas\u0131 al\u0131n\u0131yor.<br \/>\n*   <strong>Olas\u0131 Nedenler ve \u00c7\u00f6z\u00fcmler:<\/strong><br \/>\n    *   <strong>Sertifika Yolu:<\/strong> CA sertifika dosyas\u0131n\u0131n yolunun do\u011fru oldu\u011fundan ve dosyan\u0131n okunabilir oldu\u011fundan emin olun.<br \/>\n    *   <strong>Sertifika Ge\u00e7erlili\u011fi:<\/strong> CA sertifikas\u0131n\u0131n s\u00fcresi dolmu\u015f olabilir veya bozuk olabilir. Bulut sa\u011flay\u0131c\u0131n\u0131zdan en g\u00fcncel sertifikay\u0131 indirin.<br \/>\n    *   <strong>\u0130stemci Deste\u011fi:<\/strong> Kulland\u0131\u011f\u0131n\u0131z veritaban\u0131 istemcisinin veya k\u00fct\u00fcphanesinin SSL\/TLS&#8217;yi do\u011fru \u015fekilde destekledi\u011finden ve yap\u0131land\u0131r\u0131ld\u0131\u011f\u0131ndan emin olun.<br \/>\n    *   <strong>Saat Senkronizasyonu:<\/strong> Sunucunuzun ve istemcinizin saatleri senkronize de\u011filse SSL\/TLS sertifika do\u011frulama sorunlar\u0131 ya\u015fanabilir. <code>sudo apt install ntp<\/code> ve <code>sudo systemctl enable ntp<\/code> ile NTP hizmetini etkinle\u015ftirin.<\/p>\n<h4>D. Ba\u011flant\u0131 Reddedildi (Connection Refused)<\/h4>\n<p>*   <strong>Sorun:<\/strong> \u0130stemci, veritaban\u0131 sunucusu taraf\u0131ndan ba\u011flant\u0131s\u0131n\u0131n reddedildi\u011fini belirten bir hata al\u0131yor.<br \/>\n*   <strong>Olas\u0131 Nedenler ve \u00c7\u00f6z\u00fcmler:<\/strong><br \/>\n    *   <strong>Yanl\u0131\u015f Port Numaras\u0131:<\/strong> Do\u011fru port numaras\u0131n\u0131 kulland\u0131\u011f\u0131n\u0131zdan emin olun (MySQL i\u00e7in 3306, PostgreSQL i\u00e7in 5432 vb.).<br \/>\n    *   <strong>Veritaban\u0131 Hizmeti Durumu:<\/strong> Veritaban\u0131 hizmetinin \u00e7al\u0131\u015f\u0131r durumda oldu\u011fundan emin olun. Y\u00f6netilen veritabanlar\u0131nda bu genellikle bulut sa\u011flay\u0131c\u0131n\u0131n sorumlulu\u011fundad\u0131r, ancak yine de durumunu kontrol etmek faydal\u0131 olabilir.<br \/>\n    *   <strong>Veritaban\u0131n\u0131n D\u0131\u015f Ba\u011flant\u0131lara \u0130zni:<\/strong> Nadiren de olsa, y\u00f6netilen veritabanlar\u0131 varsay\u0131lan olarak yaln\u0131zca belirli a\u011flardan veya i\u00e7 a\u011flardan ba\u011flant\u0131ya izin verebilir. Sa\u011flay\u0131c\u0131n\u0131z\u0131n belgelerini kontrol edin.<\/p>\n<h3>Sonu\u00e7<\/h3>\n<p>Bu makale, Ubuntu 18.04 i\u015fletim sistemi \u00fczerinden MySQL\/MariaDB, PostgreSQL, MongoDB ve Redis gibi pop\u00fcler y\u00f6netilen veritabanlar\u0131na nas\u0131l ba\u011flan\u0131laca\u011f\u0131na dair kapsaml\u0131 bir rehber sunmu\u015ftur. Komut sat\u0131r\u0131 ara\u00e7lar\u0131ndan grafiksel kullan\u0131c\u0131 aray\u00fczlerine kadar farkl\u0131 ba\u011flant\u0131 y\u00f6ntemlerini, \u00f6n haz\u0131rl\u0131klar\u0131, g\u00fcvenlik en iyi uygulamalar\u0131n\u0131 ve s\u0131k kar\u015f\u0131la\u015f\u0131lan sorunlar\u0131n \u00e7\u00f6z\u00fcmlerini ele ald\u0131k.<\/p>\n<p>Y\u00f6netilen veritabanlar\u0131, veritaban\u0131 y\u00f6netiminin karma\u015f\u0131kl\u0131\u011f\u0131n\u0131 ortadan kald\u0131rarak geli\u015ftiricilerin ve sistem y\u00f6neticilerinin i\u015f y\u00fck\u00fcn\u00fc \u00f6nemli \u00f6l\u00e7\u00fcde azalt\u0131r. Ancak, bu hizmetlere g\u00fcvenli ve do\u011fru bir \u015fekilde ba\u011flanmak, uygulaman\u0131z\u0131n g\u00fcvenli\u011fi ve performans\u0131 i\u00e7in kritik \u00f6neme sahiptir. SSL\/TLS \u015fifrelemesi kullanmak, g\u00fc\u00e7l\u00fc \u015fifreler belirlemek ve en az ayr\u0131cal\u0131k prensibini uygulamak gibi g\u00fcvenlik \u00f6nlemlerini asla g\u00f6z ard\u0131 etmemelisiniz.<\/p>\n<p>Ubuntu 18.04&#8217;\u00fcn kararl\u0131l\u0131\u011f\u0131, bu t\u00fcr ba\u011flant\u0131lar i\u00e7in g\u00fcvenilir bir temel sunsa da, yeni projelerde Ubuntu&#8217;nun daha g\u00fcncel LTS s\u00fcr\u00fcmlerini (20.04 veya 22.04) kullanmay\u0131 d\u00fc\u015f\u00fcnmek, daha uzun s\u00fcreli g\u00fcvenlik ve yaz\u0131l\u0131m deste\u011fi a\u00e7\u0131s\u0131ndan faydal\u0131 olacakt\u0131r. Bu makalede belirtilen ad\u0131mlar ve prensipler, Ubuntu&#8217;nun daha yeni s\u00fcr\u00fcmlerinde de b\u00fcy\u00fck \u00f6l\u00e7\u00fcde ge\u00e7erlili\u011fini koruyacakt\u0131r. Bu rehberin, y\u00f6netilen veritabanlar\u0131na ba\u011flanma s\u00fcre\u00e7lerinizi basitle\u015ftirmesi ve daha g\u00fcvenli hale getirmesi dile\u011fiyle.<br \/>\n<\/body><\/p>\n","protected":false},"excerpt":{"rendered":"Ubuntu 18.04 \u00dczerinden Y\u00f6netilen Veritabanlar\u0131na Ba\u011flanma Rehberi\nY\u00f6netilen veritabanlar\u0131, modern uygulama geli\u015ftirmenin ve altyap\u0131 y\u00f6netim","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":[1468],"tags":[],"class_list":{"0":"post-37547","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-ubuntu","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>Ubuntu 18.04 \u00dczerinden Y\u00f6netilen Veritabanlar\u0131na Ba\u011flanma Rehberi - 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\/ubuntu-18-04-uzerinden-yonetilen-veritabanlarina-baglanma-rehberi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Ubuntu 18.04 \u00dczerinden Y\u00f6netilen Veritabanlar\u0131na Ba\u011flanma Rehberi\" \/>\n<meta property=\"og:description\" content=\"Ubuntu 18.04 \u00dczerinden Y\u00f6netilen Veritabanlar\u0131na Ba\u011flanma Rehberi Y\u00f6netilen veritabanlar\u0131, modern uygulama geli\u015ftirmenin ve altyap\u0131 y\u00f6netim\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/ubuntu-18-04-uzerinden-yonetilen-veritabanlarina-baglanma-rehberi\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2026-01-08T11:41:02+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=\"20 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/ubuntu-18-04-uzerinden-yonetilen-veritabanlarina-baglanma-rehberi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/ubuntu-18-04-uzerinden-yonetilen-veritabanlarina-baglanma-rehberi\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"Ubuntu 18.04 \u00dczerinden Y\u00f6netilen Veritabanlar\u0131na Ba\u011flanma Rehberi\",\"datePublished\":\"2026-01-08T11:41:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/ubuntu-18-04-uzerinden-yonetilen-veritabanlarina-baglanma-rehberi\/\"},\"wordCount\":3271,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"articleSection\":[\"Ubuntu\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/ubuntu-18-04-uzerinden-yonetilen-veritabanlarina-baglanma-rehberi\/#respond\"]}],\"copyrightYear\":\"2026\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/ubuntu-18-04-uzerinden-yonetilen-veritabanlarina-baglanma-rehberi\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/ubuntu-18-04-uzerinden-yonetilen-veritabanlarina-baglanma-rehberi\/\",\"name\":\"Ubuntu 18.04 \u00dczerinden Y\u00f6netilen Veritabanlar\u0131na Ba\u011flanma Rehberi - Kodlar\u0131n Gizemli D\u00fcnyas\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2026-01-08T11:41:02+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/ubuntu-18-04-uzerinden-yonetilen-veritabanlarina-baglanma-rehberi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/ubuntu-18-04-uzerinden-yonetilen-veritabanlarina-baglanma-rehberi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/ubuntu-18-04-uzerinden-yonetilen-veritabanlarina-baglanma-rehberi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Ubuntu 18.04 \u00dczerinden Y\u00f6netilen Veritabanlar\u0131na Ba\u011flanma Rehberi\"}]},{\"@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":"Ubuntu 18.04 \u00dczerinden Y\u00f6netilen Veritabanlar\u0131na Ba\u011flanma Rehberi - 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\/ubuntu-18-04-uzerinden-yonetilen-veritabanlarina-baglanma-rehberi\/","og_locale":"tr_TR","og_type":"article","og_title":"Ubuntu 18.04 \u00dczerinden Y\u00f6netilen Veritabanlar\u0131na Ba\u011flanma Rehberi","og_description":"Ubuntu 18.04 \u00dczerinden Y\u00f6netilen Veritabanlar\u0131na Ba\u011flanma Rehberi Y\u00f6netilen veritabanlar\u0131, modern uygulama geli\u015ftirmenin ve altyap\u0131 y\u00f6netim","og_url":"https:\/\/fatihsoysal.com\/blog\/ubuntu-18-04-uzerinden-yonetilen-veritabanlarina-baglanma-rehberi\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2026-01-08T11:41:02+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"20 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/ubuntu-18-04-uzerinden-yonetilen-veritabanlarina-baglanma-rehberi\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/ubuntu-18-04-uzerinden-yonetilen-veritabanlarina-baglanma-rehberi\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"Ubuntu 18.04 \u00dczerinden Y\u00f6netilen Veritabanlar\u0131na Ba\u011flanma Rehberi","datePublished":"2026-01-08T11:41:02+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/ubuntu-18-04-uzerinden-yonetilen-veritabanlarina-baglanma-rehberi\/"},"wordCount":3271,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"articleSection":["Ubuntu"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/ubuntu-18-04-uzerinden-yonetilen-veritabanlarina-baglanma-rehberi\/#respond"]}],"copyrightYear":"2026","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/ubuntu-18-04-uzerinden-yonetilen-veritabanlarina-baglanma-rehberi\/","url":"https:\/\/fatihsoysal.com\/blog\/ubuntu-18-04-uzerinden-yonetilen-veritabanlarina-baglanma-rehberi\/","name":"Ubuntu 18.04 \u00dczerinden Y\u00f6netilen Veritabanlar\u0131na Ba\u011flanma Rehberi - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2026-01-08T11:41:02+00:00","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/ubuntu-18-04-uzerinden-yonetilen-veritabanlarina-baglanma-rehberi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/ubuntu-18-04-uzerinden-yonetilen-veritabanlarina-baglanma-rehberi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/ubuntu-18-04-uzerinden-yonetilen-veritabanlarina-baglanma-rehberi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Ubuntu 18.04 \u00dczerinden Y\u00f6netilen Veritabanlar\u0131na Ba\u011flanma Rehberi"}]},{"@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\/37547","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=37547"}],"version-history":[{"count":1,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/37547\/revisions"}],"predecessor-version":[{"id":37548,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/37547\/revisions\/37548"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=37547"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=37547"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=37547"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}