{"id":10083,"date":"2024-04-06T12:02:32","date_gmt":"2024-04-06T09:02:32","guid":{"rendered":"https:\/\/sunucun.com.tr\/bilgi\/?post_type=dt_articles&#038;p=10083"},"modified":"2026-11-12T17:22:31","modified_gmt":"2026-11-12T14:22:31","slug":"mysql-workbench-ile-veritabani-olusturma","status":"publish","type":"post","link":"https:\/\/sunucun.com.tr\/blog\/mysql-workbench-ile-veritabani-olusturma\/","title":{"rendered":"MySQL Workbench Nedir, Nas\u0131l Kullan\u0131l\u0131r? Veritaban\u0131 ve Tablo Olu\u015fturma"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_90 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-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-workbench-ile-veritabani-olusturma\/#MySQL_Workbench_Ne_Ise_Yarar\" >MySQL Workbench Ne \u0130\u015fe Yarar?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-workbench-ile-veritabani-olusturma\/#MySQL_Workbench_Nasil_Indirilir_ve_Kurulur\" >MySQL Workbench Nas\u0131l \u0130ndirilir ve Kurulur?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-workbench-ile-veritabani-olusturma\/#Sunucuya_Baglanma\" >Sunucuya Ba\u011flanma<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-workbench-ile-veritabani-olusturma\/#MySQL_Workbench_ile_Veritabani_Olusturma\" >MySQL Workbench ile Veritaban\u0131 Olu\u015fturma<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-workbench-ile-veritabani-olusturma\/#Tablo_Olusturma_ve_Sorgu_Calistirma\" >Tablo Olu\u015fturma ve Sorgu \u00c7al\u0131\u015ft\u0131rma<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-workbench-ile-veritabani-olusturma\/#Komut_Satirindan_Veritabani_Olusturma\" >Komut Sat\u0131r\u0131ndan Veritaban\u0131 Olu\u015fturma<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-workbench-ile-veritabani-olusturma\/#Yedek_Alma_ve_Geri_Yukleme\" >Yedek Alma ve Geri Y\u00fckleme<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-workbench-ile-veritabani-olusturma\/#MySQL_Workbench_mi_phpMyAdmin_mi\" >MySQL Workbench mi, phpMyAdmin mi?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-workbench-ile-veritabani-olusturma\/#Sikca_Sorulan_Sorular\" >S\u0131k\u00e7a Sorulan Sorular<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-workbench-ile-veritabani-olusturma\/#MySQL_Workbench_ucretsiz_mi\" >MySQL Workbench \u00fccretsiz mi?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-workbench-ile-veritabani-olusturma\/#MySQL_Workbench_MariaDB_ile_calisir_mi\" >MySQL Workbench MariaDB ile \u00e7al\u0131\u015f\u0131r m\u0131?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-workbench-ile-veritabani-olusturma\/#%E2%80%9CCannot_connect_to_database_server%E2%80%9D_hatasi_neden_cikar\" >&#8220;Cannot connect to database server&#8221; hatas\u0131 neden \u00e7\u0131kar?<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-workbench-ile-veritabani-olusturma\/#Sonuc\" >Sonu\u00e7<\/a><\/li><\/ul><\/nav><\/div>\n\n<p class=\"wp-block-paragraph\"><strong>K\u0131sa cevap:<\/strong> MySQL Workbench, MySQL veritabanlar\u0131n\u0131 grafik aray\u00fczle y\u00f6netmek i\u00e7in Oracle&#8217;\u0131n geli\u015ftirdi\u011fi resmi masa\u00fcst\u00fc arac\u0131d\u0131r. SQL sorgusu yaz\u0131p \u00e7al\u0131\u015ft\u0131rma, veritaban\u0131 ve tablo olu\u015fturma, \u015fema tasarlama (veri modelleme), kullan\u0131c\u0131 y\u00f6netimi ve yedek alma gibi i\u015fleri tek programda toplar. Community s\u00fcr\u00fcm\u00fc \u00fccretsizdir; Windows, macOS ve Linux&#8217;ta \u00e7al\u0131\u015f\u0131r.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"768\" height=\"422\" class=\"wp-image-10084\" src=\"https:\/\/sunucun.com.tr\/blog\/wp-content\/uploads\/2024\/04\/mysql-nedir.webp\" alt=\"MySQL Workbench ile veritaban\u0131 olu\u015fturma\" srcset=\"https:\/\/sunucun.com.tr\/blog\/wp-content\/uploads\/2024\/04\/mysql-nedir.webp 768w, https:\/\/sunucun.com.tr\/blog\/wp-content\/uploads\/2024\/04\/mysql-nedir-300x165.webp 300w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"MySQL_Workbench_Ne_Ise_Yarar\"><\/span>MySQL Workbench Ne \u0130\u015fe Yarar?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">MySQL&#8217;in resmi belgelerine g\u00f6re Workbench&#8217;in i\u015flevleri be\u015f ana ba\u015fl\u0131kta toplan\u0131r:<\/p>\n\n\n\n<div class=\"snc-table-wrap\"><table>\n<thead><tr><th>Alan<\/th><th>Ne yapar?<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>SQL geli\u015ftirme<\/td><td>Sunucu ba\u011flant\u0131lar\u0131n\u0131 y\u00f6netir; SQL sorgular\u0131n\u0131 yaz\u0131p \u00e7al\u0131\u015ft\u0131r\u0131r, sonu\u00e7lar\u0131 tablo h\u00e2linde g\u00f6sterir ve d\u00fczenletir<\/td><\/tr>\n<tr><td>Veri modelleme<\/td><td>Veritaban\u0131 \u015femas\u0131n\u0131 diyagramla tasarlar; modelden veritaban\u0131 (forward engineering) veya veritaban\u0131ndan model (reverse engineering) \u00fcretir<\/td><\/tr>\n<tr><td><a href=\"https:\/\/sunucun.com.tr\/sunucu-bakimi\" data-internallinksmanager029f6b8e52c=\"138\" title=\"Sunucu bak\u0131m ve y\u00f6netim hizmeti\">Sunucu y\u00f6netimi<\/a><\/td><td>Kullan\u0131c\u0131 ve yetkileri y\u00f6netir, yedek al\u0131r ve geri y\u00fckler, sunucu durumunu ve performans\u0131n\u0131 izler<\/td><\/tr>\n<tr><td>Veri ta\u015f\u0131ma<\/td><td>Microsoft SQL Server, Access, PostgreSQL, SQLite gibi sistemlerden tablo ve verileri MySQL&#8217;e ta\u015f\u0131r<\/td><\/tr>\n<tr><td>Kurumsal \u00f6zellikler<\/td><td>\u00dccretli Commercial s\u00fcr\u00fcmde MySQL Enterprise Backup, Firewall ve Audit deste\u011fi<\/td><\/tr>\n<\/tbody><\/table><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">MySQL ve veritaban\u0131 kavramlar\u0131na yeniyseniz \u00f6nce <a href=\"https:\/\/sunucun.com.tr\/blog\/mysql-nedir\/\">MySQL nedir<\/a> yaz\u0131m\u0131za g\u00f6z atabilirsiniz.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"MySQL_Workbench_Nasil_Indirilir_ve_Kurulur\"><\/span>MySQL Workbench Nas\u0131l \u0130ndirilir ve Kurulur?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Resmi sayfadan indirin:<\/strong> dev.mysql.com\/downloads\/workbench adresinde i\u015fletim sisteminizi se\u00e7in (Windows MSI, macOS, Debian\/Ubuntu ve genel Linux paketleri). Oracle hesab\u0131yla giri\u015f istenirse &#8220;No thanks, just start my download&#8221; ba\u011flant\u0131s\u0131yla hesaps\u0131z indirebilirsiniz.<\/li>\n<li><strong>Windows \u00f6n ko\u015fullar\u0131:<\/strong> \u0130ndirme sayfas\u0131 Windows i\u00e7in Microsoft .NET Framework 4.5 ve Visual C++ Redistributable (Visual Studio 2019 ve sonras\u0131) gerekti\u011fini belirtir; kurulum bunlar\u0131 bulamazsa hata verir.<\/li>\n<li><strong>Kurun:<\/strong> Windows&#8217;ta MSI dosyas\u0131n\u0131 \u00e7al\u0131\u015ft\u0131r\u0131p &#8220;Complete&#8221; kurulumu se\u00e7in; macOS&#8217;ta .dmg dosyas\u0131ndaki uygulamay\u0131 Applications klas\u00f6r\u00fcne s\u00fcr\u00fckleyin; Ubuntu&#8217;da indirdi\u011finiz .deb paketini <code>sudo apt install .\/paket-adi.deb<\/code> ile kurun.<\/li>\n<li><strong>Sunucu ayr\u0131 bir \u015feydir:<\/strong> Workbench yaln\u0131zca istemcidir; ba\u011flanaca\u011f\u0131n\u0131z bir MySQL sunucusu gerekir. Kendi bilgisayar\u0131n\u0131za sunucu kurmak i\u00e7in <a href=\"https:\/\/sunucun.com.tr\/blog\/mysql-kurulumu-windows-macos-ve-linux-icin-kurulum-adimlari\/\">MySQL kurulumu<\/a> rehberimizi izleyin.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Sunucuya_Baglanma\"><\/span>Sunucuya Ba\u011flanma<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Workbench&#8217;i a\u00e7t\u0131\u011f\u0131n\u0131zda ana ekranda &#8220;MySQL Connections&#8221; b\u00f6l\u00fcm\u00fcn\u00fcn yan\u0131ndaki <strong>+<\/strong> simgesine t\u0131klay\u0131n ve ba\u011flant\u0131 bilgilerini girin:<\/p>\n\n\n\n<div class=\"snc-table-wrap\"><table>\n<thead><tr><th>Alan<\/th><th>Yerel MySQL<\/th><th>Uzak sunucu (<a href=\"https:\/\/sunucun.com.tr\/vds-sunucu\" data-internallinksmanager029f6b8e52c=\"133\" title=\"Tahsisli kaynakl\u0131 sanal sunucu \u00e7\u00f6z\u00fcmleri\">VDS<\/a>\/<a href=\"https:\/\/sunucun.com.tr\/vps-sunucu\" data-internallinksmanager029f6b8e52c=\"132\" title=\"Sanal sunucu se\u00e7eneklerini inceleyin\">VPS<\/a>)<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>Connection Method<\/td><td>Standard (TCP\/IP)<\/td><td>Standard TCP\/IP over SSH (\u00f6nerilen)<\/td><\/tr>\n<tr><td>SSH Hostname \/ Username<\/td><td>\u2014<\/td><td>Sunucunun IP adresi:22 ve SSH kullan\u0131c\u0131n\u0131z<\/td><\/tr>\n<tr><td>MySQL Hostname<\/td><td>127.0.0.1<\/td><td>127.0.0.1 (SSH t\u00fcneli i\u00e7inden)<\/td><\/tr>\n<tr><td>Port<\/td><td>3306<\/td><td>3306<\/td><\/tr>\n<tr><td>Username<\/td><td>root veya kendi kullan\u0131c\u0131n\u0131z<\/td><td>Veritaban\u0131 kullan\u0131c\u0131n\u0131z<\/td><\/tr>\n<\/tbody><\/table><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">&#8220;Test Connection&#8221; ile ba\u011flant\u0131y\u0131 deneyip kaydedin. SSH \u00fczerinden ba\u011flanmak, 3306 portunu internete a\u00e7madan g\u00fcvenli ba\u011flant\u0131 kurman\u0131z\u0131 sa\u011flar; MySQL portunu herkese a\u00e7\u0131k b\u0131rakmak kaba kuvvet sald\u0131r\u0131lar\u0131na davetiye \u00e7\u0131kar\u0131r.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"MySQL_Workbench_ile_Veritabani_Olusturma\"><\/span>MySQL Workbench ile Veritaban\u0131 Olu\u015fturma<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Ba\u011flant\u0131y\u0131 a\u00e7\u0131n. Soldaki <strong>Navigator<\/strong> panelinde <strong>Schemas<\/strong> sekmesine ge\u00e7in (MySQL&#8217;de &#8220;schema&#8221; ile &#8220;database&#8221; ayn\u0131 anlamdad\u0131r).<\/li>\n<li>Bo\u015f alana sa\u011f t\u0131klay\u0131p <strong>Create Schema&#8230;<\/strong> se\u00e7in veya ara\u00e7 \u00e7ubu\u011fundaki veritaban\u0131 simgesine t\u0131klay\u0131n.<\/li>\n<li>Veritaban\u0131 ad\u0131n\u0131 yaz\u0131n. Charset\/Collation i\u00e7in T\u00fcrk\u00e7e karakter ve emoji deste\u011fi tam olan <code>utf8mb4<\/code> se\u00e7in (MySQL 8&#8217;de varsay\u0131lan collation <code>utf8mb4_0900_ai_ci<\/code>&#8216;dir).<\/li>\n<li><strong>Apply<\/strong>&#8216;a bas\u0131n. Workbench \u00e7al\u0131\u015ft\u0131raca\u011f\u0131 SQL&#8217;i g\u00f6sterir; tekrar <strong>Apply<\/strong> ve <strong>Finish<\/strong> ile onaylay\u0131n.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Workbench&#8217;in arka planda \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131 komut \u015funa benzer; ayn\u0131s\u0131n\u0131 SQL edit\u00f6r\u00fcnde kendiniz de yazabilirsiniz:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE SCHEMA `magaza` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Tablo_Olusturma_ve_Sorgu_Calistirma\"><\/span>Tablo Olu\u015fturma ve Sorgu \u00c7al\u0131\u015ft\u0131rma<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Navigator&#8217;da veritaban\u0131n\u0131z\u0131 geni\u015fletin, <strong>Tables<\/strong> \u00fczerine sa\u011f t\u0131klay\u0131p <strong>Create Table&#8230;<\/strong> se\u00e7in.<\/li>\n<li>Tablo ad\u0131n\u0131 girin ve s\u00fctunlar\u0131 ekleyin. Kimlik s\u00fctunu i\u00e7in <strong>PK<\/strong> (birincil anahtar), <strong>NN<\/strong> (bo\u015f olamaz) ve <strong>AI<\/strong> (otomatik artan) kutular\u0131n\u0131 i\u015faretleyin.<\/li>\n<li><strong>Apply<\/strong> ile olu\u015fturun. Tabloya sa\u011f t\u0131klay\u0131p <strong>Select Rows<\/strong> se\u00e7erek verileri tablo g\u00f6r\u00fcn\u00fcm\u00fcnde g\u00f6rebilir, do\u011frudan d\u00fczenleyebilirsiniz.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">SQL edit\u00f6r\u00fcyle ayn\u0131 i\u015fi \u015f\u00f6yle yapabilirsiniz. Sorguyu yazd\u0131ktan sonra tamam\u0131n\u0131 \u00e7al\u0131\u015ft\u0131rmak i\u00e7in <strong>Ctrl+Shift+Enter<\/strong>, yaln\u0131zca imlecin bulundu\u011fu ifadeyi \u00e7al\u0131\u015ft\u0131rmak i\u00e7in <strong>Ctrl+Enter<\/strong> kullan\u0131n (macOS&#8217;ta Ctrl yerine Cmd):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>USE magaza;\n\nCREATE TABLE urunler (\n  id INT NOT NULL AUTO_INCREMENT,\n  ad VARCHAR(150) NOT NULL,\n  fiyat DECIMAL(10,2) NOT NULL,\n  eklenme DATETIME DEFAULT CURRENT_TIMESTAMP,\n  PRIMARY KEY (id)\n);\n\nINSERT INTO urunler (ad, fiyat) VALUES ('Klavye', 750.00), ('Fare', 320.50);\n\nSELECT * FROM urunler WHERE fiyat &gt; 500;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Not: Workbench varsay\u0131lan olarak <strong>Safe Updates<\/strong> modunda a\u00e7\u0131l\u0131r; WHERE ko\u015fulunda anahtar s\u00fctun kullanmayan UPDATE ve DELETE sorgular\u0131n\u0131 reddeder. Bu, yanl\u0131\u015fl\u0131kla t\u00fcm tabloyu silmenizi \u00f6nleyen bir korumad\u0131r; ger\u00e7ekten gerekiyorsa Edit &gt; Preferences &gt; SQL Editor alt\u0131ndan kapat\u0131labilir.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Komut_Satirindan_Veritabani_Olusturma\"><\/span>Komut Sat\u0131r\u0131ndan Veritaban\u0131 Olu\u015fturma<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Grafik aray\u00fcz olmayan bir sunucuda ayn\u0131 i\u015flem komut sat\u0131r\u0131ndan yap\u0131l\u0131r:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql -u root -p\nCREATE DATABASE magaza CHARACTER SET utf8mb4;\nSHOW DATABASES;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Yedek_Alma_ve_Geri_Yukleme\"><\/span>Yedek Alma ve Geri Y\u00fckleme<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Yedek:<\/strong> Server &gt; Data Export men\u00fcs\u00fcnde veritaban\u0131n\u0131 se\u00e7in, &#8220;Export to Self-Contained File&#8221; ile tek bir .sql dosyas\u0131na aktar\u0131n. Workbench bu i\u015f i\u00e7in arka planda <code>mysqldump<\/code> kullan\u0131r.<\/li>\n<li><strong>Geri y\u00fckleme:<\/strong> Server &gt; Data Import men\u00fcs\u00fcnde &#8220;Import from Self-Contained File&#8221; ile .sql dosyas\u0131n\u0131 se\u00e7ip hedef veritaban\u0131n\u0131 belirtin.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"MySQL_Workbench_mi_phpMyAdmin_mi\"><\/span>MySQL Workbench mi, phpMyAdmin mi?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<div class=\"snc-table-wrap\"><table>\n<thead><tr><th><\/th><th>MySQL Workbench<\/th><th>phpMyAdmin<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>\u00c7al\u0131\u015ft\u0131\u011f\u0131 yer<\/td><td>Bilgisayar\u0131n\u0131za kurulan masa\u00fcst\u00fc uygulamas\u0131<\/td><td>Sunucuda \u00e7al\u0131\u015fan web aray\u00fcz\u00fc (taray\u0131c\u0131dan)<\/td><\/tr>\n<tr><td>G\u00fc\u00e7l\u00fc yan\u0131<\/td><td>Veri modelleme, geli\u015fmi\u015f SQL edit\u00f6r\u00fc, performans izleme<\/td><td>Kurulum gerektirmez; <a href=\"https:\/\/sunucun.com.tr\/hosting\/\" data-internallinksmanager029f6b8e52c=\"126\" title=\"Web bar\u0131nd\u0131rma paketlerini inceleyin\">hosting<\/a> panellerinde (cPanel, Plesk) haz\u0131r gelir<\/td><\/tr>\n<tr><td>Uzak ba\u011flant\u0131<\/td><td>SSH t\u00fcneliyle do\u011frudan<\/td><td>Panel veya web \u00fczerinden<\/td><\/tr>\n<tr><td>Uygun oldu\u011fu ki\u015fi<\/td><td>Geli\u015ftirici ve veritaban\u0131 y\u00f6neticisi<\/td><td>Payla\u015f\u0131ml\u0131 hosting kullan\u0131c\u0131s\u0131<\/td><\/tr>\n<\/tbody><\/table><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Sikca_Sorulan_Sorular\"><\/span>S\u0131k\u00e7a Sorulan Sorular<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"MySQL_Workbench_ucretsiz_mi\"><\/span>MySQL Workbench \u00fccretsiz mi?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Evet, Community s\u00fcr\u00fcm\u00fc \u00fccretsizdir. Commercial s\u00fcr\u00fcm, MySQL Enterprise \u00fcr\u00fcnleri i\u00e7in ek \u00f6zellikler i\u00e7erir.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"MySQL_Workbench_MariaDB_ile_calisir_mi\"><\/span>MySQL Workbench MariaDB ile \u00e7al\u0131\u015f\u0131r m\u0131?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Temel i\u015flemler (ba\u011flanma, sorgu \u00e7al\u0131\u015ft\u0131rma, tablo d\u00fczenleme) genellikle \u00e7al\u0131\u015f\u0131r; ancak Workbench MySQL i\u00e7in geli\u015ftirildi\u011finden baz\u0131 y\u00f6netim ekranlar\u0131nda uyumsuzluk uyar\u0131s\u0131 alabilirsiniz.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E2%80%9CCannot_connect_to_database_server%E2%80%9D_hatasi_neden_cikar\"><\/span>&#8220;Cannot connect to database server&#8221; hatas\u0131 neden \u00e7\u0131kar?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">En s\u0131k nedenler: MySQL servisinin \u00e7al\u0131\u015fmamas\u0131, yanl\u0131\u015f port veya \u015fifre, g\u00fcvenlik duvar\u0131n\u0131n 3306&#8217;y\u0131 engellemesi ve kullan\u0131c\u0131n\u0131n yaln\u0131zca localhost&#8217;tan ba\u011flanma yetkisi olmas\u0131. Uzak sunucuda SSH t\u00fcneliyle ba\u011flanmak son iki sorunu ortadan kald\u0131r\u0131r.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Sonuc\"><\/span>Sonu\u00e7<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">MySQL Workbench, veritaban\u0131 olu\u015fturmaktan \u015fema tasar\u0131m\u0131na ve yedeklemeye kadar MySQL i\u015flerini tek aray\u00fczde toplayan \u00fccretsiz bir ara\u00e7t\u0131r. Uygulaman\u0131z\u0131n veritaban\u0131n\u0131 kendi sunucunuzda \u00e7al\u0131\u015ft\u0131rmak istiyorsan\u0131z <a href=\"https:\/\/sunucun.com.tr\/vds-sunucu\">VDS sunucu<\/a> \u00fczerinde MySQL kurup Workbench ile SSH t\u00fcneli \u00fczerinden g\u00fcvenle y\u00f6netebilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>K\u0131sa cevap: MySQL Workbench, MySQL veritabanlar\u0131n\u0131 grafik aray\u00fczle y\u00f6netmek i\u00e7in Oracle&#8217;\u0131n geli\u015ftirdi\u011fi resmi masa\u00fcst\u00fc arac\u0131d\u0131r. SQL sorgusu yaz\u0131p \u00e7al\u0131\u015ft\u0131rma, veritaban\u0131 ve tablo olu\u015fturma, \u015fema tasarlama (veri modelleme), kullan\u0131c\u0131 y\u00f6netimi ve yedek alma gibi i\u015fleri tek programda toplar. Community s\u00fcr\u00fcm\u00fc \u00fccretsizdir; Windows, macOS ve Linux&#8217;ta \u00e7al\u0131\u015f\u0131r. MySQL Workbench Ne \u0130\u015fe Yarar? MySQL&#8217;in resmi belgelerine g\u00f6re Workbench&#8217;in&hellip;<\/p>\n","protected":false},"author":1,"featured_media":10085,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[1470],"tags":[],"class_list":["post-10083","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/posts\/10083","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=10083"}],"version-history":[{"count":1,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/posts\/10083\/revisions"}],"predecessor-version":[{"id":16496,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/posts\/10083\/revisions\/16496"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/media\/10085"}],"wp:attachment":[{"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/media?parent=10083"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/categories?post=10083"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/tags?post=10083"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}