{"id":10089,"date":"2024-04-06T12:16:01","date_gmt":"2024-04-06T09:16:01","guid":{"rendered":"https:\/\/sunucun.com.tr\/bilgi\/?post_type=dt_articles&#038;p=10089"},"modified":"2026-02-06T20:40:54","modified_gmt":"2026-02-06T17:40:54","slug":"mysql-kullanici-olusturma-ve-izin-verme-veritabani-kullanicilari-ve-ayricaliklarinin-yonetimi","status":"publish","type":"post","link":"https:\/\/sunucun.com.tr\/blog\/mysql-kullanici-olusturma-ve-izin-verme-veritabani-kullanicilari-ve-ayricaliklarinin-yonetimi\/","title":{"rendered":"MySQL Kullan\u0131c\u0131 Olu\u015fturma ve \u0130zin Verme: Veritaban\u0131 Kullan\u0131c\u0131lar\u0131 ve Ayr\u0131cal\u0131klar\u0131n\u0131n Y\u00f6netimi"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-kullanici-olusturma-ve-izin-verme-veritabani-kullanicilari-ve-ayricaliklarinin-yonetimi\/#1_MySQLde_Kullanici_Olusturma\" >1. MySQL&#8217;de Kullan\u0131c\u0131 Olu\u015fturma<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-kullanici-olusturma-ve-izin-verme-veritabani-kullanicilari-ve-ayricaliklarinin-yonetimi\/#2_Kullaniciya_Izin_Verme\" >2. Kullan\u0131c\u0131ya \u0130zin Verme<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-kullanici-olusturma-ve-izin-verme-veritabani-kullanicilari-ve-ayricaliklarinin-yonetimi\/#3_Ayricaliklarin_Yonetimi\" >3. Ayr\u0131cal\u0131klar\u0131n Y\u00f6netimi<\/a><\/li><\/ul><\/nav><\/div>\n\r\n<p class=\"wp-block-paragraph\">MySQL, geni\u015f bir kullan\u0131c\u0131 kitlesi taraf\u0131ndan tercih edilen ve y\u00fcksek performans\u0131yla bilinen bir ili\u015fkisel veritaban\u0131 y\u00f6netim sistemidir. Veritaban\u0131 y\u00f6netiminde en \u00f6nemli konulardan biri, veritaban\u0131 kullan\u0131c\u0131lar\u0131n\u0131n olu\u015fturulmas\u0131 ve bu kullan\u0131c\u0131lara uygun ayr\u0131cal\u0131klar\u0131n tan\u0131mlanmas\u0131d\u0131r. Do\u011fru yap\u0131land\u0131r\u0131lm\u0131\u015f kullan\u0131c\u0131lar ve izinler, veri g\u00fcvenli\u011fini ve eri\u015fim kontrol\u00fcn\u00fc sa\u011flar. Bu makalede, <a href=\"https:\/\/www.sunucun.com.tr\/blog\/dt-articles\/mysql-kullanici-olusturma-ve-izin-verme-veritabani-kullanicilari-ve-ayricaliklarinin-yonetimi\/\">MySQL&#8217;de kullan\u0131c\u0131 olu\u015fturma, kullan\u0131c\u0131ya ayr\u0131cal\u0131k verme ve bu ayr\u0131cal\u0131klar\u0131 y\u00f6netme<\/a> konular\u0131n\u0131 ayr\u0131nt\u0131l\u0131 bir \u015fekilde ele alaca\u011f\u0131z.<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_MySQLde_Kullanici_Olusturma\"><\/span>1. MySQL&#8217;de Kullan\u0131c\u0131 Olu\u015fturma<span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">MySQL&#8217;de yeni bir kullan\u0131c\u0131 olu\u015fturmak, veritaban\u0131 y\u00f6netiminde ilk ad\u0131md\u0131r. Bu kullan\u0131c\u0131lar\u0131n belirli veritabanlar\u0131na eri\u015fim izni olabilir ve belirli i\u015flemleri ger\u00e7ekle\u015ftirebilir. Yeni bir kullan\u0131c\u0131 olu\u015fturmak i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyin:<\/p>\r\n\r\n\r\n\r\n<ol class=\"wp-block-list\">\r\n<li>MySQL&#8217;e ba\u011flan\u0131n. Bunun i\u00e7in terminal veya komut istemcisini a\u00e7arak a\u015fa\u011f\u0131daki komutu kullanarak MySQL&#8217;e giri\u015f yap\u0131n:<\/li>\r\n<\/ol>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>mysql -u root -p<\/code><\/pre>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">MySQL&#8217;e giri\u015f yapt\u0131ktan sonra, yeni bir kullan\u0131c\u0131 olu\u015fturmak i\u00e7in \u015fu komutu kullanabilirsiniz:<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>CREATE USER 'kullanici_adi'@'localhost' IDENTIFIED BY 'sifre';<\/code><\/pre>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Bu komutla, &#8216;kullanici_adi&#8217; ad\u0131nda bir kullan\u0131c\u0131 ve &#8216;sifre&#8217; ile tan\u0131mlanm\u0131\u015f bir \u015fifre olu\u015fturursunuz. &#8216;localhost&#8217; ifadesi, bu kullan\u0131c\u0131n\u0131n hangi host \u00fczerinden ba\u011flanabilece\u011fini belirtir. E\u011fer kullan\u0131c\u0131ya farkl\u0131 bir makineden eri\u015fim izni vermek istiyorsan\u0131z, &#8216;localhost&#8217; yerine ilgili IP adresini veya &#8216;%&#8217; i\u015faretini kullanabilirsiniz. &#8216;%&#8217; t\u00fcm IP adreslerinden eri\u015fimi sa\u011flar, ancak g\u00fcvenlik a\u00e7\u0131s\u0131ndan tavsiye edilmez.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">\u00d6rne\u011fin, kullan\u0131c\u0131ya bir IP adresi \u00fczerinden ba\u011flanma izni vermek i\u00e7in \u015fu komutu kullanabilirsiniz:<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>CREATE USER 'kullanici_adi'@'192.168.1.100' IDENTIFIED BY 'sifre';<\/code><\/pre>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Bu komut, kullan\u0131c\u0131n\u0131n sadece 192.168.1.100 IP adresi \u00fczerinden MySQL veritaban\u0131na ba\u011flanmas\u0131na izin verir. Bu t\u00fcr yap\u0131land\u0131rmalar, veritaban\u0131n\u0131za yaln\u0131zca belirli kaynaklardan eri\u015fim izni vererek g\u00fcvenli\u011fi art\u0131rabilir.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full is-resized\"><img fetchpriority=\"high\" decoding=\"async\" width=\"640\" height=\"320\" class=\"wp-image-10091\" style=\"width: 789px; height: auto;\" src=\"https:\/\/www.sunucun.com.tr\/blog\/\/wp-content\/uploads\/2024\/04\/FA-MySQL-edited.png\" alt=\"MySQL Kullan\u0131c\u0131 Olu\u015fturma\" srcset=\"https:\/\/sunucun.com.tr\/blog\/wp-content\/uploads\/2024\/04\/FA-MySQL-edited.png 640w, https:\/\/sunucun.com.tr\/blog\/wp-content\/uploads\/2024\/04\/FA-MySQL-edited-300x150.png 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_Kullaniciya_Izin_Verme\"><\/span>2. Kullan\u0131c\u0131ya \u0130zin Verme<span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Yeni olu\u015fturdu\u011funuz kullan\u0131c\u0131ya, belirli veritabanlar\u0131na eri\u015fim izni vermeniz gerekecektir. Kullan\u0131c\u0131ya izin vermek i\u00e7in &#8216;GRANT&#8217; komutu kullan\u0131l\u0131r. Bu komut, kullan\u0131c\u0131ya belirli veritabanlar\u0131na ve tablolara eri\u015fim izni vermenizi sa\u011flar.<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>GRANT SELECT, INSERT, UPDATE ON veritabani_adi.* TO 'kullanici_adi'@'localhost';<\/code><\/pre>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Bu komut, kullan\u0131c\u0131n\u0131n belirli bir veritaban\u0131 \u00fczerindeki belirli i\u015flemleri ger\u00e7ekle\u015ftirmesine olanak tan\u0131r. \u00d6rne\u011fin, yukar\u0131daki komut, kullan\u0131c\u0131ya &#8216;veritabani_adi&#8217; adl\u0131 veritaban\u0131nda SELECT (veri se\u00e7me), INSERT (veri ekleme) ve UPDATE (veri g\u00fcncelleme) i\u015flemleri i\u00e7in izin verir. E\u011fer t\u00fcm veritabanlar\u0131na ve tablolara tam yetki vermek istiyorsan\u0131z, \u015fu komutu kullanabilirsiniz:<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>GRANT ALL PRIVILEGES ON *.* TO 'kullanici_adi'@'localhost';<\/code><\/pre>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Bu komut, kullan\u0131c\u0131n\u0131n t\u00fcm veritabanlar\u0131nda ve tablolarda tam yetkiye sahip olmas\u0131n\u0131 sa\u011flar. Ancak, g\u00fcvenlik a\u00e7\u0131s\u0131ndan, kullan\u0131c\u0131lara sadece ihtiya\u00e7 duyduklar\u0131 yetkileri vermek her zaman en iyi uygulamad\u0131r. \u00d6rne\u011fin, bir geli\u015ftiriciye sadece veri okuma yetkisi vermek, veritaban\u0131 b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc koruma a\u00e7\u0131s\u0131ndan \u00f6nemlidir. Bu t\u00fcr s\u0131n\u0131rlamalar, \u00f6zellikle b\u00fcy\u00fck ekiplerde \u00e7al\u0131\u015f\u0131rken ve hassas verilerle u\u011fra\u015f\u0131rken olduk\u00e7a faydal\u0131d\u0131r.<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_Ayricaliklarin_Yonetimi\"><\/span>3. Ayr\u0131cal\u0131klar\u0131n Y\u00f6netimi<span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Veritaban\u0131 kullan\u0131c\u0131lar\u0131na verilen ayr\u0131cal\u0131klar\u0131 y\u00f6netmek, g\u00fcvenli\u011fin sa\u011flanmas\u0131 ve veritaban\u0131 performans\u0131n\u0131n korunmas\u0131 i\u00e7in \u00f6nemlidir. MySQL&#8217;de kullan\u0131c\u0131lar\u0131n ayr\u0131cal\u0131klar\u0131n\u0131 y\u00f6netmek i\u00e7in &#8216;REVOKE&#8217; komutu kullan\u0131l\u0131r. Bu komut, belirli ayr\u0131cal\u0131klar\u0131 geri almak veya iptal etmek i\u00e7in kullan\u0131l\u0131r. \u00d6rne\u011fin, bir kullan\u0131c\u0131dan belirli bir veritaban\u0131na eri\u015fim iznini kald\u0131rmak i\u00e7in \u015fu komutu kullanabilirsiniz:<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>REVOKE SELECT ON veritabani_adi.* FROM 'kullanici_adi'@'localhost';<\/code><\/pre>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Bu komut, kullan\u0131c\u0131n\u0131n &#8216;veritabani_adi&#8217; veritaban\u0131ndaki SELECT (veri se\u00e7me) iznini kald\u0131r\u0131r. Kullan\u0131c\u0131n\u0131n t\u00fcm ayr\u0131cal\u0131klar\u0131n\u0131 iptal etmek isterseniz, \u015fu komutu kullanabilirsiniz:<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>REVOKE ALL PRIVILEGES ON *.* FROM 'kullanici_adi'@'localhost';<\/code><\/pre>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Ayr\u0131ca, kullan\u0131c\u0131lar\u0131n belirli ayr\u0131cal\u0131klar\u0131n\u0131 de\u011fi\u015ftirdikten sonra, bu de\u011fi\u015fikliklerin an\u0131nda uygulanmas\u0131 i\u00e7in &#8216;FLUSH PRIVILEGES&#8217; komutunu kullanman\u0131z gerekebilir. Bu komut, MySQL&#8217;in yetkilendirme tablolar\u0131n\u0131 yeniden y\u00fckleyerek yap\u0131lan de\u011fi\u015fikliklerin aktif hale gelmesini sa\u011flar. \u00d6zellikle s\u0131k\u00e7a yap\u0131lan izin g\u00fcncellemelerinde bu komutun kullan\u0131lmas\u0131 \u00f6nemlidir.<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>FLUSH PRIVILEGES;<\/code><\/pre>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Sonu\u00e7 olarak, MySQL&#8217;de kullan\u0131c\u0131 olu\u015fturma ve y\u00f6netme i\u015flemleri, veritaban\u0131 g\u00fcvenli\u011finin sa\u011flanmas\u0131 a\u00e7\u0131s\u0131ndan kritik bir rol oynar. Kullan\u0131c\u0131lara sadece gerekli yetkileri vermek, veritaban\u0131n\u0131z\u0131n g\u00fcvenli\u011fini art\u0131r\u0131r ve potansiyel g\u00fcvenlik a\u00e7\u0131klar\u0131n\u0131 minimize eder. Ayn\u0131 zamanda, gereksiz yetkilerden ar\u0131nd\u0131r\u0131lm\u0131\u015f bir kullan\u0131c\u0131 yap\u0131s\u0131, veritaban\u0131 performans\u0131n\u0131 ve y\u00f6netimini de olumlu y\u00f6nde etkiler. Daha fazla bilgi i\u00e7in <a href=\"https:\/\/www.sunucun.com.tr\/blog\/dt-articles\/mysql-kullanici-olusturma-ve-izin-verme-veritabani-kullanicilari-ve-ayricaliklarinin-yonetimi\/\">bu makaleye g\u00f6z atabilirsiniz<\/a>.<\/p>\r\n\r\n<p>&nbsp;<\/p>","protected":false},"excerpt":{"rendered":"<p>MySQL, geni\u015f bir kullan\u0131c\u0131 kitlesi taraf\u0131ndan tercih edilen ve y\u00fcksek performans\u0131yla bilinen bir ili\u015fkisel veritaban\u0131 y\u00f6netim sistemidir. Veritaban\u0131 y\u00f6netiminde en \u00f6nemli konulardan biri, veritaban\u0131 kullan\u0131c\u0131lar\u0131n\u0131n olu\u015fturulmas\u0131 ve bu kullan\u0131c\u0131lara uygun ayr\u0131cal\u0131klar\u0131n tan\u0131mlanmas\u0131d\u0131r. Do\u011fru yap\u0131land\u0131r\u0131lm\u0131\u015f kullan\u0131c\u0131lar ve izinler, veri g\u00fcvenli\u011fini ve eri\u015fim kontrol\u00fcn\u00fc sa\u011flar. Bu makalede, MySQL&#8217;de kullan\u0131c\u0131 olu\u015fturma, kullan\u0131c\u0131ya ayr\u0131cal\u0131k verme ve bu ayr\u0131cal\u0131klar\u0131 y\u00f6netme&hellip;<\/p>\n","protected":false},"author":1,"featured_media":10084,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[1525,1521],"tags":[],"class_list":["post-10089","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-siber-guvenlik","category-teknoloji"],"_links":{"self":[{"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/posts\/10089","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/comments?post=10089"}],"version-history":[{"count":1,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/posts\/10089\/revisions"}],"predecessor-version":[{"id":16494,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/posts\/10089\/revisions\/16494"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/media\/10084"}],"wp:attachment":[{"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/media?parent=10089"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/categories?post=10089"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/tags?post=10089"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}