{"id":37632,"date":"2026-01-11T03:40:40","date_gmt":"2026-01-11T00:40:40","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/?p=37632"},"modified":"2026-01-11T03:40:40","modified_gmt":"2026-01-11T00:40:40","slug":"mysql-workbench-ile-uzak-mysql-sunucusuna-baglanma-rehberi","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/mysql-workbench-ile-uzak-mysql-sunucusuna-baglanma-rehberi\/","title":{"rendered":"MySQL Workbench ile Uzak MySQL Sunucusuna Ba\u011flanma Rehberi"},"content":{"rendered":"<p><body><\/p>\n<h2>MySQL Workbench ile Uzak MySQL Sunucusuna Ba\u011flanma Rehberi<\/h2>\n<h3>Giri\u015f<\/h3>\n<p>G\u00fcn\u00fcm\u00fcz\u00fcn veri odakl\u0131 d\u00fcnyas\u0131nda, veritabanlar\u0131 uygulamalar\u0131n ve hizmetlerin bel kemi\u011fini olu\u015fturmaktad\u0131r. MySQL, a\u00e7\u0131k kaynak kodlu ve yayg\u0131n olarak kullan\u0131lan bir ili\u015fkisel veritaban\u0131 y\u00f6netim sistemidir (RDBMS). Veritaban\u0131 y\u00f6neticileri, geli\u015ftiriciler ve veri analistleri i\u00e7in MySQL sunucular\u0131yla etkile\u015fim kurmak g\u00fcnl\u00fck i\u015flerin \u00f6nemli bir par\u00e7as\u0131d\u0131r. Bu etkile\u015fim genellikle yerel bir makineden uzak bir sunucuda \u00e7al\u0131\u015fan MySQL \u00f6rne\u011fine ba\u011flanmay\u0131 gerektirir. MySQL Workbench, bu t\u00fcr ba\u011flant\u0131lar\u0131 kolayla\u015ft\u0131ran, g\u00fc\u00e7l\u00fc ve g\u00f6rsel bir veritaban\u0131 y\u00f6netim arac\u0131d\u0131r.<\/p>\n<p>Bu makale, MySQL Workbench kullanarak uzak bir MySQL sunucusuna nas\u0131l g\u00fcvenli ve etkin bir \u015fekilde ba\u011flanaca\u011f\u0131n\u0131z\u0131 ad\u0131m ad\u0131m a\u00e7\u0131klamaktad\u0131r. Do\u011frudan TCP\/IP ba\u011flant\u0131s\u0131ndan SSH t\u00fcnelleme gibi daha g\u00fcvenli y\u00f6ntemlere kadar \u00e7e\u015fitli ba\u011flant\u0131 t\u00fcrlerini ele alacak, sunucu taraf\u0131 yap\u0131land\u0131rmalar\u0131n\u0131 ve g\u00fcvenlik en iyi uygulamalar\u0131n\u0131 detayland\u0131raca\u011f\u0131z. Amac\u0131m\u0131z, hem yeni ba\u015flayanlar hem de deneyimli kullan\u0131c\u0131lar i\u00e7in kapsaml\u0131 bir rehber sunarak uzak MySQL ba\u011flant\u0131lar\u0131n\u0131 sorunsuz bir \u015fekilde kurmalar\u0131na yard\u0131mc\u0131 olmakt\u0131r.<\/p>\n<h3>\u00d6n Gereksinimler<\/h3>\n<p>Uzak bir MySQL sunucusuna ba\u011flanmaya ba\u015flamadan \u00f6nce, baz\u0131 temel \u00f6n gereksinimlerin kar\u015f\u0131land\u0131\u011f\u0131ndan emin olman\u0131z gerekir:<\/p>\n<p>*   <strong>Uzak MySQL Sunucusu:<\/strong> Ba\u011flanmak istedi\u011finiz MySQL sunucusunun uzak bir konumda (ba\u015fka bir sunucu, bulut ortam\u0131 vb.) kurulu ve \u00e7al\u0131\u015f\u0131r durumda olmas\u0131 gerekir.<br \/>\n*   <strong>MySQL Workbench:<\/strong> Yerel makinenizde MySQL Workbench uygulamas\u0131n\u0131n kurulu olmas\u0131 gerekmektedir. MySQL&#8217;in resmi web sitesinden \u00fccretsiz olarak indirilebilir.<br \/>\n*   <strong>A\u011f Eri\u015fimi:<\/strong> Yerel makinenizin, uzak MySQL sunucusuna a\u011f \u00fczerinden eri\u015febiliyor olmas\u0131 \u015fartt\u0131r. Bu, sunucunun IP adresine ping atarak veya a\u011f yap\u0131land\u0131rman\u0131z\u0131 kontrol ederek do\u011frulanabilir.<br \/>\n*   <strong>Kimlik Bilgileri:<\/strong> Uzak MySQL sunucusunda ge\u00e7erli bir kullan\u0131c\u0131 ad\u0131 ve \u015fifreye sahip olman\u0131z gerekmektedir. Bu kullan\u0131c\u0131, uzak ba\u011flant\u0131 kurma iznine sahip olmal\u0131d\u0131r.<br \/>\n*   <strong>MySQL Sunucusunda Uzak Eri\u015fimin Etkinle\u015ftirilmesi:<\/strong> MySQL sunucusunun, uzak ba\u011flant\u0131lara izin verecek \u015fekilde yap\u0131land\u0131r\u0131lm\u0131\u015f olmas\u0131 ve sunucu taraf\u0131ndaki g\u00fcvenlik duvar\u0131n\u0131n MySQL portunu (varsay\u0131lan 3306) a\u00e7m\u0131\u015f olmas\u0131 gerekmektedir. Bu konu, makalenin ilerleyen b\u00f6l\u00fcmlerinde detayl\u0131ca ele al\u0131nacakt\u0131r.<\/p>\n<p>Bu \u00f6n gereksinimlerin kar\u015f\u0131land\u0131\u011f\u0131ndan emin olduktan sonra, uzak ba\u011flant\u0131 s\u00fcrecine ge\u00e7meye haz\u0131r\u0131z.<\/p>\n<h3>Uzak Ba\u011flant\u0131 Temelleri<\/h3>\n<p>Uzak bir MySQL sunucusuna ba\u011flan\u0131rken dikkate alman\u0131z gereken baz\u0131 temel kavramlar bulunmaktad\u0131r:<\/p>\n<p>*   <strong>IP Adresi \/ Ana Bilgisayar Ad\u0131:<\/strong> Uzak MySQL sunucusunun a\u011fdaki benzersiz adresidir. Bu bir IP adresi (\u00f6rne\u011fin, <code>192.168.1.100<\/code>) veya bir ana bilgisayar ad\u0131 (\u00f6rne\u011fin, <code>db.example.com<\/code>) olabilir.<br \/>\n*   <strong>Port:<\/strong> MySQL sunucusunun istemci ba\u011flant\u0131lar\u0131n\u0131 dinledi\u011fi a\u011f kap\u0131s\u0131d\u0131r. Varsay\u0131lan MySQL portu <code>3306<\/code>&#8216;d\u0131r. Sunucu y\u00f6neticisi bu portu de\u011fi\u015ftirmi\u015f olabilir, bu nedenle do\u011fru port numaras\u0131n\u0131 bilmek \u00f6nemlidir.<br \/>\n*   <strong>Kullan\u0131c\u0131 Hesaplar\u0131 ve Ayr\u0131cal\u0131klar:<\/strong> MySQL, kullan\u0131c\u0131lar\u0131n belirli veritabanlar\u0131na, tablolara veya i\u015flemlere eri\u015fimini kontrol etmek i\u00e7in ayr\u0131cal\u0131k sistemi kullan\u0131r. Uzak ba\u011flant\u0131 kuracak kullan\u0131c\u0131n\u0131n, ba\u011flanaca\u011f\u0131 ana bilgisayardan (veya herhangi bir ana bilgisayardan) ba\u011flant\u0131 kurma ve gerekli i\u015flemleri yapma ayr\u0131cal\u0131klar\u0131na sahip olmas\u0131 gerekir.<br \/>\n*   <strong>G\u00fcvenlik Duvar\u0131 Kurallar\u0131:<\/strong> Hem sunucu taraf\u0131nda hem de bazen istemci taraf\u0131nda g\u00fcvenlik duvarlar\u0131, belirli portlar \u00fczerinden gelen veya giden ba\u011flant\u0131lar\u0131 engelleyebilir. MySQL sunucusunun g\u00fcvenlik duvar\u0131, varsay\u0131lan 3306 portundan (veya yap\u0131land\u0131r\u0131lm\u0131\u015f ba\u015fka bir porttan) gelen ba\u011flant\u0131lara izin vermelidir.<\/p>\n<h3>MySQL Sunucusunu Uzak Eri\u015fime Haz\u0131rlama<\/h3>\n<p>Uzak bir MySQL sunucusuna ba\u011flanabilmek i\u00e7in, sunucunun kendisinin bu t\u00fcr ba\u011flant\u0131lara izin verecek \u015fekilde yap\u0131land\u0131r\u0131lmas\u0131 kritik \u00f6neme sahiptir. Bu genellikle \u00fc\u00e7 ana ad\u0131m\u0131 i\u00e7erir: <code>bind-address<\/code> yap\u0131land\u0131rmas\u0131, kullan\u0131c\u0131 ayr\u0131cal\u0131klar\u0131n\u0131n ayarlanmas\u0131 ve g\u00fcvenlik duvar\u0131 yap\u0131land\u0131rmas\u0131.<\/p>\n<h4>1. <code>bind-address<\/code> Yap\u0131land\u0131rmas\u0131<\/h4>\n<p>MySQL sunucusu, varsay\u0131lan olarak yaln\u0131zca <code>localhost<\/code> (127.0.0.1) \u00fczerinden gelen ba\u011flant\u0131lar\u0131 dinleyecek \u015fekilde yap\u0131land\u0131r\u0131lm\u0131\u015f olabilir. Uzak ba\u011flant\u0131lara izin vermek i\u00e7in bu ayar\u0131 de\u011fi\u015ftirmeniz gerekir.<\/p>\n<p>*   <strong>Yap\u0131land\u0131rma Dosyas\u0131:<\/strong> MySQL&#8217;in ana yap\u0131land\u0131rma dosyas\u0131 genellikle Linux sistemlerinde <code>\/etc\/mysql\/mysql.conf.d\/mysqld.cnf<\/code> veya <code>\/etc\/my.cnf<\/code>, Windows sistemlerinde ise <code>my.ini<\/code> olarak bulunur.<br \/>\n*   <strong>De\u011fi\u015fiklik:<\/strong> Bu dosyay\u0131 bir metin d\u00fczenleyici ile a\u00e7\u0131n ve <code>[mysqld]<\/code> b\u00f6l\u00fcm\u00fcn\u00fc bulun. <code>bind-address<\/code> sat\u0131r\u0131n\u0131 aray\u0131n.<br \/>\n    *   E\u011fer sat\u0131r <code>bind-address = 127.0.0.1<\/code> ise, bu sat\u0131r\u0131 <code>bind-address = 0.0.0.0<\/code> olarak de\u011fi\u015ftirerek t\u00fcm IP adreslerinden gelen ba\u011flant\u0131lara izin verebilirsiniz.<br \/>\n    *   Daha g\u00fcvenli bir yakla\u015f\u0131m, yaln\u0131zca belirli bir IP adresinden gelen ba\u011flant\u0131lara izin vermekse, o IP adresini belirtebilirsiniz (\u00f6rne\u011fin, <code>bind-address = 192.168.1.50<\/code>).<br \/>\n    *   Alternatif olarak, sat\u0131r\u0131 tamamen yorum sat\u0131r\u0131 haline getirebilirsiniz (<code># bind-address = 127.0.0.1<\/code>). Bu da genellikle t\u00fcm IP&#8217;lerden gelen ba\u011flant\u0131lara izin verir, ancak sunucu yap\u0131land\u0131rmas\u0131na ba\u011fl\u0131d\u0131r.<br \/>\n    *   <strong>\u00d6nemli Not:<\/strong> <code>0.0.0.0<\/code> kullanmak, sunucunuzun t\u00fcm a\u011f aray\u00fczlerinden gelen ba\u011flant\u0131lara a\u00e7\u0131k oldu\u011fu anlam\u0131na gelir. Bu, g\u00fcvenlik duvar\u0131 kurallar\u0131 ile desteklenmedi\u011fi takdirde ciddi bir g\u00fcvenlik riski olu\u015fturabilir. M\u00fcmk\u00fcnse, belirli IP adreslerini k\u0131s\u0131tlamak her zaman daha g\u00fcvenlidir.<br \/>\n*   <strong>Yeniden Ba\u015flatma:<\/strong> De\u011fi\u015fiklikleri kaydettikten sonra MySQL hizmetini yeniden ba\u015flatman\u0131z gerekir:<\/p>\n<pre><code class=\"language-bash\">sudo systemctl restart mysql # Linux<\/code><\/pre>\n<p>    veya Windows Hizmetler y\u00f6neticisinden MySQL hizmetini yeniden ba\u015flat\u0131n.<\/p>\n<h4>2. Kullan\u0131c\u0131 Ayr\u0131cal\u0131klar\u0131n\u0131 Yap\u0131land\u0131rma<\/h4>\n<p>MySQL sunucusunda, uzak ba\u011flant\u0131 kuracak bir kullan\u0131c\u0131n\u0131n tan\u0131mlanmas\u0131 ve ona gerekli ayr\u0131cal\u0131klar\u0131n verilmesi gerekir.<\/p>\n<p>*   <strong>MySQL Konsoluna Ba\u011flanma:<\/strong> \u0130lk olarak, sunucu \u00fczerinde MySQL konsoluna <code>root<\/code> kullan\u0131c\u0131s\u0131 veya yeterli ayr\u0131cal\u0131klara sahip bir kullan\u0131c\u0131 ile ba\u011flan\u0131n:<\/p>\n<pre><code class=\"language-bash\">mysql -u root -p<\/code><\/pre>\n<p>*   <strong>Yeni Kullan\u0131c\u0131 Olu\u015fturma ve Ayr\u0131cal\u0131k Verme:<\/strong><br \/>\n    E\u011fer hen\u00fcz bir kullan\u0131c\u0131n\u0131z yoksa veya mevcut kullan\u0131c\u0131n\u0131z\u0131n uzak ba\u011flant\u0131 izni yoksa, yeni bir kullan\u0131c\u0131 olu\u015fturabilir ve ona ayr\u0131cal\u0131klar verebilirsiniz. <code>%<\/code> i\u015fareti, kullan\u0131c\u0131n\u0131n herhangi bir ana bilgisayardan ba\u011flanabilece\u011fi anlam\u0131na gelir. Belirli bir IP adresinden ba\u011flant\u0131ya izin vermek i\u00e7in <code>%<\/code> yerine o IP adresini kullan\u0131n.<\/p>\n<pre><code class=\"language-sql\">-- Yeni bir kullan\u0131c\u0131 olu\u015fturma ve \u015fifre belirleme (uzak eri\u015fim i\u00e7in)\n    CREATE USER 'uzak_kullanici'@'%' IDENTIFIED BY 'guclu_sifre';\n\n    -- Belirli bir IP adresinden ba\u011flant\u0131ya izin vermek i\u00e7in:\n    -- CREATE USER 'uzak_kullanici'@'192.168.1.10' IDENTIFIED BY 'guclu_sifre';\n\n    -- Kullan\u0131c\u0131ya belirli bir veritaban\u0131 \u00fczerinde t\u00fcm ayr\u0131cal\u0131klar\u0131 verme\n    GRANT ALL PRIVILEGES ON veritabani_adi.* TO 'uzak_kullanici'@'%';\n\n    -- Sadece okuma ayr\u0131cal\u0131klar\u0131 vermek isterseniz:\n    -- GRANT SELECT ON veritabani_adi.* TO 'uzak_kullanici'@'%';\n\n    -- T\u00fcm veritabanlar\u0131 \u00fczerinde t\u00fcm ayr\u0131cal\u0131klar\u0131 vermek (genellikle \u00f6nerilmez)\n    -- GRANT ALL PRIVILEGES ON <em>.<\/em> TO 'uzak_kullanici'@'%';\n\n    -- Ayr\u0131cal\u0131klar\u0131 etkinle\u015ftirme\n    FLUSH PRIVILEGES;<\/code><\/pre>\n<p>    <code>uzak_kullanici<\/code>, <code>guclu_sifre<\/code> ve <code>veritabani_adi<\/code> yerine kendi de\u011ferlerinizi yazd\u0131\u011f\u0131n\u0131zdan emin olun.<\/p>\n<h4>3. Sunucu G\u00fcvenlik Duvar\u0131n\u0131 Yap\u0131land\u0131rma<\/h4>\n<p>Sunucunuzda \u00e7al\u0131\u015fan bir g\u00fcvenlik duvar\u0131 (firewall), MySQL portunu (varsay\u0131lan 3306) engelliyor olabilir. Bu portu d\u0131\u015far\u0131dan gelen ba\u011flant\u0131lara a\u00e7man\u0131z gerekmektedir.<\/p>\n<p>*   <strong>Linux (Ubuntu\/Debian &#8211; UFW):<\/strong><\/p>\n<pre><code class=\"language-bash\">sudo ufw allow 3306\/tcp\n    sudo ufw reload\n    sudo ufw enable # E\u011fer ufw aktif de\u011filse<\/code><\/pre>\n<p>*   <strong>Linux (CentOS\/RHEL &#8211; Firewalld):<\/strong><\/p>\n<pre><code class=\"language-bash\">sudo firewall-cmd --permanent --add-port=3306\/tcp\n    sudo firewall-cmd --reload<\/code><\/pre>\n<p>*   <strong>Windows G\u00fcvenlik Duvar\u0131:<\/strong><br \/>\n    *   &#8220;Windows Defender G\u00fcvenlik Duvar\u0131&#8221;n\u0131 a\u00e7\u0131n.<br \/>\n    *   &#8220;Geli\u015fmi\u015f Ayarlar&#8221;a t\u0131klay\u0131n.<br \/>\n    *   &#8220;Gelen Kurallar\u0131&#8221;na sa\u011f t\u0131klay\u0131n ve &#8220;Yeni Kural&#8230;&#8221; se\u00e7ene\u011fini se\u00e7in.<br \/>\n    *   &#8220;Port&#8221;u se\u00e7in, &#8220;TCP&#8221; se\u00e7ene\u011fini i\u015faretleyin ve &#8220;Belirli yerel ba\u011flant\u0131 noktalar\u0131&#8221; alan\u0131na <code>3306<\/code> yaz\u0131n.<br \/>\n    *   &#8220;Ba\u011flant\u0131ya \u0130zin Ver&#8221;i se\u00e7in.<br \/>\n    *   Kural\u0131n uygulanaca\u011f\u0131 a\u011f profillerini se\u00e7in (Etki Alan\u0131, \u00d6zel, Ortak).<br \/>\n    *   Kurala bir isim verin (\u00f6rne\u011fin, &#8220;MySQL 3306&#8221;) ve i\u015flemi tamamlay\u0131n.<br \/>\n*   <strong>Bulut Sa\u011flay\u0131c\u0131lar\u0131 (AWS, Azure, Google Cloud):<\/strong><br \/>\n    E\u011fer MySQL sunucunuz bir bulut platformunda \u00e7al\u0131\u015f\u0131yorsa, ilgili bulut sa\u011flay\u0131c\u0131s\u0131n\u0131n g\u00fcvenlik gruplar\u0131, a\u011f g\u00fcvenlik gruplar\u0131 veya g\u00fcvenlik duvar\u0131 kurallar\u0131 \u00fczerinden 3306 portuna gelen ba\u011flant\u0131lara izin vermeniz gerekir. Genellikle bu, sunucunun sanal a\u011f aray\u00fcz\u00fcne veya \u00f6rne\u011fine ba\u011fl\u0131 g\u00fcvenlik grubuna bir kural ekleyerek yap\u0131l\u0131r. Bu kural, belirli bir IP aral\u0131\u011f\u0131ndan (\u00f6rne\u011fin, kendi ofis IP&#8217;niz) veya t\u00fcm IP&#8217;lerden (<code>0.0.0.0\/0<\/code>) 3306 portuna TCP trafi\u011fine izin vermelidir.<\/p>\n<p>Bu ad\u0131mlar\u0131 tamamlad\u0131ktan sonra, MySQL sunucunuz uzak ba\u011flant\u0131lara haz\u0131r olmal\u0131d\u0131r.<\/p>\n<h3>MySQL Workbench ile Do\u011frudan TCP\/IP Ba\u011flant\u0131s\u0131 Kurma<\/h3>\n<p>\u015eimdi MySQL Workbench kullanarak uzak sunucunuza do\u011frudan bir TCP\/IP ba\u011flant\u0131s\u0131 kurma ad\u0131mlar\u0131na ge\u00e7elim. Bu y\u00f6ntem, sunucunuza do\u011frudan eri\u015fiminiz oldu\u011funda (\u00f6rne\u011fin, port 3306 a\u00e7\u0131ksa) kullan\u0131l\u0131r.<\/p>\n<h4>1. MySQL Workbench&#8217;i A\u00e7ma<\/h4>\n<p>Yerel makinenizde MySQL Workbench uygulamas\u0131n\u0131 ba\u015flat\u0131n.<\/p>\n<h4>2. Yeni Ba\u011flant\u0131 Ekleme<\/h4>\n<p>*   Workbench&#8217;in ana ekran\u0131nda, &#8220;MySQL Connections&#8221; panelinde &#8220;+&#8221; simgesine t\u0131klay\u0131n. Bu, yeni bir ba\u011flant\u0131 kurulum penceresini a\u00e7acakt\u0131r.<\/p>\n<h4>3. Ba\u011flant\u0131 Ayarlar\u0131n\u0131 Yap\u0131land\u0131rma<\/h4>\n<p>A\u00e7\u0131lan &#8220;Setup New Connection&#8221; penceresinde a\u015fa\u011f\u0131daki bilgileri girin:<\/p>\n<p>*   <strong>Connection Name (Ba\u011flant\u0131 Ad\u0131):<\/strong> Bu ba\u011flant\u0131 i\u00e7in anlaml\u0131 bir ad girin (\u00f6rne\u011fin, &#8220;Uzak Sunucu &#8211; \u00dcretim DB&#8221;). Bu ad, Workbench i\u00e7inde ba\u011flant\u0131y\u0131 tan\u0131mlamak i\u00e7in kullan\u0131l\u0131r.<br \/>\n*   <strong>Connection Method (Ba\u011flant\u0131 Y\u00f6ntemi):<\/strong> &#8220;Standard TCP\/IP&#8221; se\u00e7ene\u011fini se\u00e7in.<br \/>\n*   <strong>Hostname (Ana Bilgisayar Ad\u0131):<\/strong> Uzak MySQL sunucunuzun IP adresini veya ana bilgisayar ad\u0131n\u0131 girin (\u00f6rne\u011fin, <code>192.168.1.100<\/code> veya <code>db.example.com<\/code>).<br \/>\n*   <strong>Port:<\/strong> MySQL sunucunuzun dinledi\u011fi port numaras\u0131n\u0131 girin. Varsay\u0131lan olarak <code>3306<\/code>&#8216;d\u0131r.<br \/>\n*   <strong>Username (Kullan\u0131c\u0131 Ad\u0131):<\/strong> Uzak MySQL sunucusunda olu\u015fturdu\u011funuz veya size verilen kullan\u0131c\u0131 ad\u0131n\u0131 girin (\u00f6rne\u011fin, <code>uzak_kullanici<\/code>).<br \/>\n*   <strong>Password (\u015eifre):<\/strong> Kullan\u0131c\u0131 ad\u0131 i\u00e7in \u015fifreyi girmeniz gerekecektir.<br \/>\n    *   &#8220;Store in Vault&#8230;&#8221; (Kasaya Kaydet) se\u00e7ene\u011fini i\u015faretlerseniz, \u015fifreniz yerel olarak \u015fifrelenmi\u015f bir \u015fekilde kaydedilir ve her ba\u011flant\u0131da tekrar girmenize gerek kalmaz. Bu, kolayl\u0131k sa\u011flasa da, yerel makinenizin g\u00fcvenli\u011fi a\u00e7\u0131s\u0131ndan dikkatli olunmal\u0131d\u0131r.<br \/>\n    *   Bu se\u00e7ene\u011fi i\u015faretlemezseniz, her ba\u011flant\u0131 giri\u015fiminde \u015fifrenizi manuel olarak girmeniz istenecektir.<\/p>\n<h4>4. Ba\u011flant\u0131y\u0131 Test Etme<\/h4>\n<p>*   T\u00fcm bilgileri girdikten sonra, &#8220;Test Connection&#8221; d\u00fc\u011fmesine t\u0131klay\u0131n.<br \/>\n*   E\u011fer bilgiler do\u011fruysa ve sunucu eri\u015filebilir durumdaysa, &#8220;Successfully made the MySQL connection&#8221; (MySQL ba\u011flant\u0131s\u0131 ba\u015far\u0131yla kuruldu) mesaj\u0131n\u0131 g\u00f6rmelisiniz.<br \/>\n*   &#8220;OK&#8221; tu\u015funa t\u0131klayarak ba\u011flant\u0131y\u0131 kaydedin.<br \/>\n*   Art\u0131k ana ekranda yeni olu\u015fturdu\u011funuz ba\u011flant\u0131ya t\u0131klayarak uzak MySQL sunucunuza ba\u011flanabilirsiniz.<\/p>\n<h4>S\u0131k Kar\u015f\u0131la\u015f\u0131lan Sorunlar ve \u00c7\u00f6z\u00fcmleri (Do\u011frudan TCP\/IP)<\/h4>\n<p>*   <strong>&#8220;Can&#8217;t connect to MySQL server on &#8216;hostname&#8217; (10061)&#8221; veya benzeri bir hata:<\/strong><br \/>\n    *   <strong>\u00c7\u00f6z\u00fcm:<\/strong> Bu genellikle g\u00fcvenlik duvar\u0131 sorunudur. Sunucu taraf\u0131ndaki g\u00fcvenlik duvar\u0131n\u0131n 3306 portunu (veya kulland\u0131\u011f\u0131n\u0131z portu) a\u00e7t\u0131\u011f\u0131ndan emin olun. <code>bind-address<\/code> ayar\u0131n\u0131n <code>0.0.0.0<\/code> veya sunucunun eri\u015filebilir IP adresi olarak ayarland\u0131\u011f\u0131ndan emin olun ve MySQL hizmetini yeniden ba\u015flat\u0131n.<br \/>\n*   <strong>&#8220;Access denied for user &#8216;username&#8217;@&#8217;client_ip&#8217; (using password: YES)&#8221; hatas\u0131:<\/strong><br \/>\n    *   <strong>\u00c7\u00f6z\u00fcm:<\/strong> MySQL kullan\u0131c\u0131n\u0131z\u0131n <code>client_ip<\/code> adresinden (veya <code>%<\/code> ile herhangi bir yerden) ba\u011flanma ayr\u0131cal\u0131\u011f\u0131 yoktur. MySQL konsolunda <code>GRANT<\/code> komutunu kullanarak kullan\u0131c\u0131ya gerekli ayr\u0131cal\u0131klar\u0131 verdi\u011finizden ve <code>FLUSH PRIVILEGES<\/code> komutunu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zdan emin olun. Kullan\u0131c\u0131 ad\u0131n\u0131 ve \u015fifresini do\u011fru girdi\u011finizden de emin olun.<br \/>\n*   <strong>&#8220;Unknown database &#8216;database_name'&#8221; veya benzeri bir hata:<\/strong><br \/>\n    *   <strong>\u00c7\u00f6z\u00fcm:<\/strong> Ba\u011flant\u0131 ba\u015far\u0131l\u0131 ancak belirli bir veritaban\u0131na eri\u015fmeye \u00e7al\u0131\u015f\u0131rken bu hatay\u0131 al\u0131yorsan\u0131z, kullan\u0131c\u0131n\u0131n o veritaban\u0131 \u00fczerinde ayr\u0131cal\u0131klar\u0131 olmayabilir veya veritaban\u0131 ad\u0131 yanl\u0131\u015f yaz\u0131lm\u0131\u015f olabilir.<br \/>\n*   <strong>Yanl\u0131\u015f Ana Bilgisayar Ad\u0131 veya Port:<\/strong><br \/>\n    *   <strong>\u00c7\u00f6z\u00fcm:<\/strong> Uzak sunucunun IP adresini\/ana bilgisayar ad\u0131n\u0131 ve port numaras\u0131n\u0131 (varsay\u0131lan 3306) do\u011fru girdi\u011finizden emin olun.<\/p>\n<h3>SSH T\u00fcnelleme \u00dczerinden G\u00fcvenli Ba\u011flant\u0131 Kurma<\/h3>\n<p>Do\u011frudan TCP\/IP ba\u011flant\u0131s\u0131, g\u00fcvenlik duvar\u0131 kurallar\u0131 do\u011fru ayarlanmad\u0131\u011f\u0131nda veya internet \u00fczerinden \u015fifrelenmemi\u015f trafik g\u00f6nderdi\u011finizde g\u00fcvenlik riskleri ta\u015f\u0131yabilir. Bu gibi durumlarda veya do\u011frudan eri\u015fimin k\u0131s\u0131tland\u0131\u011f\u0131 ortamlarda (\u00f6rne\u011fin, bulut ortamlar\u0131nda veritaban\u0131 sunucular\u0131na do\u011frudan genel IP \u00fczerinden eri\u015fimin engellenmesi), SSH t\u00fcnelleme (SSH Tunneling) \u00e7ok daha g\u00fcvenli bir y\u00f6ntem sunar. SSH t\u00fcnelleme, t\u00fcm MySQL trafi\u011fini \u015fifreli bir SSH ba\u011flant\u0131s\u0131 \u00fczerinden y\u00f6nlendirir.<\/p>\n<h4>Neden SSH T\u00fcnelleme?<\/h4>\n<p>*   <strong>G\u00fcvenlik:<\/strong> T\u00fcm veri trafi\u011fi \u015fifrelenir, b\u00f6ylece a\u011f \u00fczerindeki dinlemelere kar\u015f\u0131 korunur.<br \/>\n*   <strong>G\u00fcvenlik Duvar\u0131 Bypass:<\/strong> MySQL portunun (3306) do\u011frudan internete a\u00e7\u0131k olmas\u0131na gerek kalmaz. Sadece SSH portunun (varsay\u0131lan 22) a\u00e7\u0131k olmas\u0131 yeterlidir.<br \/>\n*   <strong>\u0130\u00e7 A\u011f Eri\u015fimi:<\/strong> Uzak sunucunun i\u00e7 a\u011f\u0131nda \u00e7al\u0131\u015fan bir MySQL sunucusuna (genel IP&#8217;si olmayan) SSH t\u00fcneli \u00fczerinden eri\u015fim sa\u011flayabilirsiniz.<\/p>\n<h4>SSH T\u00fcnelleme \u00d6n Gereksinimleri<\/h4>\n<p>*   <strong>SSH Sunucusu:<\/strong> Uzak MySQL sunucusunun \u00e7al\u0131\u015ft\u0131\u011f\u0131 veya ona eri\u015fimi olan bir sunucuda SSH hizmetinin (OpenSSH Server gibi) kurulu ve \u00e7al\u0131\u015f\u0131r durumda olmas\u0131.<br \/>\n*   <strong>SSH Kullan\u0131c\u0131s\u0131:<\/strong> SSH sunucusuna ba\u011flanmak i\u00e7in ge\u00e7erli bir kullan\u0131c\u0131 ad\u0131 ve \u015fifre veya SSH anahtar\u0131 (public\/private key pair).<br \/>\n*   <strong>MySQL Sunucusunda <code>bind-address<\/code>:<\/strong> MySQL sunucusunun, SSH t\u00fcneli \u00fczerinden gelen ba\u011flant\u0131lara izin verecek \u015fekilde yap\u0131land\u0131r\u0131lm\u0131\u015f olmas\u0131. Genellikle SSH t\u00fcneli, MySQL sunucusuna <code>localhost<\/code> \u00fczerinden ba\u011flan\u0131r, bu nedenle <code>bind-address = 127.0.0.1<\/code> ayar\u0131 bu senaryoda sorun yaratmaz.<\/p>\n<h4>1. Yeni Ba\u011flant\u0131 Ekleme<\/h4>\n<p>*   MySQL Workbench&#8217;in ana ekran\u0131nda, &#8220;MySQL Connections&#8221; panelinde &#8220;+&#8221; simgesine t\u0131klayarak yeni bir ba\u011flant\u0131 kurulum penceresini a\u00e7\u0131n.<\/p>\n<h4>2. Ba\u011flant\u0131 Ayarlar\u0131n\u0131 Yap\u0131land\u0131rma<\/h4>\n<p>A\u00e7\u0131lan &#8220;Setup New Connection&#8221; penceresinde a\u015fa\u011f\u0131daki bilgileri girin:<\/p>\n<p>*   <strong>Connection Name (Ba\u011flant\u0131 Ad\u0131):<\/strong> Ba\u011flant\u0131 i\u00e7in anlaml\u0131 bir ad girin (\u00f6rne\u011fin, &#8220;Uzak Sunucu &#8211; SSH T\u00fcnel&#8221;).<br \/>\n*   <strong>Connection Method (Ba\u011flant\u0131 Y\u00f6ntemi):<\/strong> &#8220;Standard TCP\/IP over SSH&#8221; se\u00e7ene\u011fini se\u00e7in.<\/p>\n<p>\u015eimdi iki ayr\u0131 b\u00f6l\u00fcm g\u00f6receksiniz: SSH ve MySQL ayarlar\u0131.<\/p>\n<h4>SSH Ayarlar\u0131:<\/h4>\n<p>Bu b\u00f6l\u00fcm, SSH sunucusuna nas\u0131l ba\u011flanaca\u011f\u0131n\u0131z\u0131 yap\u0131land\u0131rmak i\u00e7indir.<\/p>\n<p>*   <strong>SSH Hostname (SSH Ana Bilgisayar Ad\u0131):<\/strong> SSH ba\u011flant\u0131s\u0131 kuraca\u011f\u0131n\u0131z sunucunun IP adresini veya ana bilgisayar ad\u0131n\u0131 girin (\u00f6rne\u011fin, <code>ssh.example.com<\/code> veya <code>192.168.1.100<\/code>). Bu, MySQL sunucusuyla ayn\u0131 sunucu olabilir veya MySQL sunucusunun eri\u015febildi\u011fi ba\u015fka bir sunucu olabilir.<br \/>\n*   <strong>SSH Port:<\/strong> SSH sunucusunun dinledi\u011fi port numaras\u0131n\u0131 girin. Varsay\u0131lan olarak <code>22<\/code>&#8216;dir.<br \/>\n*   <strong>SSH Username (SSH Kullan\u0131c\u0131 Ad\u0131):<\/strong> SSH sunucusuna ba\u011flanmak i\u00e7in kullanaca\u011f\u0131n\u0131z kullan\u0131c\u0131 ad\u0131n\u0131 girin.<br \/>\n*   <strong>SSH Key File (SSH Anahtar Dosyas\u0131):<\/strong> E\u011fer SSH anahtar tabanl\u0131 kimlik do\u011frulama kullan\u0131yorsan\u0131z, \u00f6zel anahtar dosyan\u0131z\u0131n yolunu belirtin (\u00f6rne\u011fin, <code>~\/.ssh\/id_rsa<\/code>).<br \/>\n*   <strong>SSH Password (SSH \u015eifresi):<\/strong> E\u011fer SSH anahtar dosyas\u0131 kullanm\u0131yorsan\u0131z veya anahtar dosyan\u0131z\u0131n bir parolas\u0131 varsa, SSH kullan\u0131c\u0131n\u0131z\u0131n \u015fifresini buraya girin. &#8220;Store in Vault&#8230;&#8221; se\u00e7ene\u011fini kullanarak \u015fifreyi kaydedebilirsiniz.<\/p>\n<h4>MySQL Ayarlar\u0131 (T\u00fcnel \u00dczerinden):<\/h4>\n<p>Bu b\u00f6l\u00fcm, SSH t\u00fcneli kurulduktan sonra t\u00fcnel \u00fczerinden MySQL sunucusuna nas\u0131l ba\u011flanaca\u011f\u0131n\u0131z\u0131 yap\u0131land\u0131rmak i\u00e7indir.<\/p>\n<p>*   <strong>MySQL Hostname (MySQL Ana Bilgisayar Ad\u0131):<\/strong> Bu genellikle <code>127.0.0.1<\/code> veya <code>localhost<\/code> olmal\u0131d\u0131r. \u00c7\u00fcnk\u00fc SSH t\u00fcneli, uzak MySQL sunucusuna yerel olarak (SSH sunucusu a\u00e7\u0131s\u0131ndan) ba\u011flanacakt\u0131r.<br \/>\n*   <strong>MySQL Port:<\/strong> MySQL sunucusunun SSH sunucusunda dinledi\u011fi port numaras\u0131d\u0131r. Varsay\u0131lan olarak <code>3306<\/code>&#8216;d\u0131r.<br \/>\n*   <strong>Username (Kullan\u0131c\u0131 Ad\u0131):<\/strong> Uzak MySQL sunucusundaki kullan\u0131c\u0131 ad\u0131n\u0131 girin (\u00f6rne\u011fin, <code>uzak_kullanici<\/code>).<br \/>\n*   <strong>Password (\u015eifre):<\/strong> MySQL kullan\u0131c\u0131n\u0131z\u0131n \u015fifresini girin. &#8220;Store in Vault&#8230;&#8221; se\u00e7ene\u011fini kullanarak \u015fifreyi kaydedebilirsiniz.<\/p>\n<h4>3. Ba\u011flant\u0131y\u0131 Test Etme<\/h4>\n<p>*   T\u00fcm bilgileri girdikten sonra, &#8220;Test Connection&#8221; d\u00fc\u011fmesine t\u0131klay\u0131n.<br \/>\n*   \u00d6nce SSH ba\u011flant\u0131s\u0131 kurulmaya \u00e7al\u0131\u015facak, ard\u0131ndan t\u00fcnel \u00fczerinden MySQL ba\u011flant\u0131s\u0131 denenecektir.<br \/>\n*   E\u011fer her \u015fey do\u011fruysa, &#8220;Successfully made the MySQL connection&#8221; (MySQL ba\u011flant\u0131s\u0131 ba\u015far\u0131yla kuruldu) mesaj\u0131n\u0131 g\u00f6rmelisiniz.<br \/>\n*   &#8220;OK&#8221; tu\u015funa t\u0131klayarak ba\u011flant\u0131y\u0131 kaydedin.<br \/>\n*   Art\u0131k ana ekranda yeni olu\u015fturdu\u011funuz ba\u011flant\u0131ya t\u0131klayarak uzak MySQL sunucunuza SSH t\u00fcneli \u00fczerinden g\u00fcvenli bir \u015fekilde ba\u011flanabilirsiniz.<\/p>\n<h4>SSH T\u00fcnelleme Sorunlar\u0131 ve \u00c7\u00f6z\u00fcmleri<\/h4>\n<p>*   <strong>&#8220;SSH connection failed&#8221; veya benzeri bir hata:<\/strong><br \/>\n    *   <strong>\u00c7\u00f6z\u00fcm:<\/strong> SSH ana bilgisayar ad\u0131, port, kullan\u0131c\u0131 ad\u0131 veya kimlik do\u011frulama bilgileri (\u015fifre\/anahtar dosyas\u0131) yanl\u0131\u015f olabilir. SSH sunucusuna ba\u015fka bir SSH istemcisi (\u00f6rne\u011fin, PuTTY veya terminalden <code>ssh user@host<\/code>) ile ba\u011flanmay\u0131 deneyerek SSH ba\u011flant\u0131s\u0131n\u0131n \u00e7al\u0131\u015f\u0131p \u00e7al\u0131\u015fmad\u0131\u011f\u0131n\u0131 kontrol edin. SSH portunun (varsay\u0131lan 22) sunucu g\u00fcvenlik duvar\u0131nda a\u00e7\u0131k oldu\u011fundan emin olun.<br \/>\n*   <strong>&#8220;Can&#8217;t connect to MySQL server on &#8216;127.0.0.1&#8217; (10061)&#8221; veya benzeri bir hata (SSH ba\u015far\u0131l\u0131 olduktan sonra):<\/strong><br \/>\n    *   <strong>\u00c7\u00f6z\u00fcm:<\/strong> Bu, SSH t\u00fcneli kurulduktan sonra MySQL sunucusuna yerel olarak ba\u011flan\u0131lamad\u0131\u011f\u0131 anlam\u0131na gelir. MySQL sunucusunun <code>bind-address<\/code> ayar\u0131n\u0131n <code>127.0.0.1<\/code> veya <code>0.0.0.0<\/code> olarak ayarland\u0131\u011f\u0131ndan emin olun ve MySQL hizmetini yeniden ba\u015flat\u0131n. Ayr\u0131ca MySQL kullan\u0131c\u0131s\u0131n\u0131n <code>localhost<\/code> \u00fczerinden ba\u011flanma ayr\u0131cal\u0131\u011f\u0131na sahip oldu\u011fundan emin olun (<code>'uzak_kullanici'@'localhost'<\/code>).<br \/>\n*   <strong>Yanl\u0131\u015f MySQL Portu (SSH t\u00fcneli \u00fczerinden):<\/strong><br \/>\n    *   <strong>\u00c7\u00f6z\u00fcm:<\/strong> SSH t\u00fcneli \u00fczerinden ba\u011flan\u0131rken MySQL portunun (varsay\u0131lan 3306) do\u011fru oldu\u011fundan emin olun. Bu, SSH sunucusu \u00fczerindeki MySQL \u00f6rne\u011finin dinledi\u011fi porttur.<\/p>\n<h3>G\u00fcvenlik En \u0130yi Uygulamalar\u0131<\/h3>\n<p>Uzak MySQL ba\u011flant\u0131lar\u0131 kurarken g\u00fcvenlik her zaman \u00f6ncelikli olmal\u0131d\u0131r. A\u015fa\u011f\u0131daki en iyi uygulamalar\u0131 takip etmek, veritaban\u0131 sistemlerinizin g\u00fcvenli\u011fini art\u0131rman\u0131za yard\u0131mc\u0131 olacakt\u0131r:<\/p>\n<p>*   <strong>G\u00fc\u00e7l\u00fc \u015eifreler Kullan\u0131n:<\/strong> Hem MySQL kullan\u0131c\u0131lar\u0131 hem de SSH kullan\u0131c\u0131lar\u0131 i\u00e7in uzun, karma\u015f\u0131k ve benzersiz \u015fifreler kullan\u0131n. \u015eifrelerinizi d\u00fczenli olarak g\u00fcncellemeyi d\u00fc\u015f\u00fcn\u00fcn.<br \/>\n<em>   <strong>En Az Ayr\u0131cal\u0131k Prensibi:<\/strong> MySQL kullan\u0131c\u0131lar\u0131na yaln\u0131zca g\u00f6revlerini yerine getirmek i\u00e7in kesinlikle ihtiya\u00e7 duyduklar\u0131 ayr\u0131cal\u0131klar\u0131 verin. \u00d6rne\u011fin, bir uygulaman\u0131n yaln\u0131zca okuma eri\u015fimine ihtiyac\u0131 varsa, ona <code>SELECT<\/code> d\u0131\u015f\u0131ndaki ayr\u0131cal\u0131klar\u0131 vermeyin. <code>GRANT ALL PRIVILEGES ON <\/em>.*<\/code> gibi geni\u015f ayr\u0131cal\u0131klar vermekten ka\u00e7\u0131n\u0131n.<br \/>\n*   <strong>SSH T\u00fcnelleme Kullan\u0131m\u0131:<\/strong> M\u00fcmk\u00fcnse, do\u011frudan TCP\/IP ba\u011flant\u0131lar\u0131 yerine SSH t\u00fcnelleme \u00fczerinden ba\u011flant\u0131 kurmay\u0131 tercih edin. Bu, t\u00fcm trafi\u011fi \u015fifreleyerek g\u00fcvenlik katman\u0131 ekler ve MySQL portunun do\u011frudan internete a\u00e7\u0131k olma ihtiyac\u0131n\u0131 ortadan kald\u0131r\u0131r.<br \/>\n*   <strong>IP K\u0131s\u0131tlamalar\u0131:<\/strong> MySQL kullan\u0131c\u0131lar\u0131 olu\u015ftururken <code>%<\/code> yerine belirli IP adreslerini veya IP aral\u0131klar\u0131n\u0131 (<code>'uzak_kullanici'@'192.168.1.10'<\/code>) kullanarak ba\u011flant\u0131lar\u0131 k\u0131s\u0131tlay\u0131n. Ayn\u0131 \u015fekilde, sunucu g\u00fcvenlik duvar\u0131nda da yaln\u0131zca g\u00fcvenilir IP adreslerinden gelen ba\u011flant\u0131lara izin verin.<br \/>\n*   <strong>Yaz\u0131l\u0131m G\u00fcncellemeleri:<\/strong> Hem MySQL sunucusu hem de MySQL Workbench dahil olmak \u00fczere t\u00fcm yaz\u0131l\u0131mlar\u0131n\u0131z\u0131 g\u00fcncel tutun. G\u00fcncellemeler genellikle g\u00fcvenlik a\u00e7\u0131klar\u0131n\u0131 gideren yamalar i\u00e7erir.<br \/>\n*   <strong>D\u00fczenli Yedeklemeler:<\/strong> Veritaban\u0131n\u0131z\u0131n d\u00fczenli yedeklerini al\u0131n ve bu yedekleri g\u00fcvenli bir yerde saklay\u0131n. Bu, olas\u0131 bir veri kayb\u0131 veya g\u00fcvenlik ihlali durumunda kurtarma i\u00e7in hayati \u00f6neme sahiptir.<br \/>\n*   <strong>Varsay\u0131lan Portlar\u0131 De\u011fi\u015ftirme (\u0130ste\u011fe Ba\u011fl\u0131):<\/strong> MySQL&#8217;in varsay\u0131lan portu olan 3306&#8217;y\u0131 veya SSH&#8217;in varsay\u0131lan portu olan 22&#8217;yi de\u011fi\u015ftirmek, otomatik taramalardan kaynaklanan baz\u0131 y\u00fczeysel sald\u0131r\u0131lar\u0131 azaltabilir. Ancak bu, tek ba\u015f\u0131na bir g\u00fcvenlik \u00f6nlemi de\u011fildir ve g\u00fcvenlik duvar\u0131 kurallar\u0131n\u0131n yerini tutmaz.<\/p>\n<h3>Sonu\u00e7<\/h3>\n<p>MySQL Workbench, uzak MySQL sunucular\u0131yla etkile\u015fim kurmak i\u00e7in g\u00fc\u00e7l\u00fc ve kullan\u0131c\u0131 dostu bir aray\u00fcz sa\u011flar. Bu makalede ele ald\u0131\u011f\u0131m\u0131z ad\u0131mlar\u0131 izleyerek, hem do\u011frudan TCP\/IP ba\u011flant\u0131s\u0131 hem de SSH t\u00fcnelleme gibi daha g\u00fcvenli y\u00f6ntemlerle uzak sunucular\u0131n\u0131za ba\u015far\u0131yla ba\u011flanabilirsiniz.<\/p>\n<p>Unutmay\u0131n ki ba\u015far\u0131l\u0131 bir uzak ba\u011flant\u0131 kurman\u0131n anahtar\u0131, hem istemci taraf\u0131ndaki (MySQL Workbench) hem de sunucu taraf\u0131ndaki (MySQL yap\u0131land\u0131rmas\u0131, kullan\u0131c\u0131 ayr\u0131cal\u0131klar\u0131, g\u00fcvenlik duvar\u0131) do\u011fru ayarlard\u0131r. \u00d6zellikle, <code>bind-address<\/code> yap\u0131land\u0131rmas\u0131, kullan\u0131c\u0131 ayr\u0131cal\u0131klar\u0131 ve g\u00fcvenlik duvar\u0131 kurallar\u0131, ba\u011flant\u0131n\u0131n kurulmas\u0131nda kritik rol oynar.<\/p>\n<p>Her zaman g\u00fcvenlik en iyi uygulamalar\u0131n\u0131 g\u00f6z \u00f6n\u00fcnde bulundurarak g\u00fc\u00e7l\u00fc \u015fifreler kullan\u0131n, en az ayr\u0131cal\u0131k prensibini uygulay\u0131n ve m\u00fcmk\u00fcn oldu\u011funda SSH t\u00fcnelleme gibi g\u00fcvenli ba\u011flant\u0131 y\u00f6ntemlerini tercih edin. Bu \u00f6nlemler, de\u011ferli veritaban\u0131 varl\u0131klar\u0131n\u0131z\u0131 yetkisiz eri\u015fime ve potansiyel tehditlere kar\u015f\u0131 koruman\u0131za yard\u0131mc\u0131 olacakt\u0131r. Bu rehberin, MySQL Workbench ile uzak MySQL sunucular\u0131na ba\u011flanma s\u00fcrecini sizin i\u00e7in basitle\u015ftirdi\u011fini umuyoruz.<\/body><\/p>\n","protected":false},"excerpt":{"rendered":"MySQL Workbench ile Uzak MySQL Sunucusuna Ba\u011flanma Rehberi\nGiri\u015f\nG\u00fcn\u00fcm\u00fcz\u00fcn veri odakl\u0131 d\u00fcnyas\u0131nda, veritabanlar\u0131 uygulamalar\u0131n ve hizmetle","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":[138],"tags":[],"class_list":{"0":"post-37632","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-mysql","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>MySQL Workbench ile Uzak MySQL Sunucusuna 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\/mysql-workbench-ile-uzak-mysql-sunucusuna-baglanma-rehberi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL Workbench ile Uzak MySQL Sunucusuna Ba\u011flanma Rehberi\" \/>\n<meta property=\"og:description\" content=\"MySQL Workbench ile Uzak MySQL Sunucusuna Ba\u011flanma Rehberi Giri\u015f G\u00fcn\u00fcm\u00fcz\u00fcn veri odakl\u0131 d\u00fcnyas\u0131nda, veritabanlar\u0131 uygulamalar\u0131n ve hizmetle\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/mysql-workbench-ile-uzak-mysql-sunucusuna-baglanma-rehberi\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2026-01-11T00:40:40+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=\"18 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-workbench-ile-uzak-mysql-sunucusuna-baglanma-rehberi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-workbench-ile-uzak-mysql-sunucusuna-baglanma-rehberi\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"MySQL Workbench ile Uzak MySQL Sunucusuna Ba\u011flanma Rehberi\",\"datePublished\":\"2026-01-11T00:40:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-workbench-ile-uzak-mysql-sunucusuna-baglanma-rehberi\/\"},\"wordCount\":3325,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"articleSection\":[\"MySQL\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/mysql-workbench-ile-uzak-mysql-sunucusuna-baglanma-rehberi\/#respond\"]}],\"copyrightYear\":\"2026\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-workbench-ile-uzak-mysql-sunucusuna-baglanma-rehberi\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/mysql-workbench-ile-uzak-mysql-sunucusuna-baglanma-rehberi\/\",\"name\":\"MySQL Workbench ile Uzak MySQL Sunucusuna Ba\u011flanma Rehberi - Kodlar\u0131n Gizemli D\u00fcnyas\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2026-01-11T00:40:40+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-workbench-ile-uzak-mysql-sunucusuna-baglanma-rehberi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/mysql-workbench-ile-uzak-mysql-sunucusuna-baglanma-rehberi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-workbench-ile-uzak-mysql-sunucusuna-baglanma-rehberi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL Workbench ile Uzak MySQL Sunucusuna 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":"MySQL Workbench ile Uzak MySQL Sunucusuna 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\/mysql-workbench-ile-uzak-mysql-sunucusuna-baglanma-rehberi\/","og_locale":"tr_TR","og_type":"article","og_title":"MySQL Workbench ile Uzak MySQL Sunucusuna Ba\u011flanma Rehberi","og_description":"MySQL Workbench ile Uzak MySQL Sunucusuna Ba\u011flanma Rehberi Giri\u015f G\u00fcn\u00fcm\u00fcz\u00fcn veri odakl\u0131 d\u00fcnyas\u0131nda, veritabanlar\u0131 uygulamalar\u0131n ve hizmetle","og_url":"https:\/\/fatihsoysal.com\/blog\/mysql-workbench-ile-uzak-mysql-sunucusuna-baglanma-rehberi\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2026-01-11T00:40:40+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"18 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/mysql-workbench-ile-uzak-mysql-sunucusuna-baglanma-rehberi\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/mysql-workbench-ile-uzak-mysql-sunucusuna-baglanma-rehberi\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"MySQL Workbench ile Uzak MySQL Sunucusuna Ba\u011flanma Rehberi","datePublished":"2026-01-11T00:40:40+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/mysql-workbench-ile-uzak-mysql-sunucusuna-baglanma-rehberi\/"},"wordCount":3325,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"articleSection":["MySQL"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/mysql-workbench-ile-uzak-mysql-sunucusuna-baglanma-rehberi\/#respond"]}],"copyrightYear":"2026","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/mysql-workbench-ile-uzak-mysql-sunucusuna-baglanma-rehberi\/","url":"https:\/\/fatihsoysal.com\/blog\/mysql-workbench-ile-uzak-mysql-sunucusuna-baglanma-rehberi\/","name":"MySQL Workbench ile Uzak MySQL Sunucusuna Ba\u011flanma Rehberi - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2026-01-11T00:40:40+00:00","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/mysql-workbench-ile-uzak-mysql-sunucusuna-baglanma-rehberi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/mysql-workbench-ile-uzak-mysql-sunucusuna-baglanma-rehberi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/mysql-workbench-ile-uzak-mysql-sunucusuna-baglanma-rehberi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MySQL Workbench ile Uzak MySQL Sunucusuna 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\/37632","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=37632"}],"version-history":[{"count":1,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/37632\/revisions"}],"predecessor-version":[{"id":37633,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/37632\/revisions\/37633"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=37632"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=37632"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=37632"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}