{"id":11228,"date":"2024-10-26T12:33:50","date_gmt":"2024-10-26T09:33:50","guid":{"rendered":"https:\/\/www.inetmar.com\/blog\/?p=11228"},"modified":"2024-10-26T12:33:50","modified_gmt":"2024-10-26T09:33:50","slug":"mysql-portu-nasil-erisime-kapatilir","status":"publish","type":"post","link":"https:\/\/www.inetmar.com\/blog\/mysql-portu-nasil-erisime-kapatilir\/","title":{"rendered":"MySQL Portu Nas\u0131l Eri\u015fime Kapat\u0131l\u0131r?"},"content":{"rendered":"

MySQL portu default olarak 3306 portunu kullan\u0131r. Bu port sunucunun d\u0131\u015far\u0131dan eri\u015filebilir olmas\u0131n\u0131 sa\u011flar ancak internet \u00fczerinden eri\u015fime a\u00e7\u0131k bir veritaban\u0131 kullan\u0131yorsan\u0131z sald\u0131r\u0131lara kar\u015f\u0131 daha savunmas\u0131z olursunuz. Bu t\u00fcr sald\u0131r\u0131lardan korunmak i\u00e7in MySQL’i d\u0131\u015far\u0131ya kapatarak yaln\u0131zca belirli IP’ler veya yerel a\u011fda kullan\u0131lacak \u015fekilde s\u0131n\u0131rland\u0131rabilirsiniz. MySQL portunu d\u0131\u015far\u0131dan eri\u015fime kapatma i\u015flemi i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 takip edebilirsiniz.<\/p>\n

\"sql<\/p>\n

MySQL Yap\u0131land\u0131rma Dosyas\u0131 ile Portu Kapatma<\/h2>\n

MySQL yap\u0131land\u0131rma dosyas\u0131n\u0131 a\u015fa\u011f\u0131daki komut ile a\u00e7\u0131n.
\nnano \/etc\/mysql\/my.cnf<\/code><\/p>\n

Ard\u0131ndan yap\u0131land\u0131rma dosyas\u0131nda bind-address<\/code> sat\u0131r\u0131n\u0131 bulun. Bu sat\u0131r\u0131 127.0.0.1<\/code> olarak ayarlay\u0131n bu \u015fekilde MySQL’in sadece local ba\u011flant\u0131lar\u0131 kabul edecektir.
\n\u00d6rnek:\u00a0<\/strong>bind-address = 127.0.0.1<\/code><\/p>\n

De\u011fi\u015fikleri kaydettikten sonra ge\u00e7erli olmas\u0131 i\u00e7in systemctl restart mysql<\/code> komutu ile MySQL servisini restart edin.<\/p>\n

Firewall ile MySQL Portunu Kapatma<\/h2>\n

Sunucunuzda firewall aktif ise a\u015fa\u011f\u0131daki komutu uygulayarak ta MySQL portunu kapatabilirsiniz.<\/p>\n

ufw deny 3306<\/code><\/p>\n

iptables kullan\u0131yorsan\u0131z:<\/p>\n

iptables -A INPUT -p tcp --dport 3306 -j DROP<\/code><\/p>\n

Default olan 3306 portunu kullanm\u0131yorsan\u0131z 3306 yerine kulland\u0131\u011f\u0131n\u0131z portu yazabilirsiniz.<\/p>\n

MySQL veritabanlar\u0131n\u0131z i\u00e7in y\u00fcksek performansl\u0131 ve g\u00fcvenli VDS sunucu<\/a> \u00e7\u00f6z\u00fcmlerimizle tan\u0131\u015f\u0131n!<\/p>\n","protected":false},"excerpt":{"rendered":"

MySQL portu default olarak 3306 portunu kullan\u0131r. Bu port sunucunun d\u0131\u015far\u0131dan eri\u015filebilir olmas\u0131n\u0131 sa\u011flar ancak internet \u00fczerinden eri\u015fime a\u00e7\u0131k bir veritaban\u0131 kullan\u0131yorsan\u0131z sald\u0131r\u0131lara kar\u015f\u0131 daha savunmas\u0131z olursunuz. Bu t\u00fcr sald\u0131r\u0131lardan korunmak i\u00e7in MySQL’i d\u0131\u015far\u0131ya kapatarak...<\/p>\n","protected":false},"author":2,"featured_media":11233,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54],"tags":[],"class_list":["post-11228","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysqlserver"],"_links":{"self":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/11228","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/comments?post=11228"}],"version-history":[{"count":16,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/11228\/revisions"}],"predecessor-version":[{"id":11247,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/11228\/revisions\/11247"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media\/11233"}],"wp:attachment":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media?parent=11228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/categories?post=11228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/tags?post=11228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}