{"id":10186,"date":"2024-08-20T14:20:29","date_gmt":"2024-08-20T11:20:29","guid":{"rendered":"https:\/\/www.inetmar.com\/blog\/?p=10186"},"modified":"2024-08-20T14:22:37","modified_gmt":"2024-08-20T11:22:37","slug":"mysql-uzaktan-erisime-acmak-linux","status":"publish","type":"post","link":"https:\/\/www.inetmar.com\/blog\/mysql-uzaktan-erisime-acmak-linux\/","title":{"rendered":"MySQL Uzaktan Eri\u015fime A\u00e7mak (Linux)"},"content":{"rendered":"

MySQL veritaban\u0131 web uygulamalar\u0131n\u0131n bel kemi\u011fidir ve g\u00fcvenlik nedeniyle sadece yerel ba\u011flant\u0131lara izin verecek \u015fekilde yap\u0131land\u0131r\u0131l\u0131r. Ancak baz\u0131 durumlarda veritaban\u0131na uzaktan eri\u015fim gerekebilir. Sizlerde linux tabanl\u0131 bir sunucuya sahipseniz ve MySQL server i uzaktan eri\u015fime a\u00e7mak istiyorsan\u0131z a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 takip edebilirsiniz.<\/p>\n

\"\"<\/p>\n

Websiten i\u00e7in limitsiz hosting sat\u0131n al<\/a>.<\/p>\n

Linux Sunucu \u00dczerinde MySQL Uzaktan Eri\u015fime A\u00e7mak<\/h2>\n

Sunucunuza root olarak SSH ba\u011flant\u0131s\u0131 yap\u0131n ard\u0131ndan
\nnano \/etc\/mysql\/mysql.conf.d\/mysqld.cnf<\/code> komutuyla MySQL konfig\u00fcrasyon dosyan\u0131n a\u00e7\u0131p bind-address<\/strong> sat\u0131r\u0131n\u0131 bulun. Bu sat\u0131rda yazan 127.0.0.1 ip adresi default gelir ve sadece local ba\u011flant\u0131lara izin verir. Bu sat\u0131rdaki ip adresini 0.0.0.0<\/strong> \u015feklinde de\u011fi\u015ftirerek MySQLsunucunuzu t\u00fcm IP adreslerinden gelen ba\u011flant\u0131lara a\u00e7\u0131k hale getirebilirsiniz.<\/p>\n

De\u011fi\u015fiklik i\u015flemini tamamlad\u0131ktan sonra systemctl restart mysql<\/strong> komutuyla MySQL sunucusunu restart edip uzaktan eri\u015fiminizi tekrardan deneyebilirsiniz.<\/p>\n

Bu i\u015flemlerden sonra hala uzaktan eri\u015fim sa\u011flayam\u0131yorsan\u0131z muhtemelen network taraf\u0131ndan konulan ekstra bir k\u0131s\u0131tlama mevcuttur bu durumda size hizmet sa\u011flayan firmayla ileti\u015fime ge\u00e7ebilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"

MySQL veritaban\u0131 web uygulamalar\u0131n\u0131n bel kemi\u011fidir ve g\u00fcvenlik nedeniyle sadece yerel ba\u011flant\u0131lara izin verecek \u015fekilde yap\u0131land\u0131r\u0131l\u0131r. Ancak baz\u0131 durumlarda veritaban\u0131na uzaktan eri\u015fim gerekebilir. Sizlerde linux tabanl\u0131 bir sunucuya sahipseniz ve MySQL server i uzaktan eri\u015fime...<\/p>\n","protected":false},"author":2,"featured_media":10197,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,54],"tags":[],"class_list":["post-10186","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux","category-mysqlserver"],"_links":{"self":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/10186","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=10186"}],"version-history":[{"count":10,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/10186\/revisions"}],"predecessor-version":[{"id":10199,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/10186\/revisions\/10199"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media\/10197"}],"wp:attachment":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media?parent=10186"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/categories?post=10186"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/tags?post=10186"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}