{"id":21875,"date":"2026-11-10T14:33:34","date_gmt":"2026-11-10T11:33:34","guid":{"rendered":"https:\/\/sunucun.com.tr\/blog\/phpmyadmin-nedir\/"},"modified":"2026-11-10T14:33:34","modified_gmt":"2026-11-10T11:33:34","slug":"phpmyadmin-nedir","status":"publish","type":"post","link":"https:\/\/sunucun.com.tr\/blog\/phpmyadmin-nedir\/","title":{"rendered":"phpMyAdmin Nedir? localhost\/phpmyadmin Giri\u015f, Veritaban\u0131 Olu\u015fturma ve Yedekleme"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_89 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\/phpmyadmin-nedir\/#phpMyAdmin_ile_Neler_Yapilir\" >phpMyAdmin ile Neler Yap\u0131l\u0131r?<\/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\/phpmyadmin-nedir\/#localhostphpmyadmin_Nasil_Acilir_XAMPP\" >localhost\/phpmyadmin Nas\u0131l A\u00e7\u0131l\u0131r? (XAMPP)<\/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\/phpmyadmin-nedir\/#Hostingte_phpMyAdmine_Giris\" >Hostingte phpMyAdmin&#8217;e Giri\u015f<\/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\/phpmyadmin-nedir\/#phpMyAdminde_Temel_Islemler\" >phpMyAdmin&#8217;de Temel \u0130\u015flemler<\/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\/phpmyadmin-nedir\/#Sik_Gorulen_Hatalar_ve_Cozumleri\" >S\u0131k G\u00f6r\u00fclen Hatalar ve \u00c7\u00f6z\u00fcmleri<\/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\/phpmyadmin-nedir\/#Sik_Sorulan_Sorular\" >S\u0131k 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-7\" href=\"https:\/\/sunucun.com.tr\/blog\/phpmyadmin-nedir\/#phpMyAdmin_ucretli_mi\" >phpMyAdmin \u00fccretli mi?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/sunucun.com.tr\/blog\/phpmyadmin-nedir\/#phpMyAdmin_ile_MySQL_ayni_sey_mi\" >phpMyAdmin ile MySQL ayn\u0131 \u015fey mi?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/sunucun.com.tr\/blog\/phpmyadmin-nedir\/#phpMyAdmin_sifresi_nedir\" >phpMyAdmin \u015fifresi nedir?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n\n<p class=\"wp-block-paragraph\"><strong>phpMyAdmin<\/strong>, <strong>MySQL ve MariaDB veritabanlar\u0131n\u0131 taray\u0131c\u0131 \u00fczerinden y\u00f6netmek i\u00e7in kullan\u0131lan, PHP ile yaz\u0131lm\u0131\u015f \u00fccretsiz bir ara\u00e7t\u0131r<\/strong>. Komut sat\u0131r\u0131 kullanmadan veritaban\u0131 ve tablo olu\u015fturabilir, kay\u0131tlar\u0131 g\u00f6r\u00fcnt\u00fcleyip d\u00fczenleyebilir, SQL sorgusu \u00e7al\u0131\u015ft\u0131rabilir, veritaban\u0131n\u0131 d\u0131\u015fa (export) ve i\u00e7e (import) aktarabilirsiniz. Bilgisayar\u0131n\u0131zda XAMPP gibi bir yerel sunucuyla <code>http:\/\/localhost\/phpmyadmin<\/code> adresinden, hostingte ise cPanel veya Plesk \u00fczerinden a\u00e7\u0131l\u0131r.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"phpMyAdmin_ile_Neler_Yapilir\"><\/span>phpMyAdmin ile Neler Yap\u0131l\u0131r?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Veritaban\u0131, tablo, s\u00fctun ve indeks olu\u015fturma, d\u00fczenleme ve silme<\/li>\n<li>Kay\u0131tlar\u0131 tablo halinde g\u00f6r\u00fcnt\u00fcleme, arama, ekleme ve d\u00fczenleme<\/li>\n<li>SQL sorgular\u0131 \u00e7al\u0131\u015ft\u0131rma (toplu sorgular dahil)<\/li>\n<li>Veritaban\u0131n\u0131 SQL, CSV gibi bi\u00e7imlerde d\u0131\u015fa aktarma ve i\u00e7e aktarma<\/li>\n<li>Veritaban\u0131 kullan\u0131c\u0131lar\u0131 ve yetkileri y\u00f6netme (yetkiniz varsa)<\/li>\n<li>Tablolar aras\u0131ndaki ili\u015fkileri g\u00f6rsel olarak inceleme<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"localhostphpmyadmin_Nasil_Acilir_XAMPP\"><\/span>localhost\/phpmyadmin Nas\u0131l A\u00e7\u0131l\u0131r? (XAMPP)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>XAMPP Kontrol Paneli&#8217;ni a\u00e7\u0131n ve <strong>Apache<\/strong> ile <strong>MySQL<\/strong> mod\u00fcllerini <strong>Start<\/strong> ile ba\u015flat\u0131n; ikisi de ye\u015fil g\u00f6r\u00fcnmelidir.<\/li>\n<li>Taray\u0131c\u0131da <code>http:\/\/localhost\/phpmyadmin<\/code> veya <code>http:\/\/127.0.0.1\/phpmyadmin<\/code> adresini a\u00e7\u0131n.<\/li>\n<li>XAMPP&#8217;\u0131n SSS sayfas\u0131na g\u00f6re MySQL&#8217;in <strong>root<\/strong> kullan\u0131c\u0131s\u0131n\u0131n varsay\u0131lan olarak <strong>\u015fifresi yoktur<\/strong>; giri\u015f ekran\u0131 \u00e7\u0131karsa kullan\u0131c\u0131 ad\u0131na <code>root<\/code> yaz\u0131p \u015fifreyi bo\u015f b\u0131rak\u0131n.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">XAMPP yaln\u0131zca geli\u015ftirme ortam\u0131 i\u00e7indir; XAMPP&#8217;\u0131n kendi belgeleri de canl\u0131 (production) kullan\u0131m i\u00e7in tasarlanmad\u0131\u011f\u0131n\u0131 belirtir. Bilgisayar\u0131n\u0131z\u0131 a\u011fa a\u00e7acaksan\u0131z root kullan\u0131c\u0131s\u0131na \u015fifre koyun. XAMPP hakk\u0131nda ayr\u0131nt\u0131 i\u00e7in <a href=\"https:\/\/sunucun.com.tr\/blog\/xampp-nedir\/\">XAMPP nedir<\/a>, localhost kavram\u0131 i\u00e7in <a href=\"https:\/\/sunucun.com.tr\/blog\/localhost-nedir\/\">localhost nedir<\/a> yaz\u0131lar\u0131m\u0131za bakabilirsiniz.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Hostingte_phpMyAdmine_Giris\"><\/span>Hostingte phpMyAdmin&#8217;e Giri\u015f<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>cPanel:<\/strong> Veritabanlar\u0131 b\u00f6l\u00fcm\u00fcnde <strong>phpMyAdmin<\/strong> simgesine t\u0131klay\u0131n; cPanel oturumunuzla otomatik giri\u015f yap\u0131l\u0131r. Veritaban\u0131 ve kullan\u0131c\u0131y\u0131 \u00f6nce <strong>MySQL Veritabanlar\u0131<\/strong> ekran\u0131ndan olu\u015fturun (bkz. <a href=\"https:\/\/sunucun.com.tr\/blog\/cpanel-veritabani-yonetimi\/\">cPanel veritaban\u0131 y\u00f6netimi<\/a>).<\/li>\n<li><strong>Plesk:<\/strong> Veritabanlar\u0131 &gt; ilgili veritaban\u0131 &gt; <strong>phpMyAdmin<\/strong>.<\/li>\n<li><strong>Kendi <a href=\"https:\/\/sunucun.com.tr\/vps-sunucu\" data-internallinksmanager029f6b8e52c=\"132\" title=\"Sanal sunucu se\u00e7eneklerini inceleyin\">VPS<\/a>\/<a href=\"https:\/\/sunucun.com.tr\/vds-sunucu\" data-internallinksmanager029f6b8e52c=\"133\" title=\"Tahsisli kaynakl\u0131 sanal sunucu \u00e7\u00f6z\u00fcmleri\">VDS<\/a> sunucunuz:<\/strong> phpMyAdmin&#8217;i kurman\u0131z gerekir. Herkese a\u00e7\u0131k b\u0131rakmay\u0131n; IP k\u0131s\u0131tlamas\u0131, ek HTTP kimlik do\u011frulamas\u0131 veya SSH t\u00fcneli kullan\u0131n ve varsay\u0131lan \/phpmyadmin yolunu de\u011fi\u015ftirmeyi d\u00fc\u015f\u00fcn\u00fcn.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"phpMyAdminde_Temel_Islemler\"><\/span>phpMyAdmin&#8217;de Temel \u0130\u015flemler<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<div class=\"snc-table-wrap\"><table>\n<thead><tr><th>\u0130\u015flem<\/th><th>Nas\u0131l yap\u0131l\u0131r?<\/th><\/tr><\/thead>\n<tbody>\n<tr><td><strong>Veritaban\u0131 olu\u015fturma<\/strong><\/td><td>\u00dcstteki <strong>Veritabanlar\u0131<\/strong> sekmesi &gt; ad girin &gt; kar\u015f\u0131la\u015ft\u0131rma (collation) olarak T\u00fcrk\u00e7e karakterler i\u00e7in <code>utf8mb4_unicode_ci<\/code> gibi bir utf8mb4 se\u00e7ene\u011fi &gt; Olu\u015ftur. (Payla\u015f\u0131ml\u0131 hostingte bu i\u015flem genellikle panelden yap\u0131l\u0131r.)<\/td><\/tr>\n<tr><td><strong>Yedek alma (d\u0131\u015fa aktarma)<\/strong><\/td><td>Soldan veritaban\u0131n\u0131 se\u00e7in &gt; <strong>D\u0131\u015fa Aktar<\/strong> &gt; Bi\u00e7im: SQL &gt; Git. \u0130nen .sql dosyas\u0131 yede\u011finizdir.<\/td><\/tr>\n<tr><td><strong>Yedek y\u00fckleme (i\u00e7e aktarma)<\/strong><\/td><td>Bo\u015f veritaban\u0131n\u0131 se\u00e7in &gt; <strong>\u0130\u00e7e Aktar<\/strong> &gt; .sql (veya .sql.zip\/.gz) dosyas\u0131n\u0131 se\u00e7in &gt; Git.<\/td><\/tr>\n<tr><td><strong>SQL \u00e7al\u0131\u015ft\u0131rma<\/strong><\/td><td><strong>SQL<\/strong> sekmesine sorguyu yaz\u0131p Git. DELETE\/UPDATE \u00f6ncesi mutlaka yedek al\u0131n.<\/td><\/tr>\n<tr><td><strong>Tabloyu onarma \/ optimize etme<\/strong><\/td><td>Tablolar\u0131 i\u015faretleyin &gt; alttaki men\u00fcden <strong>Tabloyu onar<\/strong> veya <strong>Tabloyu optimize et<\/strong>.<\/td><\/tr>\n<\/tbody><\/table><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Sik_Gorulen_Hatalar_ve_Cozumleri\"><\/span>S\u0131k G\u00f6r\u00fclen Hatalar ve \u00c7\u00f6z\u00fcmleri<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>&#8220;localhost\/phpmyadmin a\u00e7\u0131lm\u0131yor&#8221; \/ &#8220;Bu siteye ula\u015f\u0131lam\u0131yor&#8221;:<\/strong> Apache \u00e7al\u0131\u015fm\u0131yordur. XAMPP&#8217;ta Apache&#8217;yi ba\u015flat\u0131n; 80 numaral\u0131 portu ba\u015fka bir program (\u00f6r. Skype, IIS) kullan\u0131yorsa Apache portunu de\u011fi\u015ftirin ve adrese portu ekleyin (\u00f6r. <code>localhost:8080\/phpmyadmin<\/code>).<\/li>\n<li><strong>#2002 &#8211; Sunucuya ba\u011flan\u0131lam\u0131yor:<\/strong> MySQL\/MariaDB servisi kapal\u0131d\u0131r; XAMPP&#8217;ta MySQL&#8217;i ba\u015flat\u0131n.<\/li>\n<li><strong>#1045 &#8211; Eri\u015fim engellendi (Access denied):<\/strong> Kullan\u0131c\u0131 ad\u0131 veya \u015fifre yanl\u0131\u015ft\u0131r; root \u015fifresini de\u011fi\u015ftirdiyseniz phpMyAdmin yap\u0131land\u0131rmas\u0131ndaki (config.inc.php) bilgileri de g\u00fcncelleyin.<\/li>\n<li><strong>\u0130\u00e7e aktarmada dosya boyutu s\u0131n\u0131r\u0131:<\/strong> B\u00fcy\u00fck .sql dosyalar\u0131 PHP&#8217;nin upload_max_filesize ve post_max_size s\u0131n\u0131r\u0131na tak\u0131l\u0131r; dosyay\u0131 s\u0131k\u0131\u015ft\u0131r\u0131n, s\u0131n\u0131r\u0131 y\u00fckseltin veya komut sat\u0131r\u0131ndan (<code>mysql -u kullanici -p veritabani &lt; yedek.sql<\/code>) y\u00fckleyin.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">MySQL&#8217;in temelleri i\u00e7in <a href=\"https:\/\/sunucun.com.tr\/blog\/mysql-nedir\/\">MySQL nedir<\/a>, d\u00fczenli yedekleme i\u00e7in <a href=\"https:\/\/sunucun.com.tr\/blog\/veritabani-yedekleme-dump-nasil-alinir-manuel-ve-otomatik-yontemler\/\">veritaban\u0131 yede\u011fi (dump) nas\u0131l al\u0131n\u0131r<\/a> yaz\u0131lar\u0131m\u0131za bakabilirsiniz. phpMyAdmin haz\u0131r gelen bir ortam i\u00e7in <a href=\"https:\/\/sunucun.com.tr\/hosting\/cpanel-hosting\">cPanel hosting<\/a>, tam yetkili veritaban\u0131 sunucusu i\u00e7in <a href=\"https:\/\/sunucun.com.tr\/vds-sunucu\">VDS sunucu<\/a> paketlerimizi inceleyebilirsiniz.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Sik_Sorulan_Sorular\"><\/span>S\u0131k 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=\"phpMyAdmin_ucretli_mi\"><\/span>phpMyAdmin \u00fccretli mi?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Hay\u0131r. phpMyAdmin \u00fccretsiz ve a\u00e7\u0131k kaynakl\u0131 bir yaz\u0131l\u0131md\u0131r; XAMPP, cPanel ve Plesk ile birlikte gelir.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"phpMyAdmin_ile_MySQL_ayni_sey_mi\"><\/span>phpMyAdmin ile MySQL ayn\u0131 \u015fey mi?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Hay\u0131r. MySQL (veya MariaDB) verileri saklayan veritaban\u0131 sunucusudur; phpMyAdmin ise bu sunucuyu taray\u0131c\u0131dan y\u00f6netmenizi sa\u011flayan aray\u00fczd\u00fcr.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"phpMyAdmin_sifresi_nedir\"><\/span>phpMyAdmin \u015fifresi nedir?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">phpMyAdmin&#8217;in kendi \u015fifresi yoktur; MySQL kullan\u0131c\u0131 ad\u0131 ve \u015fifresiyle giri\u015f yap\u0131l\u0131r. XAMPP&#8217;ta varsay\u0131lan kullan\u0131c\u0131 root ve \u015fifre bo\u015ftur; hostingte ise cPanel\/Plesk&#8217;te olu\u015fturdu\u011funuz veritaban\u0131 kullan\u0131c\u0131s\u0131n\u0131n bilgileri ge\u00e7erlidir.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>phpMyAdmin, MySQL ve MariaDB veritabanlar\u0131n\u0131 taray\u0131c\u0131 \u00fczerinden y\u00f6netmek i\u00e7in kullan\u0131lan, PHP ile yaz\u0131lm\u0131\u015f \u00fccretsiz bir ara\u00e7t\u0131r. Komut sat\u0131r\u0131 kullanmadan veritaban\u0131 ve tablo olu\u015fturabilir, kay\u0131tlar\u0131 g\u00f6r\u00fcnt\u00fcleyip d\u00fczenleyebilir, SQL sorgusu \u00e7al\u0131\u015ft\u0131rabilir, veritaban\u0131n\u0131 d\u0131\u015fa (export) ve i\u00e7e (import) aktarabilirsiniz. Bilgisayar\u0131n\u0131zda XAMPP gibi bir yerel sunucuyla http:\/\/localhost\/phpmyadmin adresinden, hostingte ise cPanel veya Plesk \u00fczerinden a\u00e7\u0131l\u0131r. phpMyAdmin ile Neler Yap\u0131l\u0131r?&hellip;<\/p>\n","protected":false},"author":1,"featured_media":21877,"comment_status":"","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[1470],"tags":[],"class_list":["post-21875","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\/21875","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=21875"}],"version-history":[{"count":0,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/posts\/21875\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/media\/21877"}],"wp:attachment":[{"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/media?parent=21875"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/categories?post=21875"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/tags?post=21875"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}