{"id":109,"date":"2020-06-02T21:16:13","date_gmt":"2020-06-02T21:16:13","guid":{"rendered":"http:\/\/bahadirmeric.net\/bahadir\/?p=109"},"modified":"2020-06-02T21:48:28","modified_gmt":"2020-06-02T21:48:28","slug":"mysql-ulasimini-uzak-erisime-acmak","status":"publish","type":"post","link":"http:\/\/bahadirmeric.net\/bahadir\/2020\/06\/02\/mysql-ulasimini-uzak-erisime-acmak\/","title":{"rendered":"MySql Ula\u015f\u0131m\u0131n\u0131 Uzak Eri\u015fime A\u00e7mak"},"content":{"rendered":"\n<p>MySql\u2019 i Linux \u00fczerine kurduysan\u0131z genellikle sadece localhost \u00fczerinden eri\u015febildi\u011finizi g\u00f6receksiniz. Oysa ki baz\u0131 durumlarda farkl\u0131 bir noktadan da eri\u015fmeniz gerekebilir. \u0130\u015fte bu gibi durumlarda ne yapaca\u011f\u0131m\u0131za bir bakal\u0131m.\u00d6ncelikle kurulum yapt\u0131\u011f\u0131n\u0131z Linux bu komutlar\u0131n do\u011fru \u00e7al\u0131\u015fmas\u0131nda yada \u00e7al\u0131\u015fmamas\u0131nda b\u00fcy\u00fck bir rol oynayacakt\u0131r. Bu y\u00fczden bir server kullan\u0131caksan\u0131z yada kullanmay\u0131 d\u00fc\u015f\u00fcn\u00fcyorsan\u0131z bana g\u00f6re SME Linux\u2019 \u00fc yada Ubuntu Server versiyonlar\u0131n\u0131 tercih etmeniz gerekli. Di\u011fer kurulumlar\u0131da kullanabilirsiniz tabi bu tamamen size kalm\u0131\u015f bir durum. Ben SME ve Ubuntu versiyonlar\u0131nda %100 \u00e7al\u0131\u015fan bir \u00e7\u00f6z\u00fcm\u00fc anlataca\u011f\u0131m.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: powershell; title: ; notranslate\" title=\"\">\n#mysql \u2013user=root mysql \u2013password=&#x5B;\u015fifreniz]\nmysql&gt; grant all privileges on *.* to root@\u2019%\u2019 identified by &#x5B;\u2018\u015fifreniz\u2019] with grant option;\nmysql&gt; flush privileges;\n<\/pre><\/div>\n\n\n<p>Verilen son komut sizi mysql\u2019 den \u00e7\u0131kartacakt\u0131r. Admin konsoluna d\u00fc\u015ft\u00fc\u011f\u00fcn\u00fczde ise a\u015fa\u011f\u0131daki komutlar\u0131 girmeniz gerekli;<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: powershell; title: ; notranslate\" title=\"\">\n#config setprop mysqld LocalNetworkingOnly no\n#expand-template \/etc\/my.cnf\n#sv t \/service\/mysqld\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>MySql\u2019 i Linux \u00fczerine kurduysan\u0131z genellikle sadece localhost \u00fczerinden eri\u015febildi\u011finizi g\u00f6receksiniz. Oysa ki baz\u0131 durumlarda farkl\u0131 bir noktadan da eri\u015fmeniz gerekebilir. \u0130\u015fte bu gibi durumlarda ne yapaca\u011f\u0131m\u0131za bir bakal\u0131m.\u00d6ncelikle kurulum yapt\u0131\u011f\u0131n\u0131z Linux bu komutlar\u0131n do\u011fru \u00e7al\u0131\u015fmas\u0131nda yada \u00e7al\u0131\u015fmamas\u0131nda b\u00fcy\u00fck bir rol oynayacakt\u0131r. Bu y\u00fczden bir server kullan\u0131caksan\u0131z yada kullanmay\u0131 d\u00fc\u015f\u00fcn\u00fcyorsan\u0131z&#8230; <a class=\"continue-reading-link\" href=\"http:\/\/bahadirmeric.net\/bahadir\/2020\/06\/02\/mysql-ulasimini-uzak-erisime-acmak\/\"> Continue reading <span class=\"meta-nav\">&rarr; <\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":10,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[10,2],"class_list":["post-109","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-mysql","tag-sql"],"_links":{"self":[{"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/posts\/109","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/comments?post=109"}],"version-history":[{"count":1,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/posts\/109\/revisions"}],"predecessor-version":[{"id":110,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/posts\/109\/revisions\/110"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/media\/10"}],"wp:attachment":[{"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/media?parent=109"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/categories?post=109"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bahadirmeric.net\/bahadir\/wp-json\/wp\/v2\/tags?post=109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}