{"id":1111,"date":"2025-09-23T16:41:48","date_gmt":"2025-09-23T13:41:48","guid":{"rendered":"https:\/\/narhost.com\/destek\/?p=1111"},"modified":"2026-09-12T14:02:51","modified_gmt":"2026-09-12T11:02:51","slug":"mysql-sunucuya-nasil-baglanilir","status":"publish","type":"post","link":"https:\/\/narhost.com\/destek\/mysql-sunucuya-nasil-baglanilir\/","title":{"rendered":"MySQL Sunucuya Nas\u0131l Ba\u011flan\u0131l\u0131r"},"content":{"rendered":"<p class=\"kb-dogrulama\">Son do\u011frulama: Eyl\u00fcl 2026 \u00b7 cPanel 136 test hesab\u0131nda denendi<\/p>\n<div id=\"hizli-cozum\" class=\"ai-box ai-box--cozum\">\n<p class=\"ai-box-title\">H\u0131zl\u0131 \u00e7\u00f6z\u00fcm<\/p>\n<p>Mysql sunucuya nas\u0131l ba\u011flan\u0131l\u0131r sorusu genelde uygulaman\u0131z\u0131n (yerel bilgisayar\u0131n\u0131zdaki bir program, ba\u015fka bir sunucudaki site) veritaban\u0131n\u0131za d\u0131\u015far\u0131dan eri\u015fmek istedi\u011fi durumda sorulur. Payla\u015f\u0131ml\u0131 hostingde bu ba\u011flant\u0131 varsay\u0131lan olarak kapal\u0131d\u0131r: \u00f6nce cPanel&#8217;deki <strong>Uzak MySQL<\/strong> ekran\u0131ndan ba\u011flanaca\u011f\u0131n\u0131z cihaz\u0131n IP adresini izinli h\u00e2le getirmeniz, ard\u0131ndan sunucu ad\u0131, kullan\u0131c\u0131 ad\u0131, \u015fifre ve <code>3306<\/code> portunu uygulaman\u0131za do\u011fru girmeniz gerekir.<\/p>\n<ol>\n<li>cPanel \u2192 Veritabanlar\u0131 \u2192 <strong>Uzak MySQL<\/strong> ekran\u0131ndan ba\u011flanaca\u011f\u0131n\u0131z IP&#8217;yi ekleyin.<\/li>\n<li>cPanel \u2192 Veritabanlar\u0131 \u2192 <strong>Veritabanlar\u0131m\u0131 Y\u00f6net<\/strong> ekran\u0131ndan sunucu ad\u0131n\u0131 ve kullan\u0131c\u0131 ad\u0131n\u0131 not edin.<\/li>\n<li>Uygulaman\u0131zda sunucu ad\u0131, kullan\u0131c\u0131 ad\u0131, \u015fifre ve <code>3306<\/code> portunu girip ba\u011flan\u0131n.<\/li>\n<\/ol>\n<\/div>\n<table class=\"kb-uyg\">\n<tr>\n<th>Panel<\/th>\n<td>cPanel<\/td>\n<\/tr>\n<tr>\n<th>Sistem<\/th>\n<td>Payla\u015f\u0131ml\u0131 hosting (CloudLinux, MariaDB 10.11)<\/td>\n<\/tr>\n<tr>\n<th>Yetki<\/th>\n<td>cPanel kullan\u0131c\u0131s\u0131<\/td>\n<\/tr>\n<tr>\n<th>Narhost \u00fcr\u00fcn\u00fc<\/th>\n<td><a href=\"https:\/\/narhost.com\/web-hosting\" title=\"Web Hosting paketleri - Narhost\">Web Hosting<\/a><\/td>\n<\/tr>\n<\/table>\n<div class=\"kb-once\">\n<p class=\"label\">Ba\u015flamadan \u00f6nce<\/p>\n<ul>\n<li>Ba\u011flanaca\u011f\u0131n\u0131z veritaban\u0131n\u0131n ad\u0131 ve o veritaban\u0131na yetkili kullan\u0131c\u0131 ad\u0131.<\/li>\n<li>Ba\u011flant\u0131y\u0131 yapaca\u011f\u0131n\u0131z cihaz\u0131n ya da sunucunun IP adresi; de\u011fi\u015fken (dinamik) bir IP&#8217;niz varsa bunu bilmeniz gerekir.<\/li>\n<li>Bu pakette SSH eri\u015fimi yoktur; ba\u011flant\u0131 komut sat\u0131r\u0131ndan de\u011fil, uygulaman\u0131z\u0131n veritaban\u0131 ayarlar\u0131 ekran\u0131ndan yap\u0131l\u0131r.<\/li>\n<\/ul>\n<\/div>\n<h2>Uzaktan MySQL ba\u011flant\u0131s\u0131 neden kapal\u0131 gelir<\/h2>\n<p>Narhost&#8217;un payla\u015f\u0131ml\u0131 hosting paketlerinde MySQL veritaban\u0131 sunucusu varsay\u0131lan olarak yaln\u0131zca kendi hesab\u0131n\u0131z\u0131n uygulamalar\u0131na (ayn\u0131 sunucudaki WordPress gibi) a\u00e7\u0131kt\u0131r; d\u0131\u015far\u0131dan gelen ba\u011flant\u0131lar g\u00fcvenlik amac\u0131yla reddedilir. Uzaktan \u00e7al\u0131\u015fan bir program\u0131n (masa\u00fcst\u00fc veritaban\u0131 istemcisi, ba\u015fka bir sunucudaki uygulama) veritaban\u0131n\u0131za eri\u015fmesi i\u00e7in \u00f6nce o cihaz\u0131n IP adresini tan\u0131mlaman\u0131z gerekir; bu izin cPanel&#8217;deki <strong>Uzak MySQL<\/strong> ekran\u0131ndan verilir; cPanel&#8217;in resmi <a href=\"https:\/\/docs.cpanel.net\/cpanel\/databases\/remote-mysql\/\" title=\"Remote MySQL resmi dok\u00fcmantasyonu - cPanel\" target=\"_blank\" rel=\"noopener\">Remote MySQL belgesine<\/a> g\u00f6re bu ekran her IP&#8217;yi ayr\u0131 ayr\u0131 ya da joker karakterle geni\u015f bir aral\u0131k olarak tan\u0131mlaman\u0131za izin verir.<\/p>\n<p>Mysql sunucuya nas\u0131l ba\u011flan\u0131l\u0131r sorusunun ikinci yar\u0131s\u0131 ba\u011flant\u0131 bilgilerinin do\u011fru girilmesidir. Sunucu ad\u0131 olarak <code>localhost<\/code> yazmak yaln\u0131zca ayn\u0131 hesap i\u00e7indeki uygulamalarda i\u015fe yarar; d\u0131\u015far\u0131dan ba\u011flan\u0131rken hesab\u0131n\u0131z\u0131n bulundu\u011fu sunucunun ad\u0131 (\u00f6r. <code>lincp1.narhost.com<\/code>) kullan\u0131l\u0131r. Kullan\u0131c\u0131 ad\u0131 da cPanel&#8217;de otomatik olarak hesap ad\u0131yla birle\u015ftirilmi\u015f bi\u00e7imde olu\u015fur.<\/p>\n<h2>Ad\u0131m ad\u0131m mysql sunucuya nas\u0131l ba\u011flan\u0131l\u0131r<\/h2>\n<h3>Y\u00f6ntem 1 \u2014 Uzak MySQL&#8217;de eri\u015fim izni verme<\/h3>\n<ol class=\"kb-adimlar\">\n<li><strong>cPanel \u2192 Veritabanlar\u0131 \u2192 Uzak MySQL<\/strong> ekran\u0131n\u0131 a\u00e7\u0131n; ba\u011flanaca\u011f\u0131n\u0131z cihaz\u0131n IP adresini &#8220;Eri\u015fime \u0130zin Ver&#8221; alan\u0131na girip ekleyin.<br \/>\n<figure class=\"kb-ekran\"><img decoding=\"async\" src=\"https:\/\/narhost.com\/destek\/wp-content\/uploads\/2026\/09\/mysql-sunucuya-nasil-baglanilir-adim-1.webp\" alt=\"mysql sunucuya nas\u0131l ba\u011flan\u0131l\u0131r sorusunda Uzak MySQL ekran\u0131nda IP adresine eri\u015fim izni verme formu\" width=\"1200\" height=\"572\" loading=\"lazy\"><figcaption>Uzak MySQL ekran\u0131; ba\u011flanacak cihaz\u0131n IP adresi bu formdan eklenir.<\/figcaption><\/figure>\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: girdi\u011finiz IP, izinli sunucular listesine eklenir.<\/p>\n<\/li>\n<li>IP&#8217;nizi bilmiyorsan\u0131z &#8220;%&#8221; ile geni\u015f bir aral\u0131k tan\u0131mlamak yerine, ba\u011flanaca\u011f\u0131n\u0131z cihaz\u0131n g\u00fcncel IP&#8217;sini bir arama motorundan \u00f6\u011frenip tam olarak girin; geni\u015f aral\u0131k g\u00fcvenlik riski olu\u015fturur.<\/li>\n<li>Ekledi\u011finiz IP&#8217;yi listede g\u00f6r\u00fcnt\u00fcleyip do\u011frulay\u0131n.<br \/>\n<figure class=\"kb-ekran\"><img decoding=\"async\" src=\"https:\/\/narhost.com\/destek\/wp-content\/uploads\/2026\/09\/mysql-sunucuya-nasil-baglanilir-adim-2.webp\" alt=\"Eri\u015fime izin verilen sunucular listesinde eklenmi\u015f IP adresleri\" width=\"1200\" height=\"572\" loading=\"lazy\"><figcaption>Eklenen IP adresleri bu listede g\u00f6r\u00fcn\u00fcr ve dilendi\u011finde kald\u0131r\u0131labilir.<\/figcaption><\/figure>\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: IP adresi &#8220;Eri\u015fime \u0130zin Verilen Sunucular&#8221; listesinde g\u00f6r\u00fcn\u00fcr.<\/p>\n<\/li>\n<\/ol>\n<h3>Y\u00f6ntem 2 \u2014 ba\u011flant\u0131 bilgilerini toplama ve uygulamada kullanma<\/h3>\n<ol class=\"kb-adimlar\">\n<li><strong>cPanel \u2192 Veritabanlar\u0131 \u2192 Veritabanlar\u0131m\u0131 Y\u00f6net<\/strong> ekran\u0131ndan ba\u011flanaca\u011f\u0131n\u0131z veritaban\u0131n\u0131n tam ad\u0131n\u0131 ve yetkili kullan\u0131c\u0131 ad\u0131n\u0131 not edin; her ikisi de hesap ad\u0131yla birle\u015fik bi\u00e7imdedir.<\/li>\n<li>Uygulaman\u0131z\u0131n veritaban\u0131 ba\u011flant\u0131 ayarlar\u0131na sunucu ad\u0131 olarak hesab\u0131n\u0131z\u0131n bar\u0131nd\u0131\u011f\u0131 sunucu ad\u0131n\u0131, portu <code>3306<\/code>, kullan\u0131c\u0131 ad\u0131 ve \u015fifreyi girin.\n<p class=\"kb-cikti\">Beklenen sonu\u00e7: uygulama &#8220;ba\u011flant\u0131 ba\u015far\u0131l\u0131&#8221; ya da tablolar\u0131 listeleyerek yan\u0131t verir.<\/p>\n<\/li>\n<li>Ba\u011flant\u0131 ilk denemede ba\u015far\u0131s\u0131z olursa \u00f6nce Y\u00f6ntem 1&#8217;deki IP izninin do\u011fru girildi\u011fini, ard\u0131ndan sunucu ad\u0131 ve \u015fifrede yaz\u0131m hatas\u0131 olmad\u0131\u011f\u0131n\u0131 kontrol edin.<\/li>\n<\/ol>\n<h2>Do\u011frulama<\/h2>\n<div class=\"success-box\">\n<p class=\"label\">Sonu\u00e7<\/p>\n<p>Uygulaman\u0131z veritaban\u0131ndaki tablolar\u0131 listeleyebiliyor ya da basit bir sorgu (\u00f6r. tablo say\u0131s\u0131n\u0131 sayma) \u00e7al\u0131\u015ft\u0131rabiliyorsa ba\u011flant\u0131 kurulmu\u015ftur. phpMyAdmin&#8217;den de ayn\u0131 kullan\u0131c\u0131yla giri\u015f deneyip yetkilerin tutarl\u0131 oldu\u011funu g\u00f6rebilirsiniz.<\/p>\n<\/div>\n<h2>H\u00e2l\u00e2 \u00e7\u00f6z\u00fclmediyse<\/h2>\n<ul>\n<li><strong>&#8220;Can&#8217;t connect to MySQL server&#8221; ya da zaman a\u015f\u0131m\u0131 hatas\u0131.<\/strong> IP&#8217;niz Uzak MySQL listesinde de\u011fildir ya da yanl\u0131\u015f girilmi\u015ftir; Y\u00f6ntem 1&#8217;i tekrarlay\u0131p IP&#8217;nizi g\u00fcncel \u015fekilde ekleyin.<\/li>\n<li><strong>&#8220;Access denied for user&#8221; hatas\u0131.<\/strong> Kullan\u0131c\u0131 ad\u0131 veya \u015fifre hatal\u0131d\u0131r; <a href=\"https:\/\/narhost.com\/destek\/phpmyadmine-nasil-giris-yapilir\/\" title=\"phpMyAdmin&#039;e Nas\u0131l Giri\u015f Yap\u0131l\u0131r - Narhost Destek\">phpMyAdmin&#8217;den<\/a> ayn\u0131 bilgilerle giri\u015f deneyip do\u011frulay\u0131n.<\/li>\n<li><strong>WordPress &#8220;veritaban\u0131 ba\u011flant\u0131s\u0131 kurulamad\u0131&#8221; g\u00f6steriyor.<\/strong> Bu genelde site ile ayn\u0131 hesaptaki ba\u011flant\u0131y\u0131 ilgilendirir, uzaktan eri\u015fimden farkl\u0131d\u0131r; <a href=\"https:\/\/narhost.com\/destek\/wordpress-veritabani-baglantisi-nasil-duzeltilir\/\" title=\"WordPress Veritaban\u0131 Ba\u011flant\u0131s\u0131 Nas\u0131l D\u00fczeltilir - Narhost Destek\">WordPress veritaban\u0131 ba\u011flant\u0131s\u0131 kart\u0131na<\/a> bak\u0131n.<\/li>\n<li><strong>B\u00fcy\u00fck bir yede\u011fi i\u00e7eri almam gerekiyor, ba\u011flant\u0131 bunun i\u00e7in yeterli de\u011fil.<\/strong> Uzaktan ba\u011flant\u0131 ile b\u00fcy\u00fck dosya aktar\u0131m\u0131 ayr\u0131 konudur; <a href=\"https:\/\/narhost.com\/destek\/phpmyadmin-ile-buyuk-veritabani-yukleme\/\" title=\"phpMyAdmin ile B\u00fcy\u00fck Veritaban\u0131 Yede\u011fini \u0130\u00e7e Aktarma - Narhost Destek\">b\u00fcy\u00fck veritaban\u0131 i\u00e7e aktarma kart\u0131n\u0131<\/a> izleyin.<\/li>\n<\/ul>\n<div class=\"cta-box\">\n<p class=\"label\">Narhost deste\u011fi<\/p>\n<p>Sorun s\u00fcr\u00fcyorsa destek talebi a\u00e7\u0131n; talebe alan ad\u0131n\u0131z\u0131, ba\u011flanmaya \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131z uygulamay\u0131, cihaz\u0131n\u0131z\u0131n IP adresini ve ald\u0131\u011f\u0131n\u0131z hata metnini birebir ekleyin.<\/p>\n<p><a class=\"cta-btn\" href=\"https:\/\/narhost.com\/submitticket.php\" title=\"Narhost destek talebi a\u00e7\">Destek talebi a\u00e7<\/a><\/div>\n<div class=\"kb-ilgili\">\n<p class=\"label\">Sonraki ad\u0131mlar<\/p>\n<ul>\n<li><a href=\"https:\/\/narhost.com\/destek\/cpanel-kullanim-rehberi\/\" title=\"cPanel Panel \u0130\u015flemleri Rehberi ve Kart Haritas\u0131 - Narhost Destek\">cPanel Panel \u0130\u015flemleri Rehberi<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/destek\/phpmyadmine-nasil-giris-yapilir\/\" title=\"phpMyAdmin&#039;e Nas\u0131l Giri\u015f Yap\u0131l\u0131r - Narhost Destek\">phpMyAdmin&#8217;e nas\u0131l giri\u015f yap\u0131l\u0131r<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/destek\/phpmyadmin-ile-buyuk-veritabani-yukleme\/\" title=\"phpMyAdmin ile B\u00fcy\u00fck Veritaban\u0131 Yede\u011fini \u0130\u00e7e Aktarma - Narhost Destek\">phpMyAdmin ile b\u00fcy\u00fck veritaban\u0131 yede\u011fini i\u00e7e aktarma<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/destek\/sifirdan-cpanel-mysql-veritabani-nasil-kurulur\/\" title=\"S\u0131f\u0131rdan cPanel MySQL Veritaban\u0131 Nas\u0131l Kurulur - Narhost Destek\">S\u0131f\u0131rdan cPanel MySQL veritaban\u0131 nas\u0131l kurulur<\/a><\/li>\n<li><a href=\"https:\/\/narhost.com\/destek\/wordpress-veritabani-baglantisi-nasil-duzeltilir\/\" title=\"WordPress Veritaban\u0131 Ba\u011flant\u0131s\u0131 Nas\u0131l D\u00fczeltilir - Narhost Destek\">WordPress veritaban\u0131 ba\u011flant\u0131s\u0131 nas\u0131l d\u00fczeltilir<\/a><\/li>\n<\/ul>\n<\/div>\n<div class=\"kb-faq\">\n<h2>S\u0131k\u00e7a sorulan sorular<\/h2>\n<h3>Sunucu ad\u0131 olarak localhost m\u00fc yazmal\u0131y\u0131m?<\/h3>\n<p>Hay\u0131r, <code>localhost<\/code> yaln\u0131zca ayn\u0131 hesap i\u00e7indeki uygulamalarda \u00e7al\u0131\u015f\u0131r. D\u0131\u015far\u0131dan ba\u011flan\u0131rken hesab\u0131n\u0131z\u0131n bar\u0131nd\u0131\u011f\u0131 sunucunun ad\u0131n\u0131 yazman\u0131z gerekir.<\/p>\n<h3>IP adresim s\u0131k de\u011fi\u015fiyor, her seferinde eklemek zorunda m\u0131y\u0131m?<\/h3>\n<p>Evet, de\u011fi\u015fken IP&#8217;li ba\u011flant\u0131larda g\u00fcncel IP&#8217;yi Uzak MySQL listesine tekrar eklemeniz gerekir; sabit IP&#8217;niz varsa bu ad\u0131m\u0131 bir kez yapars\u0131n\u0131z.<\/p>\n<h3>Bu pakette SSH ile terminal \u00fczerinden ba\u011flanabilir miyim?<\/h3>\n<p>Payla\u015f\u0131ml\u0131 hostingde SSH eri\u015fimi yoktur; ba\u011flant\u0131 yaln\u0131zca uygulaman\u0131z\u0131n veritaban\u0131 ayarlar\u0131 \u00fczerinden, panelde tan\u0131mlad\u0131\u011f\u0131n\u0131z bilgilerle yap\u0131l\u0131r.<\/p>\n<h3>MySQL&#8217;i neden tercih etmeliyim?<\/h3>\n<p>Bu, panelin \u00f6tesinde bir karard\u0131r; <a href=\"https:\/\/narhost.com\/blog\/mysql-avantajlari-nedir\/\" title=\"MySQL Avantajlar\u0131 Nedir - Narhost Blog\">MySQL&#8217;in avantajlar\u0131 yaz\u0131m\u0131zda<\/a> kar\u015f\u0131la\u015ft\u0131rmal\u0131 olarak anlatt\u0131k.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Payla\u015f\u0131ml\u0131 hostingde uzaktan MySQL ba\u011flant\u0131s\u0131 \u00f6nce cPanel&#8217;in Uzak MySQL ekran\u0131ndan IP izniyle a\u00e7\u0131l\u0131r. Sunucu ad\u0131, kullan\u0131c\u0131 ad\u0131, \u015fifre ve port bilgilerini nereden alaca\u011f\u0131n\u0131z\u0131, s\u0131k g\u00f6r\u00fclen ba\u011flant\u0131 hatalar\u0131n\u0131n nedenini ve \u00e7\u00f6z\u00fcm\u00fcn\u00fc anlat\u0131yoruz.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[137],"class_list":["post-1111","post","type-post","status-publish","format-standard","hentry","category-web-hosting","tag-veritabani"],"meta_box":[],"_links":{"self":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts\/1111","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/comments?post=1111"}],"version-history":[{"count":3,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts\/1111\/revisions"}],"predecessor-version":[{"id":1221,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/posts\/1111\/revisions\/1221"}],"wp:attachment":[{"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/media?parent=1111"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/categories?post=1111"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/narhost.com\/destek\/wp-json\/wp\/v2\/tags?post=1111"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}