Ubuntu Sunucular\u0131nda phpMyAdmin Kurulumu ve G\u00fcvenli\u011fi: Kapsaml\u0131 Bir Rehber<\/title><br \/>\n<body><\/p>\n<p>Ubuntu sunucular\u0131n\u0131zda veritaban\u0131 y\u00f6netimi karma\u015f\u0131k gelebilir, ancak phpMyAdmin ile bu s\u00fcreci basitle\u015ftirebilirsiniz. Bu rehber, phpMyAdmin’i Ubuntu’ya nas\u0131l kuraca\u011f\u0131n\u0131z\u0131 ve kritik g\u00fcvenlik ad\u0131mlar\u0131yla nas\u0131l koruyaca\u011f\u0131n\u0131z\u0131 ad\u0131m ad\u0131m a\u00e7\u0131kl\u0131yor.<\/p>\n<h2>phpMyAdmin Nedir ve Neden \u00d6nemlidir?<\/h2>\n<p>Veritaban\u0131 y\u00f6netimi, modern web uygulamalar\u0131n\u0131n ve sunucular\u0131n temel ta\u015flar\u0131ndan biridir. Genellikle komut sat\u0131r\u0131 aray\u00fczleri (CLI) arac\u0131l\u0131\u011f\u0131yla yap\u0131lan bu i\u015flemler, \u00f6zellikle SQL bilgisi az olan veya g\u00f6rsel bir aray\u00fcze ihtiya\u00e7 duyan kullan\u0131c\u0131lar i\u00e7in zorlay\u0131c\u0131 olabilir. \u0130\u015fte tam bu noktada phpMyAdmin devreye giriyor. phpMyAdmin, MySQL ve MariaDB veritaban\u0131 sunucular\u0131n\u0131 web tabanl\u0131 bir aray\u00fcz \u00fczerinden y\u00f6netmek i\u00e7in tasarlanm\u0131\u015f \u00fccretsiz ve a\u00e7\u0131k kaynakl\u0131 bir ara\u00e7t\u0131r. PHP ile yaz\u0131lm\u0131\u015ft\u0131r ve d\u00fcnya genelinde milyonlarca kullan\u0131c\u0131 taraf\u0131ndan tercih edilmektedir.<\/p>\n<p>Peki, phpMyAdmin neden bu kadar \u00f6nemli? \u00d6ncelikle, kullan\u0131c\u0131 dostu grafik aray\u00fcz\u00fc sayesinde veritaban\u0131 olu\u015fturma, tablolar\u0131 d\u00fczenleme, veri ekleme, sorgu \u00e7al\u0131\u015ft\u0131rma ve kullan\u0131c\u0131 izinlerini y\u00f6netme gibi bir\u00e7ok i\u015flemi kolayca yapman\u0131z\u0131 sa\u011flar. Karma\u015f\u0131k SQL sorgular\u0131 yazmak yerine, birka\u00e7 t\u0131klamayla istedi\u011finiz sonuca ula\u015fabilirsiniz. Bu, \u00f6zellikle geli\u015ftiriciler, sistem y\u00f6neticileri ve hatta web sitesi sahipleri i\u00e7in zaman tasarrufu anlam\u0131na gelir. \u00d6rne\u011fin, bir e-ticaret sitesinin \u00fcr\u00fcn veritaban\u0131n\u0131 d\u00fc\u015f\u00fcn\u00fcn. Yeni \u00fcr\u00fcnler eklemek, mevcut \u00fcr\u00fcnlerin fiyatlar\u0131n\u0131 g\u00fcncellemek veya stok durumunu kontrol etmek gibi i\u015flemler, phpMyAdmin ile \u00e7ok daha h\u0131zl\u0131 ve hatas\u0131z bir \u015fekilde ger\u00e7ekle\u015ftirilebilir. Ayr\u0131ca, veritaban\u0131 yedeklemesi ve geri y\u00fcklemesi gibi kritik g\u00f6revler de bu aray\u00fcz \u00fczerinden pratik bir \u015fekilde y\u00f6netilebilir. Bu, olas\u0131 veri kay\u0131plar\u0131na kar\u015f\u0131 \u00f6nemli bir g\u00fcvence sa\u011flar.<\/p>\n<p>Ancak, bu kolayl\u0131k beraberinde \u00f6nemli bir sorumluluk da getirir: g\u00fcvenlik. phpMyAdmin, veritabanlar\u0131n\u0131za do\u011frudan eri\u015fim sa\u011flad\u0131\u011f\u0131 i\u00e7in, do\u011fru \u015fekilde yap\u0131land\u0131r\u0131lmad\u0131\u011f\u0131nda ciddi g\u00fcvenlik riskleri olu\u015fturabilir. Yetkisiz eri\u015fim, veri s\u0131z\u0131nt\u0131lar\u0131 veya hatta veritaban\u0131n\u0131z\u0131n tamamen ele ge\u00e7irilmesi gibi sonu\u00e7larla kar\u015f\u0131la\u015fmamak i\u00e7in kurulum ve yap\u0131land\u0131rma a\u015famalar\u0131nda g\u00fcvenlik ad\u0131mlar\u0131na \u00f6zel dikkat g\u00f6stermek zorunludur. Bu rehberin ilerleyen b\u00f6l\u00fcmlerinde, bu g\u00fcvenlik risklerini minimize etmek i\u00e7in atman\u0131z gereken ad\u0131mlar\u0131 detayl\u0131 bir \u015fekilde ele alaca\u011f\u0131z. Veritaban\u0131 y\u00f6netimini basitle\u015ftirirken g\u00fcvenli\u011fi asla ikinci plana atmamal\u0131s\u0131n\u0131z. Bu nedenle, phpMyAdmin’i kurarken ve kullan\u0131rken her zaman en iyi g\u00fcvenlik uygulamalar\u0131n\u0131 takip etmek hayati \u00f6neme sahiptir. Bu arac\u0131n sundu\u011fu g\u00fc\u00e7l\u00fc \u00f6zelliklerden tam anlam\u0131yla faydalanabilmek i\u00e7in hem i\u015flevselli\u011fe hem de g\u00fcvenli\u011fe e\u015fit derecede odaklanmal\u0131y\u0131z.<\/p>\n<h2>Ubuntu’da phpMyAdmin Kurulumu \u0130\u00e7in \u00d6n Haz\u0131rl\u0131klar Nelerdir?<\/h2>\n<p>phpMyAdmin kurulumuna ba\u015flamadan \u00f6nce, Ubuntu sunucunuzun belirli gereksinimleri kar\u015f\u0131lad\u0131\u011f\u0131ndan emin olman\u0131z gerekir. Bu \u00f6n haz\u0131rl\u0131klar, sorunsuz bir kurulum s\u00fcreci ve phpMyAdmin’in stabil \u00e7al\u0131\u015fmas\u0131 i\u00e7in kritik \u00f6neme sahiptir. Temel olarak, bir web sunucusu (Apache veya Nginx), bir veritaban\u0131 sunucusu (MySQL veya MariaDB) ve PHP’nin belirli bir s\u00fcr\u00fcm\u00fcn\u00fcn kurulu olmas\u0131 gerekmektedir. Bu bile\u015fenler genellikle LAMP (Linux, Apache, MySQL, PHP) veya LEMP (Linux, Nginx, MySQL, PHP) y\u0131\u011f\u0131n\u0131 olarak bilinir.<\/p>\n<p>\u0130lk ad\u0131m olarak, sunucunuzdaki paket listelerini g\u00fcncellemek ve mevcut paketleri y\u00fckseltmek her zaman iyi bir uygulamad\u0131r. Bu, en son g\u00fcvenlik yamalar\u0131na ve performans iyile\u015ftirmelerine sahip olman\u0131z\u0131 sa\u011flar. Terminali a\u00e7\u0131n ve a\u015fa\u011f\u0131daki komutlar\u0131 \u00e7al\u0131\u015ft\u0131r\u0131n:<\/p>\n<pre><code>\nsudo apt update\nsudo apt upgrade\n <\/code><\/pre>\n<p>Ard\u0131ndan, bir web sunucusu se\u00e7meniz gerekecek. Apache ve Nginx en pop\u00fcler se\u00e7eneklerdir. Her ikisi de phpMyAdmin ile sorunsuz \u00e7al\u0131\u015f\u0131r, ancak yap\u0131land\u0131rma ad\u0131mlar\u0131 biraz farkl\u0131l\u0131k g\u00f6sterebilir. E\u011fer halihaz\u0131rda bir LAMP veya LEMP y\u0131\u011f\u0131n\u0131 kurmad\u0131ysan\u0131z, \u015fimdi tam zaman\u0131. Apache i\u00e7in a\u015fa\u011f\u0131daki komutlar\u0131 kullanabilirsiniz:<\/p>\n<pre><code>\nsudo apt install apache2 php libapache2-mod-php php-mysql\n <\/code><\/pre>\n<p>E\u011fer Nginx tercih ediyorsan\u0131z, PHP-FPM (FastCGI Process Manager) ile birlikte kurman\u0131z gerekecektir:<\/p>\n<pre><code>\nsudo apt install nginx php-fpm php-mysql\n <\/code><\/pre>\n<p>Web sunucusu kurulumundan sonra, bir veritaban\u0131 sunucusuna ihtiyac\u0131m\u0131z var. MySQL veya MariaDB’yi tercih edebilirsiniz. Ubuntu’da MariaDB varsay\u0131lan olarak gelir ve MySQL ile tam uyumludur. A\u015fa\u011f\u0131daki komutla MariaDB sunucusunu kurabilirsiniz:<\/p>\n<pre><code>\nsudo apt install mariadb-server\n <\/code><\/pre>\n<p>Kurulum tamamland\u0131ktan sonra, MariaDB’yi g\u00fcvence alt\u0131na almak i\u00e7in <code class=\"language-\">mysql_secure_installation<\/code> beti\u011fini \u00e7al\u0131\u015ft\u0131rmak \u00f6nemlidir. Bu betik, root \u015fifresi belirlemenize, anonim kullan\u0131c\u0131lar\u0131 kald\u0131rman\u0131za, uzaktan root giri\u015fini devre d\u0131\u015f\u0131 b\u0131rakman\u0131za ve test veritaban\u0131n\u0131 silmenize yard\u0131mc\u0131 olacakt\u0131r. Bu ad\u0131mlar, veritaban\u0131n\u0131z\u0131n temel g\u00fcvenli\u011fini sa\u011flamak i\u00e7in hayati \u00f6neme sahiptir.<\/p>\n<pre><code>\nsudo mysql_secure_installation\n <\/code><\/pre>\n<p>Son olarak, phpMyAdmin’in d\u00fczg\u00fcn \u00e7al\u0131\u015fabilmesi i\u00e7in baz\u0131 PHP uzant\u0131lar\u0131na ihtiyac\u0131 vard\u0131r. \u00c7o\u011fu zaman <code class=\"language-\">php-mysql<\/code> zaten kurulmu\u015f olacakt\u0131r, ancak di\u011fer gerekli uzant\u0131lar\u0131 da kontrol etmekte fayda var. \u00d6rne\u011fin, <code class=\"language-\">php-json<\/code>, <code class=\"language-\">php-mbstring<\/code>, <code class=\"language-\">php-zip<\/code>, <code class=\"language-\">php-gd<\/code>, <code class=\"language-\">php-curl<\/code> gibi uzant\u0131lar genellikle gereklidir. Bu uzant\u0131lar\u0131 a\u015fa\u011f\u0131daki gibi kurabilirsiniz:<\/p>\n<pre><code>\nsudo apt install php-json php-mbstring php-zip php-gd php-curl php-xml php-bz2 php-intl\n <\/code><\/pre>\n<p>T\u00fcm bu bile\u015fenler kurulduktan ve yap\u0131land\u0131r\u0131ld\u0131ktan sonra, phpMyAdmin’i kurmaya haz\u0131rs\u0131n\u0131z demektir. Bu \u00f6n haz\u0131rl\u0131k ad\u0131mlar\u0131, sadece kurulumun ba\u015far\u0131s\u0131n\u0131 garantilemekle kalmaz, ayn\u0131 zamanda sisteminizin temel g\u00fcvenli\u011fini ve performans\u0131n\u0131 da art\u0131r\u0131r. Bu s\u00fcre\u00e7, bir binan\u0131n sa\u011flam temeller \u00fczerine in\u015fa edilmesi gibidir; ne kadar sa\u011flam olursa, \u00fczerine in\u015fa edece\u011finiz yap\u0131 da o kadar g\u00fcvenli ve dayan\u0131kl\u0131 olur.<\/p>\n<aside class=\"expert-tip\">\n Uzman \u0130pucu: Kurulumdan \u00f6nce bir sanal makinede veya test ortam\u0131nda deneme yapmak, olas\u0131 sorunlar\u0131 canl\u0131 sunucuya yans\u0131tmadan \u00f6nce tespit etmenize yard\u0131mc\u0131 olabilir. Bu sayede \u00fcretim ortam\u0131n\u0131zda daha g\u00fcvenli ve h\u0131zl\u0131 bir ge\u00e7i\u015f sa\u011flayabilirsiniz.<br \/>\n <\/aside>\n<h2>phpMyAdmin Ubuntu Sunucusuna Ad\u0131m Ad\u0131m Nas\u0131l Kurulur?<\/h2>\n<p>\u00d6n haz\u0131rl\u0131klar\u0131m\u0131z\u0131 tamamlad\u0131\u011f\u0131m\u0131za g\u00f6re, art\u0131k phpMyAdmin’i Ubuntu sunucumuza kurmaya ba\u015flayabiliriz. Bu s\u00fcre\u00e7 olduk\u00e7a basittir ve Ubuntu’nun paket y\u00f6neticisi sayesinde kolayca ger\u00e7ekle\u015ftirilebilir. Kurulum s\u0131ras\u0131nda baz\u0131 yap\u0131land\u0131rma sorular\u0131yla kar\u015f\u0131la\u015facaks\u0131n\u0131z, bu y\u00fczden ad\u0131mlar\u0131 dikkatlice takip etmek \u00f6nemlidir.<\/p>\n<p>phpMyAdmin’i kurmak i\u00e7in a\u015fa\u011f\u0131daki komutu kullan\u0131n:<\/p>\n<pre><code>\nsudo apt install phpmyadmin\n <\/code><\/pre>\n<p>Bu komutu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda, sistem size birka\u00e7 soru soracakt\u0131r:<\/p>\n<ol>\n<li><strong>Web sunucusu se\u00e7imi:<\/strong> Kurulum beti\u011fi, phpMyAdmin’i hangi web sunucusu ile otomatik olarak yap\u0131land\u0131raca\u011f\u0131n\u0131 soracakt\u0131r. E\u011fer Apache kullan\u0131yorsan\u0131z, <code class=\"language-\">apache2<\/code> se\u00e7ene\u011fini i\u015faretlemek i\u00e7in bo\u015fluk tu\u015funa bas\u0131n ve ard\u0131ndan Enter tu\u015funa bas\u0131n. E\u011fer Nginx kullan\u0131yorsan\u0131z, bu a\u015famada herhangi bir web sunucusu se\u00e7meyin. Nginx i\u00e7in manuel yap\u0131land\u0131rma yapmam\u0131z gerekecek.<\/li>\n<li><strong>Veritaban\u0131 yap\u0131land\u0131rmas\u0131:<\/strong> phpMyAdmin’in kendi dahili veritaban\u0131n\u0131 kurup kurmayaca\u011f\u0131n\u0131 soracakt\u0131r. Genellikle bu se\u00e7ene\u011fi “Evet” olarak b\u0131rakmak en iyisidir, \u00e7\u00fcnk\u00fc bu veritaban\u0131 phpMyAdmin’in kendisi i\u00e7in baz\u0131 ayarlar\u0131 ve kullan\u0131c\u0131lar\u0131n\u0131 saklar.<\/li>\n<li><strong>MySQL uygulama kullan\u0131c\u0131 \u015fifresi:<\/strong> phpMyAdmin i\u00e7in bir veritaban\u0131 kullan\u0131c\u0131 \u015fifresi belirlemeniz istenecektir. G\u00fc\u00e7l\u00fc bir \u015fifre belirledi\u011finizden emin olun ve bu \u015fifreyi g\u00fcvenli bir yerde saklay\u0131n. Bu, phpMyAdmin’in MySQL sunucusuna ba\u011flanmak i\u00e7in kullanaca\u011f\u0131 \u015fifredir.<\/li>\n<\/ol>\n<p>Kurulum tamamland\u0131ktan sonra, e\u011fer Apache se\u00e7tiyseniz, phpMyAdmin otomatik olarak Apache yap\u0131land\u0131rmas\u0131na dahil edilmi\u015f olmal\u0131d\u0131r. Bunu kontrol etmek i\u00e7in a\u015fa\u011f\u0131daki komutu kullanabilirsiniz:<\/p>\n<pre><code>\nsudo ls \/etc\/apache2\/conf-enabled\/phpmyadmin.conf\n <\/code><\/pre>\n<p>E\u011fer dosya mevcutsa, Apache’nin phpMyAdmin yap\u0131land\u0131rmas\u0131n\u0131 y\u00fckledi\u011fini g\u00f6sterir. De\u011fi\u015fikliklerin etkili olmas\u0131 i\u00e7in Apache’yi yeniden ba\u015flatman\u0131z gerekebilir:<\/p>\n<pre><code>\nsudo systemctl restart apache2\n <\/code><\/pre>\n<h3>Nginx ile phpMyAdmin Kurulumu<\/h3>\n<p>E\u011fer Nginx kullan\u0131yorsan\u0131z, kurulum s\u0131ras\u0131nda web sunucusu se\u00e7ene\u011fini atlam\u0131\u015f olmal\u0131s\u0131n\u0131z. \u015eimdi Nginx i\u00e7in manuel yap\u0131land\u0131rma yapmam\u0131z gerekiyor. \u00d6ncelikle, phpMyAdmin’in Nginx’in eri\u015febilece\u011fi bir dizine sembolik ba\u011flant\u0131s\u0131n\u0131 olu\u015fturmal\u0131y\u0131z. Genellikle <code class=\"language-\">\/usr\/share\/phpmyadmin<\/code> dizinindedir.<\/p>\n<pre><code>\nsudo ln -s \/usr\/share\/phpmyadmin \/var\/www\/html\/phpmyadmin\n <\/code><\/pre>\n<p>Ard\u0131ndan, Nginx sunucu blo\u011funuzda (\u00f6rne\u011fin, <code class=\"language-\">\/etc\/nginx\/sites-available\/default<\/code> veya kendi alan ad\u0131n\u0131z\u0131n yap\u0131land\u0131rma dosyas\u0131) phpMyAdmin i\u00e7in bir konum blo\u011fu eklemeniz gerekecektir. A\u015fa\u011f\u0131daki \u00f6rne\u011fi kendi yap\u0131land\u0131rman\u0131za g\u00f6re uyarlayabilirsiniz:<\/p>\n<pre><code>\nsudo nano \/etc\/nginx\/sites-available\/default\n <\/code><\/pre>\n<p>Dosyan\u0131n i\u00e7ine a\u015fa\u011f\u0131daki blo\u011fu ekleyin (veya mevcut server blo\u011funuzun i\u00e7ine uygun bir yere yerle\u015ftirin):<\/p>\n<pre><code>\nlocation \/phpmyadmin {\n root \/var\/www\/html;\n index index.php index.html index.htm;\n try_files $uri $uri\/ =404;\n\n location ~ ^\/phpmyadmin\/(.+\\.php)$ {\n try_files $uri =404;\n root \/var\/www\/html;\n fastcgi_pass unix:\/var\/run\/php\/php8.1-fpm.sock; # PHP s\u00fcr\u00fcm\u00fcn\u00fcze g\u00f6re g\u00fcncelleyin\n fastcgi_index index.php;\n fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;\n include fastcgi_params;\n }\n\n location ~* ^\/phpmyadmin\/(.+\\.(jpg|jpeg|gif|png|ico|cur|gz|svg|svgz|mp4|ogg|ogv|webm|htc|css|js))$ {\n root \/var\/www\/html;\n expires 1y;\n access_log off;\n add_header Cache-Control \"public\";\n }\n\n location ~ ^\/phpmyadmin\/(setup|config)\\.php {\n deny all;\n }\n}\n <\/code><\/pre>\n<p>PHP-FPM soket yolunun (<code class=\"language-\">fastcgi_pass<\/code>) do\u011fru PHP s\u00fcr\u00fcm\u00fcn\u00fcze i\u015faret etti\u011finden emin olun (\u00f6rne\u011fin, <code class=\"language-\">php8.1-fpm.sock<\/code> yerine <code class=\"language-\">php7.4-fpm.sock<\/code> veya <code class=\"language-\">php8.2-fpm.sock<\/code> olabilir). Yap\u0131land\u0131rmay\u0131 kaydettikten sonra Nginx’i test edin ve yeniden ba\u015flat\u0131n:<\/p>\n<pre><code>\nsudo nginx -t\nsudo systemctl restart nginx php8.1-fpm # PHP s\u00fcr\u00fcm\u00fcn\u00fcze g\u00f6re g\u00fcncelleyin\n <\/code><\/pre>\n<p>Art\u0131k web taray\u0131c\u0131n\u0131z\u0131 a\u00e7\u0131p sunucunuzun IP adresini veya alan ad\u0131n\u0131 takip eden <code class=\"language-\">\/phpmyadmin<\/code> yolunu kullanarak phpMyAdmin’e eri\u015febilirsiniz (\u00f6rne\u011fin, <code class=\"language-\">http:\/\/sunucu_ip_adresiniz\/phpmyadmin<\/code>). Giri\u015f ekran\u0131nda, MySQL root kullan\u0131c\u0131s\u0131 veya phpMyAdmin i\u00e7in \u00f6zel olarak olu\u015fturdu\u011funuz bir kullan\u0131c\u0131 ad\u0131 ve \u015fifresiyle giri\u015f yapabilirsiniz. Bu ad\u0131m, veritaban\u0131 y\u00f6netim panelinize eri\u015fim sa\u011flaman\u0131z i\u00e7in temel bir kap\u0131d\u0131r ve bu kap\u0131n\u0131n g\u00fcvenli\u011fini sa\u011flamak bir sonraki en \u00f6nemli ad\u0131md\u0131r.<\/p>\n<h2>phpMyAdmin G\u00fcvenli\u011fini Sa\u011flamak \u0130\u00e7in Hangi Ad\u0131mlar At\u0131lmal\u0131d\u0131r?<\/h2>\n<p>phpMyAdmin’in kurulumu kolay olsa da, g\u00fcvenlik ad\u0131mlar\u0131 atlanmamal\u0131d\u0131r. Bir veritaban\u0131 y\u00f6netim arac\u0131 olarak, phpMyAdmin potansiyel bir sald\u0131r\u0131 vekt\u00f6r\u00fcd\u00fcr. Bu nedenle, onu m\u00fcmk\u00fcn oldu\u011funca g\u00fcvende tutmak hayati \u00f6neme sahiptir. A\u015fa\u011f\u0131daki ad\u0131mlar, phpMyAdmin kurulumunuzun g\u00fcvenli\u011fini \u00f6nemli \u00f6l\u00e7\u00fcde art\u0131rman\u0131za yard\u0131mc\u0131 olacakt\u0131r.<\/p>\n<h3>1. G\u00fc\u00e7l\u00fc \u015eifreler ve Kullan\u0131c\u0131 \u0130zinleri<\/h3>\n<p>Bu, en temel ve en \u00f6nemli ad\u0131md\u0131r. phpMyAdmin’e giri\u015f yapmak i\u00e7in kulland\u0131\u011f\u0131n\u0131z MySQL root \u015fifresi ve di\u011fer veritaban\u0131 kullan\u0131c\u0131 \u015fifreleri karma\u015f\u0131k, uzun ve tahmin edilmesi zor olmal\u0131d\u0131r. Ayr\u0131ca, phpMyAdmin’e root kullan\u0131c\u0131s\u0131yla giri\u015f yapmaktan ka\u00e7\u0131nmal\u0131s\u0131n\u0131z. Bunun yerine, sadece belirli veritabanlar\u0131na veya tablolara eri\u015fim yetkisi olan ayr\u0131 bir MySQL kullan\u0131c\u0131s\u0131 olu\u015fturun. Bu, bir g\u00fcvenlik ihlali durumunda potansiyel zarar\u0131 s\u0131n\u0131rlar.<\/p>\n<pre><code>\nsudo mysql -u root -p\nCREATE USER 'phpmyadminuser'@'localhost' IDENTIFIED BY 'GucluSifreBuraya!';\nGRANT ALL PRIVILEGES ON veritabani_adi.* TO 'phpmyadminuser'@'localhost';\nFLUSH PRIVILEGES;\nEXIT;\n <\/code><\/pre>\n<p>Yukar\u0131daki \u00f6rnekte, ‘veritabani_adi’ k\u0131sm\u0131n\u0131 y\u00f6netmek istedi\u011finiz veritaban\u0131n\u0131n ad\u0131yla de\u011fi\u015ftirin. E\u011fer t\u00fcm veritabanlar\u0131n\u0131 y\u00f6netmesini istiyorsan\u0131z, <code class=\"language-\">*.*<\/code> kullanabilirsiniz, ancak bu \u00f6nerilmez.<\/p>\n<h3>2. SSL\/TLS (HTTPS) Kullan\u0131m\u0131<\/h3>\n<p>phpMyAdmin’e her zaman HTTPS \u00fczerinden eri\u015fmelisiniz. Bu, sunucunuz ile taray\u0131c\u0131n\u0131z aras\u0131ndaki t\u00fcm ileti\u015fimin \u015fifrelenmesini sa\u011flar ve hassas verilerin (kullan\u0131c\u0131 adlar\u0131, \u015fifreler, veritaban\u0131 i\u00e7eri\u011fi) a\u011fda okunmas\u0131n\u0131 engeller. Let’s Encrypt gibi \u00fccretsiz sertifika sa\u011flay\u0131c\u0131lar\u0131 sayesinde HTTPS kurulumu art\u0131k \u00e7ok kolayd\u0131r. Apache veya Nginx i\u00e7in SSL sertifikas\u0131 kurulumunu tamamlad\u0131\u011f\u0131n\u0131zdan ve phpMyAdmin eri\u015fimini HTTP yerine HTTPS’e y\u00f6nlendirdi\u011finizden emin olun.<\/p>\n<pre><code>\n# Apache i\u00e7in \u00f6rnek .htaccess y\u00f6nlendirmesi\n# \/etc\/phpmyadmin\/apache.conf dosyas\u0131na eklenebilir\n# veya ana site yap\u0131land\u0131rman\u0131za\n<IfModule mod_rewrite.c>\n RewriteEngine On\n RewriteCond %{HTTPS} off\n RewriteRule ^ https:\/\/%{HTTP_HOST}%{REQUEST_URI} [L,R=301]\n<\/IfModule>\n <\/code><\/pre>\n<h3>3. G\u00fcvenlik Duvar\u0131 (UFW) ile Eri\u015fim Kontrol\u00fc<\/h3>\n<p>phpMyAdmin’e eri\u015fimi, sadece belirli IP adresleriyle s\u0131n\u0131rlamak, en etkili g\u00fcvenlik \u00f6nlemlerinden biridir. E\u011fer phpMyAdmin’e sadece belirli bir ofis a\u011f\u0131 veya ev IP adresinden eri\u015fmeniz gerekiyorsa, UFW (Uncomplicated Firewall) kullanarak di\u011fer t\u00fcm IP’lerden gelen ba\u011flant\u0131lar\u0131 engelleyebilirsiniz.<\/p>\n<pre><code>\nsudo ufw enable\nsudo ufw allow ssh # SSH ba\u011flant\u0131s\u0131n\u0131 a\u00e7\u0131k tutmak i\u00e7in\nsudo ufw allow 80\/tcp # HTTP (e\u011fer hala kullan\u0131l\u0131yorsa)\nsudo ufw allow 443\/tcp # HTTPS\nsudo ufw allow from Sizin_IP_Adresiniz to any port 80,443 proto tcp # phpMyAdmin i\u00e7in IP k\u0131s\u0131tlamas\u0131\nsudo ufw reload\n <\/code><\/pre>\n<p>Bu komut, sadece belirtti\u011finiz IP adresinden gelen 80 ve 443 numaral\u0131 portlara eri\u015fime izin verir. Kendi IP adresinizi bilmek i\u00e7in <code class=\"language-\">whatismyip.com<\/code> gibi siteleri kullanabilirsiniz.<\/p>\n<h3>4. phpMyAdmin URL’sini De\u011fi\u015ftirme<\/h3>\n<p>Varsay\u0131lan <code class=\"language-\">\/phpmyadmin<\/code> URL’si, sald\u0131rganlar taraf\u0131ndan bilinen bir hedeftir. Bu URL’yi tahmin edilmesi zor, benzersiz bir isme de\u011fi\u015ftirmek, otomatik bot sald\u0131r\u0131lar\u0131n\u0131n bir\u00e7o\u011funu engellemeye yard\u0131mc\u0131 olabilir. \u00d6rne\u011fin, <code class=\"language-\">\/veritabani_yonetim_paneli<\/code> gibi bir \u015fey kullanabilirsiniz.<\/p>\n<p>Apache i\u00e7in, <code class=\"language-\">\/etc\/phpmyadmin\/apache.conf<\/code> dosyas\u0131n\u0131 d\u00fczenleyin:<\/p>\n<pre><code>\nsudo nano \/etc\/phpmyadmin\/apache.conf\n <\/code><\/pre>\n<p>Alias sat\u0131r\u0131n\u0131 bulun ve de\u011fi\u015ftirin:<\/p>\n<pre><code>\n# Eski: Alias \/phpmyadmin \/usr\/share\/phpmyadmin\nAlias \/benzersiz_url_adresiniz \/usr\/share\/phpmyadmin\n <\/code><\/pre>\n<p>Nginx i\u00e7in, Nginx yap\u0131land\u0131rma dosyan\u0131zdaki <code class=\"language-\">location \/phpmyadmin<\/code> blo\u011funu de\u011fi\u015ftirin:<\/p>\n<pre><code>\n# Eski: location \/phpmyadmin { ... }\nlocation \/benzersiz_url_adresiniz { ... }\n <\/code><\/pre>\n<p>De\u011fi\u015fiklikleri yapt\u0131ktan sonra web sunucunuzu yeniden ba\u015flatmay\u0131 unutmay\u0131n.<\/p>\n<h3>5. Geli\u015fmi\u015f Kimlik Do\u011frulama Mekanizmalar\u0131<\/h3>\n<p>Sunucu d\u00fczeyinde ek bir kimlik do\u011frulama katman\u0131 eklemek, phpMyAdmin’i daha da g\u00fcvence alt\u0131na alabilir. Apache i\u00e7in <code class=\"language-\">.htaccess<\/code> ve <code class=\"language-\">.htpasswd<\/code> kullanarak veya Nginx i\u00e7in benzer bir mekanizma ile ikinci bir \u015fifre istemi olu\u015fturabilirsiniz. Bu, bir sald\u0131rgan ilk \u015fifreyi ge\u00e7se bile ikinci bir engelle kar\u015f\u0131la\u015faca\u011f\u0131 anlam\u0131na gelir.<\/p>\n<p>Apache i\u00e7in, <code class=\"language-\">\/etc\/phpmyadmin\/apache.conf<\/code> dosyas\u0131na a\u015fa\u011f\u0131daki sat\u0131rlar\u0131 ekleyin:<\/p>\n<pre><code>\n<Directory \/usr\/share\/phpmyadmin>\n AuthType Basic\n AuthName \"Restricted Files\"\n AuthUserFile \/etc\/phpmyadmin\/.htpasswd\n Require valid-user\n<\/Directory>\n <\/code><\/pre>\n<p>Ard\u0131ndan <code class=\"language-\">.htpasswd<\/code> dosyas\u0131n\u0131 olu\u015fturun:<\/p>\n<pre><code>\nsudo htpasswd -c \/etc\/phpmyadmin\/.htpasswd kullaniciadi\n <\/code><\/pre>\n<p>Bu komut, <code class=\"language-\">kullaniciadi<\/code> i\u00e7in bir \u015fifre belirlemenizi isteyecektir. Nginx i\u00e7in de benzer bir yap\u0131land\u0131rma m\u00fcmk\u00fcnd\u00fcr.<\/p>\n<h3>6. phpMyAdmin Yap\u0131land\u0131rma Dosyas\u0131 G\u00fcvenli\u011fi (config.inc.php)<\/h3>\n<p>phpMyAdmin’in ana yap\u0131land\u0131rma dosyas\u0131 olan <code class=\"language-\">config.inc.php<\/code>, hassas bilgiler i\u00e7erebilir. Bu dosyan\u0131n izinlerini <code class=\"language-\">644<\/code> olarak ayarlayarak sadece root kullan\u0131c\u0131s\u0131n\u0131n yazma yetkisine sahip olmas\u0131n\u0131 sa\u011flay\u0131n. Ayr\u0131ca, <code class=\"language-\">blowfish_secret<\/code> de\u011ferinin karma\u015f\u0131k ve uzun oldu\u011fundan emin olun. Bu, \u00e7erez tabanl\u0131 kimlik do\u011frulama i\u00e7in kullan\u0131l\u0131r.<\/p>\n<pre><code>\nsudo chmod 644 \/etc\/phpmyadmin\/config.inc.php\nsudo nano \/etc\/phpmyadmin\/config.inc.php\n <\/code><\/pre>\n<p>\u0130\u00e7ine rastgele karakterlerden olu\u015fan uzun bir dize ekleyin:<\/p>\n<pre><code>\n$cfg['blowfish_secret'] = 'Buraya_Cok_Uzun_Ve_Karma\u015f\u0131k_Rastgele_Bir_Dize_Yazin_En_az_32_Karakter';\n <\/code><\/pre>\n<p>Bu g\u00fcvenlik ad\u0131mlar\u0131, phpMyAdmin kurulumunuzu \u00f6nemli \u00f6l\u00e7\u00fcde daha dayan\u0131kl\u0131 hale getirecektir. Unutmay\u0131n, g\u00fcvenlik s\u00fcrekli bir s\u00fcre\u00e7tir ve d\u00fczenli g\u00fcncellemeler ile kontroller bu s\u00fcrecin ayr\u0131lmaz bir par\u00e7as\u0131d\u0131r.<\/p>\n<h2>Geli\u015fmi\u015f G\u00fcvenlik ve Performans \u0130pu\u00e7lar\u0131 Nelerdir?<\/h2>\n<p>phpMyAdmin’in temel kurulumu ve g\u00fcvenlik ad\u0131mlar\u0131 tamamland\u0131ktan sonra, daha deneyimli kullan\u0131c\u0131lar i\u00e7in baz\u0131 geli\u015fmi\u015f ipu\u00e7lar\u0131 ve p\u00fcf noktalar\u0131 bulunmaktad\u0131r. Bu y\u00f6ntemler, hem g\u00fcvenli\u011fi daha da art\u0131racak hem de phpMyAdmin deneyiminizin performans\u0131n\u0131 optimize edecektir.<\/p>\n<h3>1. SSH T\u00fcneli ile phpMyAdmin Eri\u015fimi<\/h3>\n<p>phpMyAdmin’e do\u011frudan web \u00fczerinden eri\u015fmek yerine, SSH t\u00fcneli kullanarak eri\u015fim sa\u011flamak, en g\u00fcvenli y\u00f6ntemlerden biridir. Bu y\u00f6ntem, phpMyAdmin’in yaln\u0131zca yerel makinenizden eri\u015filebilir olmas\u0131n\u0131 sa\u011flar ve t\u00fcm trafi\u011fi \u015fifreli bir SSH t\u00fcneli \u00fczerinden ge\u00e7irir. Bu sayede, g\u00fcvenlik duvar\u0131n\u0131zda 80 veya 443 portunu phpMyAdmin i\u00e7in a\u00e7man\u0131za gerek kalmaz.<\/p>\n<p>\u00d6ncelikle, phpMyAdmin’in yaln\u0131zca <code class=\"language-\">localhost<\/code> \u00fczerinden eri\u015filebilir oldu\u011fundan emin olmal\u0131s\u0131n\u0131z. Apache veya Nginx yap\u0131land\u0131rman\u0131zda, phpMyAdmin’in bulundu\u011fu <code class=\"language-\">location<\/code> veya <code class=\"language-\">Alias<\/code> blo\u011funa a\u015fa\u011f\u0131daki gibi bir <code class=\"language-\">Require local<\/code> veya <code class=\"language-\">deny all<\/code> kural\u0131 ekleyin:<\/p>\n<pre><code>\n# Apache i\u00e7in\n<Directory \/usr\/share\/phpmyadmin>\n Require ip 127.0.0.1\n<\/Directory>\n\n# Nginx i\u00e7in\nlocation \/phpmyadmin {\n allow 127.0.0.1;\n deny all;\n # ... di\u011fer yap\u0131land\u0131rmalar\n}\n <\/code><\/pre>\n<p>Daha sonra, yerel makinenizden sunucunuza bir SSH t\u00fcneli olu\u015fturun:<\/p>\n<pre><code>\nssh -L 8888:127.0.0.1:80 kullanici_adiniz@sunucu_ip_adresi\n <\/code><\/pre>\n<p>Bu komut, yerel makinenizin 8888 portunu, sunucunuzun 80 portuna (veya Nginx kullan\u0131yorsan\u0131z 443) y\u00f6nlendirir. \u015eimdi taray\u0131c\u0131n\u0131zda <code class=\"language-\">http:\/\/127.0.0.1:8888\/phpmyadmin<\/code> adresine giderek phpMyAdmin’e g\u00fcvenli bir \u015fekilde eri\u015febilirsiniz. Unutmay\u0131n, SSH ba\u011flant\u0131s\u0131n\u0131 kapatt\u0131\u011f\u0131n\u0131zda t\u00fcnel de kapanacakt\u0131r.<\/p>\n<h3>2. phpMyAdmin’i Yaln\u0131zca \u0130htiya\u00e7 Duyuldu\u011funda Etkinle\u015ftirme<\/h3>\n<p>E\u011fer phpMyAdmin’i s\u00fcrekli kullanm\u0131yorsan\u0131z, onu devre d\u0131\u015f\u0131 b\u0131rak\u0131p sadece ihtiyac\u0131n\u0131z oldu\u011funda etkinle\u015ftirebilirsiniz. Bu, sald\u0131r\u0131 y\u00fczeyinizi \u00f6nemli \u00f6l\u00e7\u00fcde azalt\u0131r. \u00d6rne\u011fin, Apache i\u00e7in phpMyAdmin yap\u0131land\u0131rma dosyas\u0131n\u0131 devre d\u0131\u015f\u0131 b\u0131rakabilirsiniz:<\/p>\n<pre><code>\nsudo a2disconf phpmyadmin\nsudo systemctl reload apache2\n <\/code><\/pre>\n<p>\u0130htiya\u00e7 duydu\u011funuzda tekrar etkinle\u015ftirmek i\u00e7in:<\/p>\n<pre><code>\nsudo a2enconf phpmyadmin\nsudo systemctl reload apache2\n <\/code><\/pre>\n<p>Nginx i\u00e7in ise, yap\u0131land\u0131rma dosyas\u0131ndaki phpMyAdmin blo\u011funu yorum sat\u0131r\u0131 haline getirebilir veya ayr\u0131 bir dosyadan include ediyorsan\u0131z o include sat\u0131r\u0131n\u0131 kald\u0131rabilirsiniz.<\/p>\n<h3>3. Fail2Ban ile Kaba Kuvvet Sald\u0131r\u0131lar\u0131na Kar\u015f\u0131 Koruma<\/h3>\n<p>Fail2Ban, sunucunuzu kaba kuvvet sald\u0131r\u0131lar\u0131na kar\u015f\u0131 koruyan pop\u00fcler bir ara\u00e7t\u0131r. Yanl\u0131\u015f giri\u015f denemelerini izler ve belirli bir say\u0131da ba\u015far\u0131s\u0131z denemeden sonra sald\u0131rgan\u0131n IP adresini ge\u00e7ici olarak engeller. phpMyAdmin i\u00e7in Fail2Ban’i yap\u0131land\u0131rmak, giri\u015f denemelerini izlemek ve k\u00f6t\u00fc niyetli IP’leri otomatik olarak engellemek i\u00e7in m\u00fckemmel bir yoldur.<\/p>\n<p>Fail2Ban’i kurun:<\/p>\n<pre><code>\nsudo apt install fail2ban\n <\/code><\/pre>\n<p>Ard\u0131ndan, phpMyAdmin i\u00e7in bir jail yap\u0131land\u0131rma dosyas\u0131 olu\u015fturun (\u00f6rne\u011fin, <code class=\"language-\">\/etc\/fail2ban\/jail.d\/phpmyadmin.conf<\/code>):<\/p>\n<pre><code>\nsudo nano \/etc\/fail2ban\/jail.d\/phpmyadmin.conf\n <\/code><\/pre>\n<p>Dosyan\u0131n i\u00e7ine a\u015fa\u011f\u0131daki i\u00e7eri\u011fi ekleyin:<\/p>\n<pre><code>\n[phpmyadmin]\nenabled = true\nport = http,https\nfilter = phpmyadmin\nlogpath = \/var\/log\/auth.log # Apache i\u00e7in \/var\/log\/apache2\/error.log olabilir\nmaxretry = 3\nbantime = 3600\n <\/code><\/pre>\n<p>Ard\u0131ndan, phpMyAdmin i\u00e7in bir filtre dosyas\u0131 olu\u015fturman\u0131z gerekebilir (\u00f6rne\u011fin, <code class=\"language-\">\/etc\/fail2ban\/filter.d\/phpmyadmin.conf<\/code>):<\/p>\n<pre><code>\nsudo nano \/etc\/fail2ban\/filter.d\/phpmyadmin.conf\n <\/code><\/pre>\n<p>\u0130\u00e7eri\u011fi a\u015fa\u011f\u0131daki gibi olabilir:<\/p>\n<pre><code>\n[Definition]\nfailregex = ^%(_su_ip)s -.* \"POST \/phpmyadmin\/index.php HTTP\/.*\" 200 .*$\nignoreregex =\n <\/code><\/pre>\n<p>Logpath ve failregex de\u011ferlerini kendi sunucunuzun log dosyalar\u0131na ve phpMyAdmin’in eri\u015fim yoluna g\u00f6re ayarlaman\u0131z gerekebilir. Son olarak Fail2Ban servisini yeniden ba\u015flat\u0131n:<\/p>\n<pre><code>\nsudo systemctl restart fail2ban\n <\/code><\/pre>\n<h3>4. PHP Yap\u0131land\u0131rma Optimizasyonlar\u0131<\/h3>\n<p>phpMyAdmin PHP ile \u00e7al\u0131\u015ft\u0131\u011f\u0131 i\u00e7in, PHP ayarlar\u0131nda yap\u0131lan baz\u0131 optimizasyonlar performans\u0131 ve g\u00fcvenli\u011fi art\u0131rabilir. \u00d6rne\u011fin, <code class=\"language-\">php.ini<\/code> dosyas\u0131nda <code class=\"language-\">memory_limit<\/code> ve <code class=\"language-\">max_execution_time<\/code> gibi de\u011ferleri, phpMyAdmin’in b\u00fcy\u00fck veritaban\u0131 i\u015flemleri s\u0131ras\u0131nda sorun ya\u015famamas\u0131 i\u00e7in art\u0131rabilirsiniz. G\u00fcvenlik a\u00e7\u0131s\u0131ndan ise, <code class=\"language-\">display_errors = Off<\/code> olarak ayarlamak ve <code class=\"language-\">log_errors = On<\/code> tutmak \u00f6nemlidir. Bu, potansiyel hata mesajlar\u0131n\u0131n web aray\u00fcz\u00fcnde g\u00f6sterilmesini engeller ve sald\u0131rganlara ipucu vermez.<\/p>\n<pre><code>\nsudo nano \/etc\/php\/8.1\/apache2\/php.ini # Apache i\u00e7in\nsudo nano \/etc\/php\/8.1\/fpm\/php.ini # Nginx i\u00e7in\n <\/code><\/pre>\n<p>De\u011fi\u015ftirilecek baz\u0131 de\u011ferler:<\/p>\n<ul>\n<li><code>memory_limit = 256M<\/code> (veya daha y\u00fcksek)<\/li>\n<li><code>max_execution_time = 300<\/code> (veya daha y\u00fcksek)<\/li>\n<li><code>upload_max_filesize = 64M<\/code><\/li>\n<li><code>post_max_size = 64M<\/code><\/li>\n<li><code>display_errors = Off<\/code><\/li>\n<li><code>log_errors = On<\/code><\/li>\n<\/ul>\n<p>De\u011fi\u015fikliklerden sonra PHP servisini yeniden ba\u015flatmay\u0131 unutmay\u0131n (Apache i\u00e7in <code class=\"language-\">sudo systemctl restart apache2<\/code>, Nginx i\u00e7in <code class=\"language-\">sudo systemctl restart php8.1-fpm<\/code>). Bu geli\u015fmi\u015f ipu\u00e7lar\u0131, phpMyAdmin kurulumunuzu daha sa\u011flam, daha g\u00fcvenli ve daha verimli hale getirmenize yard\u0131mc\u0131 olacakt\u0131r. Her zaman oldu\u011fu gibi, herhangi bir b\u00fcy\u00fck de\u011fi\u015fiklik yapmadan \u00f6nce yedekleme almak iyi bir uygulamad\u0131r.<\/p>\n<h2>Vaka Analizi: Bir E-ticaret Sitesinin phpMyAdmin G\u00fcvenli\u011fi Nas\u0131l Sa\u011fland\u0131?<\/h2>\n<p>Bir e-ticaret sitesi olan “H\u0131zl\u0131Sepet”, ba\u015flang\u0131\u00e7ta phpMyAdmin’i varsay\u0131lan ayarlarla kurmu\u015ftu. Site b\u00fcy\u00fcd\u00fck\u00e7e, veritaban\u0131 sald\u0131r\u0131lar\u0131na maruz kalma riskleri de artt\u0131. Bir g\u00fcn, sitenin y\u00f6neticileri, phpMyAdmin giri\u015f sayfas\u0131na s\u00fcrekli olarak kaba kuvvet sald\u0131r\u0131lar\u0131 yap\u0131ld\u0131\u011f\u0131n\u0131 fark ettiler. Bu durum, sunucu loglar\u0131nda a\u015f\u0131r\u0131 say\u0131da hatal\u0131 giri\u015f denemesi olarak kendini g\u00f6steriyordu ve potansiyel bir g\u00fcvenlik ihlalinin habercisiydi.<\/p>\n<p>H\u0131zl\u0131Sepet’in BT ekibi, durumu de\u011ferlendirmek ve acil \u00f6nlemler almak \u00fczere harekete ge\u00e7ti. \u0130lk olarak, mevcut phpMyAdmin kurulumunun g\u00fcvenlik a\u00e7\u0131klar\u0131n\u0131 tespit ettiler:<\/p>\n<ul>\n<li>phpMyAdmin varsay\u0131lan URL’si (<code class=\"language-\">\/phpmyadmin<\/code>) kullan\u0131l\u0131yordu.<\/li>\n<li>HTTPS zorunlu de\u011fildi, bu da giri\u015f bilgilerinin d\u00fcz metin olarak g\u00f6nderilme riskini ta\u015f\u0131yordu.<\/li>\n<li>MySQL root kullan\u0131c\u0131s\u0131 do\u011frudan phpMyAdmin’den eri\u015filebilir durumdayd\u0131 ve zay\u0131f bir \u015fifreye sahipti.<\/li>\n<li>Sunucuda herhangi bir IP k\u0131s\u0131tlamas\u0131 veya kaba kuvvet korumas\u0131 yoktu.<\/li>\n<\/ul>\n<p>Bu zafiyetler \u0131\u015f\u0131\u011f\u0131nda, H\u0131zl\u0131Sepet ekibi kapsaml\u0131 bir g\u00fcvenlik plan\u0131 uygulamaya koydu:<\/p>\n<h3>1. An\u0131nda M\u00fcdahale ve \u0130lk Ad\u0131mlar<\/h3>\n<p>\u00d6ncelikle, MySQL root \u015fifresi hemen g\u00fc\u00e7l\u00fc ve karma\u015f\u0131k bir \u015fifreyle de\u011fi\u015ftirildi. Ard\u0131ndan, phpMyAdmin i\u00e7in ayr\u0131, d\u00fc\u015f\u00fck yetkili bir MySQL kullan\u0131c\u0131s\u0131 olu\u015fturuldu ve root kullan\u0131c\u0131s\u0131n\u0131n phpMyAdmin \u00fczerinden eri\u015fimi engellendi. Bu, olas\u0131 bir sald\u0131rgan\u0131n root ayr\u0131cal\u0131klar\u0131na eri\u015fmesini zorla\u015ft\u0131rd\u0131.<\/p>\n<h3>2. Eri\u015fim URL’sinin De\u011fi\u015ftirilmesi ve HTTPS Zorunlulu\u011fu<\/h3>\n<p>phpMyAdmin’in varsay\u0131lan <code class=\"language-\">\/phpmyadmin<\/code> URL’si, tahmin edilmesi zor, rastgele bir adla (<code class=\"language-\">\/sepet_yonetim_db<\/code>) de\u011fi\u015ftirildi. Bu, otomatik botlar\u0131n ve genel taramalar\u0131n siteyi hedef almas\u0131n\u0131 engelledi. Ayr\u0131ca, t\u00fcm phpMyAdmin trafi\u011finin Let’s Encrypt SSL sertifikas\u0131 kullan\u0131larak HTTPS \u00fczerinden \u015fifrelenmesi zorunlu hale getirildi. Apache yap\u0131land\u0131rmas\u0131na eklenen bir <code class=\"language-\">RewriteRule<\/code> ile t\u00fcm HTTP istekleri HTTPS’e y\u00f6nlendirildi.<\/p>\n<h3>3. G\u00fcvenlik Duvar\u0131 ve IP K\u0131s\u0131tlamalar\u0131<\/h3>\n<p>Sunucunun UFW g\u00fcvenlik duvar\u0131 yap\u0131land\u0131r\u0131ld\u0131. Sadece BT ekibinin ofis IP adreslerinden ve y\u00f6neticilerin ev IP adreslerinden gelen ba\u011flant\u0131lara phpMyAdmin portu (443) \u00fczerinden eri\u015fim izni verildi. Di\u011fer t\u00fcm IP adreslerinden gelen eri\u015fim engellendi. Bu, en etkili ad\u0131mlardan biriydi, \u00e7\u00fcnk\u00fc kaba kuvvet sald\u0131r\u0131lar\u0131n\u0131n b\u00fcy\u00fck bir \u00e7o\u011funlu\u011funu do\u011frudan engelledi.<\/p>\n<pre><code>\nsudo ufw allow from Ofis_IP_Adresi to any port 443 proto tcp\nsudo ufw allow from Yonetici_Ev_IP_Adresi to any port 443 proto tcp\nsudo ufw deny from any to any port 443 proto tcp # Bu kural daha geneldir ve di\u011fer t\u00fcm ba\u011flant\u0131lar\u0131 engeller.\n <\/code><\/pre>\n<h3>4. Fail2Ban Entegrasyonu<\/h3>\n<p>Kaba kuvvet sald\u0131r\u0131lar\u0131na kar\u015f\u0131 ek bir katman olarak Fail2Ban kuruldu ve phpMyAdmin i\u00e7in \u00f6zel bir jail yap\u0131land\u0131r\u0131ld\u0131. Bu, belirli bir s\u00fcre i\u00e7inde ba\u015far\u0131s\u0131z giri\u015f denemesi yapan IP adreslerinin otomatik olarak engellenmesini sa\u011flad\u0131. B\u00f6ylece, manuel m\u00fcdahaleye gerek kalmadan s\u00fcrekli bir koruma sa\u011fland\u0131.<\/p>\n<h3>5. SSH T\u00fcneli Kullan\u0131m\u0131 ve \u0130leri D\u00fczey G\u00fcvenlik<\/h3>\n<p>En kritik veritaban\u0131 i\u015flemlerini yapmak i\u00e7in, H\u0131zl\u0131Sepet’in \u00fcst d\u00fczey y\u00f6neticileri do\u011frudan web aray\u00fcz\u00fc yerine SSH t\u00fcneli \u00fczerinden phpMyAdmin’e eri\u015fmeye ba\u015flad\u0131. Bu, phpMyAdmin’in sadece <code class=\"language-\">localhost<\/code> \u00fczerinden eri\u015filebilir olmas\u0131n\u0131 sa\u011flayarak web tabanl\u0131 sald\u0131r\u0131 riskini s\u0131f\u0131ra indirdi.<\/p>\n<p>Bu kapsaml\u0131 g\u00fcvenlik \u00f6nlemleri sayesinde, H\u0131zl\u0131Sepet’in phpMyAdmin kurulumu \u00e7ok daha g\u00fcvenli hale geldi. Kaba kuvvet sald\u0131r\u0131lar\u0131 durdu, potansiyel veri s\u0131z\u0131nt\u0131s\u0131 riskleri ortadan kalkt\u0131 ve BT ekibi, sitenin veritaban\u0131n\u0131n g\u00fcvende oldu\u011fundan emin olabildi. Bu vaka analizi, phpMyAdmin’in do\u011fru yap\u0131land\u0131r\u0131lmad\u0131\u011f\u0131nda ne kadar savunmas\u0131z olabilece\u011fini ve proaktif g\u00fcvenlik ad\u0131mlar\u0131n\u0131n ne kadar kritik oldu\u011funu a\u00e7\u0131k\u00e7a g\u00f6stermektedir. G\u00fcvenlik, bir \u00fcr\u00fcn veya hizmetin ya\u015fam d\u00f6ng\u00fcs\u00fc boyunca s\u00fcrekli dikkat ve bak\u0131m gerektiren bir s\u00fcre\u00e7tir.<\/p>\n<h2>S\u0131k\u00e7a Sorulan Sorular (SSS)<\/h2>\n<p>phpMyAdmin kurulumu ve g\u00fcvenli\u011fi hakk\u0131nda akl\u0131n\u0131za tak\u0131labilecek baz\u0131 yayg\u0131n sorular\u0131 ve yan\u0131tlar\u0131n\u0131 a\u015fa\u011f\u0131da bulabilirsiniz:<\/p>\n<h3>1. phpMyAdmin’e giri\u015f yaparken neden “Cannot log in to the MySQL server” hatas\u0131 al\u0131yorum?<\/h3>\n<p>Bu hata genellikle yanl\u0131\u015f kullan\u0131c\u0131 ad\u0131 veya \u015fifre girildi\u011finde, MySQL sunucusunun \u00e7al\u0131\u015fm\u0131yor olmas\u0131ndan veya MySQL kullan\u0131c\u0131s\u0131n\u0131n phpMyAdmin’in ba\u011flanmaya \u00e7al\u0131\u015ft\u0131\u011f\u0131 host’tan (\u00f6rne\u011fin, ‘localhost’ yerine ‘%’) eri\u015fim izni olmamas\u0131ndan kaynaklan\u0131r. MySQL sunucusunun durumunu kontrol edin (<code class=\"language-\">sudo systemctl status mysql<\/code> veya <code class=\"language-\">sudo systemctl status mariadb<\/code>). Ayr\u0131ca, MySQL kullan\u0131c\u0131n\u0131z\u0131n \u015fifresinin do\u011fru oldu\u011fundan ve eri\u015fim yetkilerinin tan\u0131mland\u0131\u011f\u0131ndan emin olun.<\/p>\n<h3>2. phpMyAdmin’i kurduktan sonra neden web taray\u0131c\u0131mda 404 Not Found hatas\u0131 al\u0131yorum?<\/h3>\n<p>Bu, genellikle web sunucunuzun phpMyAdmin yap\u0131land\u0131rma dosyas\u0131n\u0131 y\u00fckleyemedi\u011fi veya sembolik ba\u011flant\u0131n\u0131n do\u011fru olu\u015fturulmad\u0131\u011f\u0131 anlam\u0131na gelir. Apache i\u00e7in <code class=\"language-\">\/etc\/apache2\/conf-enabled\/phpmyadmin.conf<\/code> dosyas\u0131n\u0131n mevcut oldu\u011fundan ve Apache’nin yeniden ba\u015flat\u0131ld\u0131\u011f\u0131ndan emin olun. Nginx i\u00e7in ise, Nginx yap\u0131land\u0131rma dosyan\u0131zdaki <code class=\"language-\">location \/phpmyadmin<\/code> blo\u011funun do\u011fru yaz\u0131ld\u0131\u011f\u0131ndan ve PHP-FPM soket yolunun (<code class=\"language-\">fastcgi_pass<\/code>) do\u011fru oldu\u011fundan emin olun. Ayr\u0131ca, <code class=\"language-\">sudo ln -s \/usr\/share\/phpmyadmin \/var\/www\/html\/phpmyadmin<\/code> komutuyla sembolik ba\u011flant\u0131y\u0131 kontrol edin.<\/p>\n<h3>3. phpMyAdmin’i tamamen kald\u0131rmak istersem ne yapmal\u0131y\u0131m?<\/h3>\n<p>phpMyAdmin’i tamamen kald\u0131rmak i\u00e7in a\u015fa\u011f\u0131daki komutlar\u0131 kullanabilirsiniz:<\/p>\n<pre><code>\nsudo apt purge phpmyadmin\nsudo apt autoremove\n <\/code><\/pre>\n<p>E\u011fer Apache kullan\u0131yorsan\u0131z, Apache yap\u0131land\u0131rmas\u0131ndan phpMyAdmin ile ilgili sat\u0131rlar\u0131 kald\u0131r\u0131n. Nginx i\u00e7in de benzer \u015fekilde Nginx yap\u0131land\u0131rma dosyan\u0131zdaki phpMyAdmin blo\u011funu silin. Son olarak, web sunucunuzu yeniden ba\u015flatmay\u0131 unutmay\u0131n.<\/p>\n<h3>4. phpMyAdmin’in “blowfish_secret” ayar\u0131 ne i\u015fe yarar ve neden \u00f6nemlidir?<\/h3>\n<p><code>blowfish_secret<\/code>, phpMyAdmin’in \u00e7erez tabanl\u0131 kimlik do\u011frulama i\u00e7in kulland\u0131\u011f\u0131 \u015fifreleme anahtar\u0131d\u0131r. Bu, phpMyAdmin’e giri\u015f yapt\u0131\u011f\u0131n\u0131zda taray\u0131c\u0131n\u0131zda saklanan oturum \u00e7erezlerini \u015fifrelemek i\u00e7in kullan\u0131l\u0131r. E\u011fer bu anahtar zay\u0131f veya eksikse, oturum \u00e7erezleri ele ge\u00e7irildi\u011finde sald\u0131rganlar veritaban\u0131n\u0131za yetkisiz eri\u015fim sa\u011flayabilir. Bu nedenle, <code>\/etc\/phpmyadmin\/config.inc.php<\/code> dosyas\u0131nda uzun, rastgele ve karma\u015f\u0131k bir dize olarak tan\u0131mlanmas\u0131 hayati \u00f6nem ta\u015f\u0131r.<\/p>\n<h3>5. phpMyAdmin’i g\u00fcncel tutmak neden bu kadar \u00f6nemli?<\/h3>\n<p>phpMyAdmin gibi pop\u00fcler yaz\u0131l\u0131mlar, zaman zaman yeni g\u00fcvenlik a\u00e7\u0131klar\u0131 bar\u0131nd\u0131rabilir. Geli\u015ftiriciler bu a\u00e7\u0131klar\u0131 s\u00fcrekli olarak yamalar ve yeni s\u00fcr\u00fcmler yay\u0131nlar. phpMyAdmin’i g\u00fcncel tutmak, bilinen g\u00fcvenlik a\u00e7\u0131klar\u0131na kar\u015f\u0131 korunman\u0131z\u0131 sa\u011flar, yeni \u00f6zelliklerden faydalanman\u0131z\u0131 ve yaz\u0131l\u0131m\u0131n kararl\u0131 bir \u015fekilde \u00e7al\u0131\u015fmas\u0131n\u0131 garanti eder. D\u00fczenli olarak <code class=\"language-\">sudo apt update && sudo apt upgrade<\/code> komutlar\u0131n\u0131 \u00e7al\u0131\u015ft\u0131rmak, phpMyAdmin dahil t\u00fcm sistem paketlerinizi g\u00fcncel tutmak i\u00e7in en iyi yoldur.<\/p>\n<p>Bu makale, Ubuntu sunucular\u0131nda phpMyAdmin’i g\u00fcvenli bir \u015fekilde kurmak ve y\u00f6netmek i\u00e7in bilmeniz gereken temel ve ileri d\u00fczey bilgileri kapsamaktad\u0131r. Unutmay\u0131n, sunucu g\u00fcvenli\u011fi s\u00fcrekli bir s\u00fcre\u00e7tir ve en iyi uygulamalar\u0131 takip etmek, veritabanlar\u0131n\u0131z\u0131n ve verilerinizin g\u00fcvende kalmas\u0131n\u0131 sa\u011flar.<\/p>\n<p><\/body><\/p>\n","protected":false},"excerpt":{"rendered":"Ubuntu Sunucular\u0131nda phpMyAdmin Kurulumu ve G\u00fcvenli\u011fi: Kapsaml\u0131 Bir Rehber Ubuntu sunucular\u0131n\u0131zda veritaban\u0131 y\u00f6netimi karma\u015f\u0131k gelebilir, ancak phpMyAdmin ile…","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":[133],"tags":[],"class_list":{"0":"post-38033","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-php","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"\n<title>phpMyAdmin Nedir ve Neden \u00d6nemlidir?<\/title>\n<meta name=\"description\" content=\"Ubuntu sunucular\u0131n\u0131zda veritaban\u0131 y\u00f6netimi karma\u015f\u0131k gelebilir, ancak phpMyAdmin ile bu s\u00fcreci basitle\u015ftirebilirsiniz. Bu rehber, phpMyAdmin'i Ubuntu'ya nas\u0131l kuraca\u011f\u0131n\u0131z\u0131 ve kritik g\u00fcvenlik ad\u0131mlar\u0131yla nas\u0131l koruyaca\u011f\u0131n\u0131z\u0131 ad\u0131m ad\u0131m a\u00e7\u0131kl\u0131yor.\" \/>\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\/phpmyadmin-nedir-ve-neden-onemlidir\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"phpMyAdmin Nedir ve Neden \u00d6nemlidir?\" \/>\n<meta property=\"og:description\" content=\"Ubuntu sunucular\u0131n\u0131zda veritaban\u0131 y\u00f6netimi karma\u015f\u0131k gelebilir, ancak phpMyAdmin ile bu s\u00fcreci basitle\u015ftirebilirsiniz. Bu rehber, phpMyAdmin'i Ubuntu'ya nas\u0131l kuraca\u011f\u0131n\u0131z\u0131 ve kritik g\u00fcvenlik ad\u0131mlar\u0131yla nas\u0131l koruyaca\u011f\u0131n\u0131z\u0131 ad\u0131m ad\u0131m a\u00e7\u0131kl\u0131yor.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/phpmyadmin-nedir-ve-neden-onemlidir\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2026-01-21T17:21:02+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=\"24 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/phpmyadmin-nedir-ve-neden-onemlidir\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/phpmyadmin-nedir-ve-neden-onemlidir\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"phpMyAdmin Nedir ve Neden \u00d6nemlidir?\",\"datePublished\":\"2026-01-21T17:21:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/phpmyadmin-nedir-ve-neden-onemlidir\/\"},\"wordCount\":3952,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"articleSection\":[\"PHP\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/phpmyadmin-nedir-ve-neden-onemlidir\/#respond\"]}],\"copyrightYear\":\"2026\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/phpmyadmin-nedir-ve-neden-onemlidir\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/phpmyadmin-nedir-ve-neden-onemlidir\/\",\"name\":\"phpMyAdmin Nedir ve Neden \u00d6nemlidir?\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2026-01-21T17:21:02+00:00\",\"description\":\"Ubuntu sunucular\u0131n\u0131zda veritaban\u0131 y\u00f6netimi karma\u015f\u0131k gelebilir, ancak phpMyAdmin ile bu s\u00fcreci basitle\u015ftirebilirsiniz. Bu rehber, phpMyAdmin'i Ubuntu'ya nas\u0131l kuraca\u011f\u0131n\u0131z\u0131 ve kritik g\u00fcvenlik ad\u0131mlar\u0131yla nas\u0131l koruyaca\u011f\u0131n\u0131z\u0131 ad\u0131m ad\u0131m a\u00e7\u0131kl\u0131yor.\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/phpmyadmin-nedir-ve-neden-onemlidir\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/phpmyadmin-nedir-ve-neden-onemlidir\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/phpmyadmin-nedir-ve-neden-onemlidir\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"phpMyAdmin Nedir ve Neden \u00d6nemlidir?\"}]},{\"@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_head_json":{"title":"phpMyAdmin Nedir ve Neden \u00d6nemlidir?","description":"Ubuntu sunucular\u0131n\u0131zda veritaban\u0131 y\u00f6netimi karma\u015f\u0131k gelebilir, ancak phpMyAdmin ile bu s\u00fcreci basitle\u015ftirebilirsiniz. Bu rehber, phpMyAdmin'i Ubuntu'ya nas\u0131l kuraca\u011f\u0131n\u0131z\u0131 ve kritik g\u00fcvenlik ad\u0131mlar\u0131yla nas\u0131l koruyaca\u011f\u0131n\u0131z\u0131 ad\u0131m ad\u0131m a\u00e7\u0131kl\u0131yor.","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\/phpmyadmin-nedir-ve-neden-onemlidir\/","og_locale":"tr_TR","og_type":"article","og_title":"phpMyAdmin Nedir ve Neden \u00d6nemlidir?","og_description":"Ubuntu sunucular\u0131n\u0131zda veritaban\u0131 y\u00f6netimi karma\u015f\u0131k gelebilir, ancak phpMyAdmin ile bu s\u00fcreci basitle\u015ftirebilirsiniz. Bu rehber, phpMyAdmin'i Ubuntu'ya nas\u0131l kuraca\u011f\u0131n\u0131z\u0131 ve kritik g\u00fcvenlik ad\u0131mlar\u0131yla nas\u0131l koruyaca\u011f\u0131n\u0131z\u0131 ad\u0131m ad\u0131m a\u00e7\u0131kl\u0131yor.","og_url":"https:\/\/fatihsoysal.com\/blog\/phpmyadmin-nedir-ve-neden-onemlidir\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2026-01-21T17:21:02+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"24 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/phpmyadmin-nedir-ve-neden-onemlidir\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/phpmyadmin-nedir-ve-neden-onemlidir\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"phpMyAdmin Nedir ve Neden \u00d6nemlidir?","datePublished":"2026-01-21T17:21:02+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/phpmyadmin-nedir-ve-neden-onemlidir\/"},"wordCount":3952,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"articleSection":["PHP"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/phpmyadmin-nedir-ve-neden-onemlidir\/#respond"]}],"copyrightYear":"2026","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/phpmyadmin-nedir-ve-neden-onemlidir\/","url":"https:\/\/fatihsoysal.com\/blog\/phpmyadmin-nedir-ve-neden-onemlidir\/","name":"phpMyAdmin Nedir ve Neden \u00d6nemlidir?","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2026-01-21T17:21:02+00:00","description":"Ubuntu sunucular\u0131n\u0131zda veritaban\u0131 y\u00f6netimi karma\u015f\u0131k gelebilir, ancak phpMyAdmin ile bu s\u00fcreci basitle\u015ftirebilirsiniz. Bu rehber, phpMyAdmin'i Ubuntu'ya nas\u0131l kuraca\u011f\u0131n\u0131z\u0131 ve kritik g\u00fcvenlik ad\u0131mlar\u0131yla nas\u0131l koruyaca\u011f\u0131n\u0131z\u0131 ad\u0131m ad\u0131m a\u00e7\u0131kl\u0131yor.","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/phpmyadmin-nedir-ve-neden-onemlidir\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/phpmyadmin-nedir-ve-neden-onemlidir\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/phpmyadmin-nedir-ve-neden-onemlidir\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"phpMyAdmin Nedir ve Neden \u00d6nemlidir?"}]},{"@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\/38033","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=38033"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/38033\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=38033"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=38033"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=38033"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

{"id":38033,"date":"2026-01-21T20:21:02","date_gmt":"2026-01-21T17:21:02","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/phpmyadmin-nedir-ve-neden-onemlidir\/"},"modified":"2026-01-21T20:21:02","modified_gmt":"2026-01-21T17:21:02","slug":"phpmyadmin-nedir-ve-neden-onemlidir","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/phpmyadmin-nedir-ve-neden-onemlidir\/","title":{"rendered":"phpMyAdmin Nedir ve Neden \u00d6nemlidir?"},"content":{"rendered":"