{"id":4753,"date":"2024-01-18T11:07:04","date_gmt":"2024-01-18T08:07:04","guid":{"rendered":"https:\/\/blog.inetmar.com\/?p=4753"},"modified":"2024-12-06T15:20:02","modified_gmt":"2024-12-06T12:20:02","slug":"mysqlde-kullaniciya-bir-veritabanina-tam-erisim-yetkisi-vermek","status":"publish","type":"post","link":"https:\/\/www.inetmar.com\/blog\/mysqlde-kullaniciya-bir-veritabanina-tam-erisim-yetkisi-vermek\/","title":{"rendered":"MySQL’de Kullan\u0131c\u0131ya Bir Veritaban\u0131na Tam Eri\u015fim Yetkisi Vermek"},"content":{"rendered":"

MySQL’de Kullan\u0131c\u0131ya Bir Veritaban\u0131na Tam Eri\u015fim Yetkisi Vermek:
\nMySQL’de yeni bir kullan\u0131c\u0131 olu\u015fturmak ve bu kullan\u0131c\u0131ya sadece belirlenen veritaban\u0131na tam eri\u015fim sa\u011flamak i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 takip edebilirsiniz:<\/p>\n

    \n
  1. MySQL’e Ba\u011flan\u0131n<\/li>\n
  2. Yeni Kullan\u0131c\u0131 Olu\u015fturun:\n
    \n
    <\/div>\n
    CREATE<\/span> USER<\/span> 'yeni_kullanici'<\/span>@'localhost'<\/span> IDENTIFIED BY<\/span> 'kullanici_sifresi'<\/span>;
    \n<\/code><\/div>\n<\/div>\n

    Yukar\u0131daki komut, ‘yeni_kullanici’<\/strong> ad\u0131nda bir kullan\u0131c\u0131 olu\u015fturur ve bu kullan\u0131c\u0131n\u0131n \u015fifresini ‘kullanici_sifresi’<\/strong> olarak belirler. Kullan\u0131c\u0131ya sadece yerel ba\u011flant\u0131lara izin verilmi\u015ftir (‘localhost’). E\u011fer uzak ba\u011flant\u0131lara da izin vermek istiyorsan\u0131z, ‘%’ kullanabilirsiniz.<\/li>\n

  3. Kullan\u0131c\u0131ya Veritaban\u0131 \u0130zinleri Verin:\n
    \n
    <\/div>\n
    GRANT<\/span> ALL<\/span> PRIVILEGES ON<\/span> veritabani_adi.*<\/span> TO<\/span> 'yeni_kullanici'<\/span>@'localhost'<\/span>;
    \n<\/code><\/div>\n<\/div>\n

    Yukar\u0131daki komut, ‘yeni_kullanici’<\/strong> kullan\u0131c\u0131s\u0131na ‘veritabani_adi’<\/strong> adl\u0131 veritaban\u0131na tam eri\u015fim izinlerini verir<\/strong>. \u0130zinleri g\u00fcncellemek veya s\u0131n\u0131rlamak i\u00e7in “ALL PRIVILEGES”<\/strong> k\u0131sm\u0131n\u0131 \u00f6zelle\u015ftirebilirsiniz.<\/li>\n

  4. De\u011fi\u015fiklikleri Uygulay\u0131n:\n
    \n
    <\/div>\n
    FLUSH PRIVILEGES;
    \n<\/code><\/div>\n<\/div>\n

    Bu komut, MySQL’in g\u00fcncellenmi\u015f izinleri hemen kullanmaya ba\u015flamas\u0131n\u0131 sa\u011flar.<\/li>\n

  5. \u00c7\u0131k\u0131\u015f Yap\u0131n:\n
    \n
    <\/div>\n
    EXIT;
    \n<\/code><\/div>\n<\/div>\n

    MySQL ba\u011flant\u0131s\u0131n\u0131 kapatmak i\u00e7in bu komutu kullan\u0131n.<\/li>\n<\/ol>\n

    Bu ad\u0131mlar\u0131 takip ettikten sonra, ‘yeni_kullanici’<\/strong> adl\u0131 kullan\u0131c\u0131 ‘veritabani_adi’<\/strong> adl\u0131 veritaban\u0131na tam eri\u015fime sahip olacakt\u0131r. Unutmay\u0131n ki g\u00fcvenlik nedeniyle kullan\u0131c\u0131lara sadece gerekli izinleri vermelisiniz.<\/strong><\/p>\n

    Ki\u015fisel ve kurumsal web hosting<\/a> se\u00e7eneklerimizi kar\u015f\u0131la\u015ft\u0131rarak en uygununu se\u00e7in.<\/p>\n

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

    MySQL’de Kullan\u0131c\u0131ya Bir Veritaban\u0131na Tam Eri\u015fim Yetkisi Vermek: MySQL’de yeni bir kullan\u0131c\u0131 olu\u015fturmak ve bu kullan\u0131c\u0131ya sadece belirlenen veritaban\u0131na tam eri\u015fim sa\u011flamak i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 takip edebilirsiniz: MySQL’e Ba\u011flan\u0131n Yeni Kullan\u0131c\u0131 Olu\u015fturun: CREATE USER ‘yeni_kullanici’@’localhost’...<\/p>\n","protected":false},"author":2,"featured_media":4857,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54],"tags":[],"class_list":["post-4753","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\/4753","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=4753"}],"version-history":[{"count":6,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/4753\/revisions"}],"predecessor-version":[{"id":9539,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/4753\/revisions\/9539"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media\/4857"}],"wp:attachment":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media?parent=4753"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/categories?post=4753"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/tags?post=4753"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}