{"id":1703,"date":"2022-03-11T16:31:06","date_gmt":"2022-03-11T16:31:06","guid":{"rendered":"https:\/\/www.melibera.com\/blog\/?p=1703"},"modified":"2022-09-30T21:13:19","modified_gmt":"2022-09-30T21:13:19","slug":"plesk-panel-uzak-mysql-izni-nasil-verilir","status":"publish","type":"post","link":"https:\/\/www.melibera.com\/blog\/plesk-panel-uzak-mysql-izni-nasil-verilir.html","title":{"rendered":"Plesk Panel Uzak MYSQL \u0130zni Nas\u0131l Verilir?"},"content":{"rendered":"

Mysql \u00fczerinde y\u00fcksek boyutlu bir veritaban\u0131n\u0131z varsa yada mysql \u00fczerinde uzaktan ba\u011flant\u0131 yaparak \u00e7al\u0131\u015fmak istiyorsan\u0131z hosting hizmetiniz \u00fczerinde eri\u015fim sa\u011flayacak \u0130P adresine yada t\u00fcm \u0130P adreslerine izin vermeniz gerekmektedir. Plesk Panel \u00fczerinde mysql uzaktan ba\u011flant\u0131 i\u015flemine izin versenizde sunucunuzun my.cnf dosyas\u0131 yap\u0131land\u0131r\u0131lmam\u0131\u015fsa uzak mysql ba\u011flant\u0131s\u0131 sa\u011flayamazs\u0131n\u0131z. Bu yaz\u0131m\u0131zda sizlere SSH \u00fczerinden my.cnf dosyas\u0131n\u0131 yap\u0131land\u0131rmay\u0131 tarif edece\u011fiz.<\/p>\n

Plesk Panel \u00dczerinde Uzak MYSQL \u0130zni Nas\u0131l Verilir?<\/strong><\/h3>\n
    \n
  1. Plesk Panel \u00fczerinde hosting hizmetinize giri\u015f yap\u0131n.<\/li>\n
  2. Veritabanlar\u0131na t\u0131klay\u0131n.<\/li>\n
  3. Ba\u011flant\u0131 sa\u011flanacak veritaban\u0131 kullan\u0131c\u0131s\u0131n\u0131n \u00fczerine t\u0131klay\u0131n.<\/li>\n
  4. Eri\u015fim kontrol\u00fc b\u00f6l\u00fcm\u00fcnden \u0130P adresi yada t\u00fcm ba\u011flant\u0131lara izin verebilirsiniz. Tamam butonuna basarak yetki verme i\u015flemini tamamlayabilirsiniz.<\/li>\n<\/ol>\n

    Eri\u015fim kontrol\u00fc b\u00f6l\u00fcm\u00fcnde yer alan se\u00e7eneklerin a\u00e7\u0131klamas\u0131 a\u015fa\u011f\u0131daki gibidir;<\/p>\n

    Sadece yerel ba\u011flant\u0131lara izin verin:\u00a0<\/strong>Bu se\u00e7ene\u011fi se\u00e7ti\u011finizde uzaktan ba\u011flant\u0131 kapat\u0131lm\u0131\u015f olur ve veritaban\u0131n\u0131za uzaktan ba\u011flant\u0131 sa\u011flanamaz.<\/p>\n

    Herhangi bir ana bilgisayardan uzaktan ba\u011flant\u0131lara izin verin:<\/strong> Bu se\u00e7ene\u011fi se\u00e7it\u011finizde veritaban\u0131 bilgilerini bilen herkes uzak ba\u011flant\u0131 sa\u011flayabilir.<\/p>\n

    Buradan uzaktan ba\u011flant\u0131lara izin verin:<\/strong> Bu se\u00e7ene\u011fi se\u00e7ti\u011finizde eri\u015fim sa\u011flayacak bilgisayar\u0131n \u0130P adresine izin verebilirsiniz. Burada yazd\u0131\u011f\u0131n\u0131z \u0130P adresi d\u0131\u015f\u0131nda bir bilgisayar eri\u015fim sa\u011flayamaz.<\/p>\n

    SSH \u00dczerinde Uzak MYSQL Yap\u0131land\u0131rmas\u0131 Nas\u0131l Yap\u0131l\u0131r?<\/strong><\/h3>\n

    1. \u0130\u015flemlerimize ba\u015flamak i\u00e7in root kullan\u0131c\u0131s\u0131 ile SSH ba\u011flant\u0131s\u0131 yap\u0131yoruz.
    \n2. A\u015fa\u011f\u0131da yer alan komutu yaz\u0131yoruz;<\/p>\n

    nano \/etc\/my.cnf<\/p>\n

    3. Kar\u015f\u0131m\u0131za gelen ekranda # bind-address = ile gelen sat\u0131r\u0131 buluyoruz. Ba\u015f\u0131nda yer alan # i\u015fareti ile kar\u015f\u0131s\u0131nda yer alan \u0130P adresini silerek sunucumuzun \u0130P adresini yaz\u0131yoruz.<\/p>\n

    \u00d6rne\u011fin; bind-address = 192.168.1.1<\/p>\n

    \"\"<\/p>\n

    4. CTRL + X Tu\u015flar\u0131na basarak yapt\u0131\u011f\u0131m\u0131z de\u011fi\u015fikli\u011fi kay\u0131t ediyoruz.<\/p>\n

    5. \u0130\u015flemlerimiz bu kadar \u015fimdi veritaban\u0131 servisimizi yeniden ba\u015flatmam\u0131z gerekli.<\/p>\n

    MYSQL \u0130\u00e7in;<\/p>\n

    service mysqld restart<\/p>\n

    MariaDB \u0130\u00e7in;<\/p>\n

    service mariadb restart<\/p>\n","protected":false},"excerpt":{"rendered":"

    Mysql \u00fczerinde y\u00fcksek boyutlu bir veritaban\u0131n\u0131z varsa yada mysql \u00fczerinde uzaktan ba\u011flant\u0131 yaparak \u00e7al\u0131\u015fmak istiyorsan\u0131z hosting hizmetiniz \u00fczerinde eri\u015fim sa\u011flayacak … <\/p>\n

    Devam\u0131\u0131n\u0131 Oku<\/a><\/p>\n","protected":false},"author":1,"featured_media":1705,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[67,33],"tags":[412,414,413],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.melibera.com\/blog\/wp-json\/wp\/v2\/posts\/1703"}],"collection":[{"href":"https:\/\/www.melibera.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.melibera.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.melibera.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.melibera.com\/blog\/wp-json\/wp\/v2\/comments?post=1703"}],"version-history":[{"count":4,"href":"https:\/\/www.melibera.com\/blog\/wp-json\/wp\/v2\/posts\/1703\/revisions"}],"predecessor-version":[{"id":1708,"href":"https:\/\/www.melibera.com\/blog\/wp-json\/wp\/v2\/posts\/1703\/revisions\/1708"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.melibera.com\/blog\/wp-json\/wp\/v2\/media\/1705"}],"wp:attachment":[{"href":"https:\/\/www.melibera.com\/blog\/wp-json\/wp\/v2\/media?parent=1703"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.melibera.com\/blog\/wp-json\/wp\/v2\/categories?post=1703"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.melibera.com\/blog\/wp-json\/wp\/v2\/tags?post=1703"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}