{"id":10095,"date":"2024-04-06T13:38:46","date_gmt":"2024-04-06T10:38:46","guid":{"rendered":"https:\/\/sunucun.com.tr\/bilgi\/?post_type=dt_articles&#038;p=10095"},"modified":"2026-02-06T20:41:05","modified_gmt":"2026-02-06T17:41:05","slug":"mysql-veritabani-baglanma","status":"publish","type":"post","link":"https:\/\/sunucun.com.tr\/blog\/mysql-veritabani-baglanma\/","title":{"rendered":"MySQL Veritaban\u0131na Ba\u011flanma: MySQL Workbench, Komut Sat\u0131r\u0131 ve Web Uygulamas\u0131 ile Ba\u011flant\u0131 Kurma"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-veritabani-baglanma\/#1_MySQL_Workbench_ile_Baglanma\" >1. MySQL Workbench ile Ba\u011flanma<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-veritabani-baglanma\/#2_Komut_Satiri_ile_Baglanma\" >2. Komut Sat\u0131r\u0131 ile Ba\u011flanma<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-veritabani-baglanma\/#3_Web_Uygulamasi_ile_Baglanma\" >3. Web Uygulamas\u0131 ile Ba\u011flanma<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-veritabani-baglanma\/#Sonuc\" >Sonu\u00e7<\/a><\/li><\/ul><\/nav><\/div>\n\r\n<p class=\"wp-block-paragraph\">MySQL, d\u00fcnya \u00e7ap\u0131nda milyonlarca kullan\u0131c\u0131 taraf\u0131ndan tercih edilen g\u00fc\u00e7l\u00fc ve esnek bir a\u00e7\u0131k kaynakl\u0131 ili\u015fkisel veritaban\u0131 y\u00f6netim sistemidir. MySQL&#8217;e ba\u011flanmak, veritaban\u0131n\u0131z\u0131 y\u00f6netmek, verileri sorgulamak ve \u00e7e\u015fitli veri i\u015flemleri ger\u00e7ekle\u015ftirmek i\u00e7in en temel ad\u0131md\u0131r. Bu makalede, MySQL veritaban\u0131na ba\u011flanman\u0131n farkl\u0131 y\u00f6ntemlerini, MySQL Workbench, komut sat\u0131r\u0131 ve web uygulamalar\u0131 kullanarak ad\u0131m ad\u0131m inceleyece\u011fiz. Ayr\u0131ca, her y\u00f6ntemin avantajlar\u0131 ve kullan\u0131m senaryolar\u0131n\u0131 da ele alaca\u011f\u0131z.<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_MySQL_Workbench_ile_Baglanma\"><\/span>1. MySQL Workbench ile Ba\u011flanma<span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">MySQL Workbench, MySQL veritabanlar\u0131 ile etkile\u015fim kurmak i\u00e7in kullan\u0131lan, kullan\u0131c\u0131 dostu bir grafik aray\u00fcz sunan pop\u00fcler bir ara\u00e7t\u0131r. Bu ara\u00e7, veritaban\u0131 tasar\u0131m\u0131, y\u00f6netimi ve sorgulama i\u015flemlerini kolayla\u015ft\u0131r\u0131r. \u00d6zellikle SQL komutlar\u0131na a\u015fina olmayan kullan\u0131c\u0131lar i\u00e7in ideal bir \u00e7\u00f6z\u00fcmd\u00fcr, \u00e7\u00fcnk\u00fc grafik aray\u00fcz\u00fc sayesinde karma\u015f\u0131k i\u015flemleri g\u00f6rsel olarak y\u00f6netmeyi sa\u011flar. MySQL Workbench kullanarak MySQL veritaban\u0131na ba\u011flanman\u0131n ad\u0131mlar\u0131 a\u015fa\u011f\u0131da s\u0131ralanm\u0131\u015ft\u0131r:<\/p>\r\n\r\n\r\n\r\n<ol class=\"wp-block-list\">\r\n<li>Bilgisayar\u0131n\u0131zda MySQL Workbench uygulamas\u0131n\u0131 a\u00e7\u0131n.<\/li>\r\n\r\n\r\n\r\n<li>&#8220;Home&#8221; ekran\u0131nda yer alan &#8220;Connections&#8221; b\u00f6l\u00fcm\u00fcne gidin ve &#8220;New Connection&#8221; se\u00e7ene\u011fine t\u0131klay\u0131n.<\/li>\r\n\r\n\r\n\r\n<li>A\u00e7\u0131lan pencerede, ba\u011flanmak istedi\u011finiz veritaban\u0131 sunucusunun host adresi, port numaras\u0131, kullan\u0131c\u0131 ad\u0131 ve \u015fifresi gibi gerekli bilgileri girin.<\/li>\r\n\r\n\r\n\r\n<li>Bilgilerinizi girdikten sonra &#8220;Test Connection&#8221; d\u00fc\u011fmesine t\u0131klayarak ba\u011flant\u0131y\u0131 test edin. Ba\u011flant\u0131 ba\u015far\u0131l\u0131 olursa, &#8220;OK&#8221; d\u00fc\u011fmesine t\u0131klay\u0131n ve ba\u011flant\u0131y\u0131 kaydedin.<\/li>\r\n\r\n\r\n\r\n<li>Kaydedilen ba\u011flant\u0131y\u0131 se\u00e7in ve veritaban\u0131n\u0131za ba\u011flanmak i\u00e7in \u00fczerine t\u0131klay\u0131n.<\/li>\r\n<\/ol>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">MySQL Workbench, veritaban\u0131 \u015femalar\u0131n\u0131 g\u00f6rselle\u015ftirme, sorgular\u0131 kolayca olu\u015fturma ve veritaban\u0131 sunucusu y\u00f6netimi gibi geli\u015fmi\u015f \u00f6zelliklere sahip olmas\u0131 nedeniyle bir\u00e7ok geli\u015ftirici ve veritaban\u0131 y\u00f6neticisi taraf\u0131ndan tercih edilir. \u00d6rne\u011fin, b\u00fcy\u00fck bir veritaban\u0131 \u015femas\u0131n\u0131 anlamak ve d\u00fczenlemek i\u00e7in grafiksel \u015fema d\u00fczenleyicisini kullanabilirsiniz. Ayr\u0131ca, MySQL Workbench, otomatik tamamlama ve hata denetimi gibi kod yazma s\u00fcrecini h\u0131zland\u0131ran \u00f6zelliklere de sahiptir.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.sunucun.com.tr\/blog\/\/wp-content\/uploads\/2024\/04\/indir-1.webp\" alt=\"MySQL Workbench ile Ba\u011flant\u0131 Kurma\" class=\"wp-image-10096\" srcset=\"https:\/\/sunucun.com.tr\/blog\/wp-content\/uploads\/2024\/04\/indir-1.webp 800w, https:\/\/sunucun.com.tr\/blog\/wp-content\/uploads\/2024\/04\/indir-1-300x169.webp 300w, https:\/\/sunucun.com.tr\/blog\/wp-content\/uploads\/2024\/04\/indir-1-768x432.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_Komut_Satiri_ile_Baglanma\"><\/span>2. Komut Sat\u0131r\u0131 ile Ba\u011flanma<span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">MySQL&#8217;e komut sat\u0131r\u0131 kullanarak ba\u011flanmak, \u00f6zellikle h\u0131zl\u0131 ve do\u011frudan i\u015flem yapmay\u0131 tercih eden kullan\u0131c\u0131lar i\u00e7in etkili bir y\u00f6ntemdir. Komut sat\u0131r\u0131 aray\u00fcz\u00fc (CLI), do\u011frudan SQL komutlar\u0131 girerek veritaban\u0131na eri\u015fim sa\u011flar ve bu y\u00f6ntem genellikle script yazma ve otomasyon g\u00f6revleri i\u00e7in kullan\u0131l\u0131r. A\u015fa\u011f\u0131da komut sat\u0131r\u0131 ile MySQL&#8217;e ba\u011flanman\u0131n ad\u0131mlar\u0131 verilmi\u015ftir:<\/p>\r\n\r\n\r\n\r\n<ol class=\"wp-block-list\">\r\n<li>Bilgisayar\u0131n\u0131zda Terminal (macOS veya Linux) veya Komut \u0130stemi (Windows) uygulamas\u0131n\u0131 a\u00e7\u0131n.<\/li>\r\n\r\n\r\n\r\n<li>A\u015fa\u011f\u0131daki komutu kullanarak MySQL&#8217;e ba\u011flan\u0131n:<\/li>\r\n<\/ol>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>mysql -u kullanici_adi -p -h host_adresi\r\n<\/code><\/pre>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Komutu girdikten sonra \u015fifreniz istenecektir. \u015eifrenizi girdikten sonra MySQL veritaban\u0131n\u0131za ba\u015far\u0131yla ba\u011flanacaks\u0131n\u0131z.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Komut sat\u0131r\u0131, SQL komutlar\u0131n\u0131 do\u011frudan girme imkan\u0131 sunar ve bu da veritaban\u0131 y\u00f6netiminde esneklik sa\u011flar. Bu y\u00f6ntem, veritaban\u0131 y\u00f6neticileri i\u00e7in h\u0131zl\u0131 ve script ile y\u00f6netim i\u00e7in ideal bir \u00e7\u00f6z\u00fcmd\u00fcr. Ayr\u0131ca, komut sat\u0131r\u0131 kullanarak veri yedekleme, geri y\u00fckleme, tablo olu\u015fturma ve kullan\u0131c\u0131 y\u00f6netimi gibi bir\u00e7ok y\u00f6netimsel g\u00f6rev kolayca ger\u00e7ekle\u015ftirilebilir.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">\u00d6zellikle, b\u00fcy\u00fck veri k\u00fcmeleri \u00fczerinde \u00e7al\u0131\u015f\u0131rken komut sat\u0131r\u0131n\u0131n sa\u011flad\u0131\u011f\u0131 h\u0131z ve do\u011frudan kontrol avantajlar\u0131, bu y\u00f6ntemi tercih edenler i\u00e7in olduk\u00e7a de\u011ferlidir. \u00d6rne\u011fin, y\u00fcz binlerce sat\u0131r veriyi i\u00e7eren bir tabloyu h\u0131zl\u0131ca sorgulamak veya d\u0131\u015fa aktarmak i\u00e7in komut sat\u0131r\u0131 ara\u00e7lar\u0131 kullan\u0131labilir. Bu y\u00f6ntem, minimum sistem kayna\u011f\u0131 kullanarak etkili veri i\u015flemleri yapman\u0131za olanak tan\u0131r.<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_Web_Uygulamasi_ile_Baglanma\"><\/span>3. Web Uygulamas\u0131 ile Ba\u011flanma<span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">MySQL&#8217;e web uygulamas\u0131 \u00fczerinden ba\u011flanarak, uzaktan eri\u015fim sa\u011flama imkan\u0131 elde edebilirsiniz. Web tabanl\u0131 aray\u00fczler, genellikle taray\u0131c\u0131 \u00fczerinden sunucuya eri\u015fim sa\u011flar ve genellikle phpMyAdmin gibi ara\u00e7lar kullan\u0131larak ger\u00e7ekle\u015ftirilir. Bu y\u00f6ntem, \u00f6zellikle uzaktan y\u00f6netim ve kullan\u0131c\u0131 dostu aray\u00fcz arayanlar i\u00e7in idealdir. Web uygulamalar\u0131 ile ba\u011flanman\u0131n ad\u0131mlar\u0131 uygulaman\u0131n ve sunucunun yap\u0131land\u0131rmas\u0131na ba\u011fl\u0131 olarak de\u011fi\u015fiklik g\u00f6sterebilir. Genel olarak \u015fu ad\u0131mlar izlenir:<\/p>\r\n\r\n\r\n\r\n<ol class=\"wp-block-list\">\r\n<li>Kulland\u0131\u011f\u0131n\u0131z web uygulamas\u0131n\u0131 (\u00f6rne\u011fin, phpMyAdmin) taray\u0131c\u0131da a\u00e7\u0131n.<\/li>\r\n\r\n\r\n\r\n<li>Veritaban\u0131 ba\u011flant\u0131 ayarlar\u0131 b\u00f6l\u00fcm\u00fcne gidin ve gerekli ba\u011flant\u0131 bilgilerini girin (host, kullan\u0131c\u0131 ad\u0131, \u015fifre ve veritaban\u0131 ad\u0131 gibi).<\/li>\r\n\r\n\r\n\r\n<li>Ba\u011flant\u0131 bilgilerini onaylad\u0131ktan sonra, veritaban\u0131n\u0131za web aray\u00fcz\u00fc \u00fczerinden eri\u015febilirsiniz.<\/li>\r\n<\/ol>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Web uygulamalar\u0131, kullan\u0131c\u0131 dostu aray\u00fczleri sayesinde veritaban\u0131 y\u00f6netimini kolayla\u015ft\u0131r\u0131r ve SQL bilgisi az olan kullan\u0131c\u0131lar i\u00e7in idealdir. Ayr\u0131ca, web tabanl\u0131 eri\u015fim, birden fazla kullan\u0131c\u0131 aras\u0131nda i\u015fbirli\u011fi yapmay\u0131 ve veri y\u00f6netimini merkezi bir platform \u00fczerinden ger\u00e7ekle\u015ftirmeyi m\u00fcmk\u00fcn k\u0131lar. \u00d6rne\u011fin, phpMyAdmin gibi pop\u00fcler ara\u00e7lar, kullan\u0131c\u0131lar\u0131n tablolar\u0131 g\u00f6rsel olarak y\u00f6netmesine, sorgular\u0131 kolayca \u00e7al\u0131\u015ft\u0131rmas\u0131na ve veritaban\u0131 yap\u0131s\u0131n\u0131 h\u0131zl\u0131ca de\u011fi\u015ftirmesine olanak tan\u0131r. Bu da \u00f6zellikle \u00e7ok kullan\u0131c\u0131l\u0131 ve dinamik veri tabanlar\u0131 i\u00e7in b\u00fcy\u00fck bir avantajd\u0131r.<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Sonuc\"><\/span>Sonu\u00e7<span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">MySQL veritaban\u0131n\u0131za ba\u011flant\u0131 kurmak, veritaban\u0131 y\u00f6netimi, sorgulama ve veri i\u015flemleri i\u00e7in temel bir beceridir. MySQL Workbench&#8217;in grafik aray\u00fcz\u00fc, komut sat\u0131r\u0131n\u0131n esnekli\u011fi veya web uygulamalar\u0131n\u0131n kullan\u0131m kolayl\u0131\u011f\u0131 gibi \u00e7e\u015fitli y\u00f6ntemlerle MySQL veritaban\u0131n\u0131za ba\u011flanabilirsiniz. Bu y\u00f6ntemlerin her biri, belirli ihtiya\u00e7lar\u0131n\u0131za g\u00f6re en uygun se\u00e7ene\u011fi sunar ve MySQL veritaban\u0131 y\u00f6netiminizi daha verimli hale getirir. \u0130ster grafiksel bir aray\u00fczle, ister h\u0131zl\u0131 ve etkili komut sat\u0131r\u0131 ile, isterseniz de kullan\u0131c\u0131 dostu bir web uygulamas\u0131 \u00fczerinden MySQL veritaban\u0131n\u0131za ba\u011flanarak veri i\u015flemlerinizi kolayca ger\u00e7ekle\u015ftirebilirsiniz.<\/p>\r\n\r\n","protected":false},"excerpt":{"rendered":"<p>MySQL, d\u00fcnya \u00e7ap\u0131nda milyonlarca kullan\u0131c\u0131 taraf\u0131ndan tercih edilen g\u00fc\u00e7l\u00fc ve esnek bir a\u00e7\u0131k kaynakl\u0131 ili\u015fkisel veritaban\u0131 y\u00f6netim sistemidir. MySQL&#8217;e ba\u011flanmak, veritaban\u0131n\u0131z\u0131 y\u00f6netmek, verileri sorgulamak ve \u00e7e\u015fitli veri i\u015flemleri ger\u00e7ekle\u015ftirmek i\u00e7in en temel ad\u0131md\u0131r. Bu makalede, MySQL veritaban\u0131na ba\u011flanman\u0131n farkl\u0131 y\u00f6ntemlerini, MySQL Workbench, komut sat\u0131r\u0131 ve web uygulamalar\u0131 kullanarak ad\u0131m ad\u0131m inceleyece\u011fiz. Ayr\u0131ca, her y\u00f6ntemin avantajlar\u0131&hellip;<\/p>\n","protected":false},"author":1,"featured_media":10097,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[1525,1521],"tags":[],"class_list":["post-10095","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-siber-guvenlik","category-teknoloji"],"_links":{"self":[{"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/posts\/10095","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/comments?post=10095"}],"version-history":[{"count":1,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/posts\/10095\/revisions"}],"predecessor-version":[{"id":16492,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/posts\/10095\/revisions\/16492"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/media\/10097"}],"wp:attachment":[{"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/media?parent=10095"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/categories?post=10095"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/tags?post=10095"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}