{"id":12805,"date":"2025-02-01T15:06:58","date_gmt":"2025-02-01T12:06:58","guid":{"rendered":"https:\/\/www.inetmar.com\/blog\/?p=12805"},"modified":"2025-02-04T09:44:15","modified_gmt":"2025-02-04T06:44:15","slug":"mysql-sistem-kullanicilari-nasil-listelenir","status":"publish","type":"post","link":"https:\/\/www.inetmar.com\/blog\/mysql-sistem-kullanicilari-nasil-listelenir\/","title":{"rendered":"MySQL Sistem Kullan\u0131c\u0131lar\u0131 Nas\u0131l Listelenir?"},"content":{"rendered":"

MySQL’ de sistem kullan\u0131c\u0131lar\u0131n\u0131 listeme i\u015flemi \u00f6zellikle b\u00fcy\u00fck firmalar i\u00e7in yani birden fazla kullan\u0131c\u0131 ile \u00e7al\u0131\u015fan sistemlerde olduk\u00e7a \u00f6nemli bir ihtiya\u00e7t\u0131r. Bu yaz\u0131da MySQL kullan\u0131c\u0131lar\u0131n\u0131 nas\u0131l listeleyebilece\u011finizi ele alaca\u011f\u0131z. Haz\u0131rsan\u0131z ba\u015flayal\u0131m. \ud83d\ude42<\/p>\n

\"MySQL<\/p>\n

MySQL Kullan\u0131c\u0131lar\u0131n\u0131 Listeleme<\/h2>\n

Kullan\u0131c\u0131lar\u0131n detaylar\u0131n\u0131 \u00f6\u011frenmek i\u00e7in en s\u0131k kullan\u0131lan y\u00f6ntem mysql.user<\/code> tablosunu sorgulamakt\u0131r. Bu sorgulamay\u0131 yapmak i\u00e7in a\u015fa\u011f\u0131daki komutu kullanabilirsiniz.<\/p>\n

\n
SELECT<\/span> *<\/span> FROM<\/span> mysql.user;
\n<\/code><\/div>\n<\/div>\n

Bu sorgu \u00e7\u0131kt\u0131s\u0131nda kullan\u0131c\u0131lar\u0131n t\u00fcm bilgilerini (kullan\u0131c\u0131 ad\u0131, host bilgisi, \u015fifre durumu vb.) i\u00e7eren kapsaml\u0131 bir liste sunar.<\/p>\n

Kullan\u0131c\u0131 ve Host Bilgisini Listeleme<\/h2>\n

E\u011fer yaln\u0131zca kullan\u0131c\u0131 adlar\u0131n\u0131 ve hangi host \u00fczerinden ba\u011flanabileceklerini g\u00f6rmek istiyorsan\u0131z a\u015fa\u011f\u0131daki sorgu daha da i\u015finize yarayacakt\u0131r.<\/p>\n

\n
SELECT<\/span> CONCAT(QUOTE(user<\/span>), '@'<\/span>, QUOTE(host)) AS<\/span> UserAccount
\nFROM<\/span> mysql.user;
\n<\/code><\/div>\n<\/div>\n

Bu sorgu sonucu \u00f6rnek \u00e7\u0131kt\u0131 a\u015fa\u011f\u0131daki gibidir:<\/p>\n

\n
'root'<\/span>@'localhost'<\/span>
\n'admin'<\/span>@'%'<\/span>
\n'test_user'<\/span>@'192.168.1.10'<\/span><\/code><\/div>\n<\/div>\n

MySQL Kullan\u0131c\u0131 Yetkilerini G\u00f6rme<\/h2>\n

Belirli bir MySQL kullan\u0131c\u0131ya ait yetkileri g\u00f6rmek istiyorsan\u0131z \u015fu sorguyu kullanabilirsiniz:<\/p>\n

\n
SHOW<\/span> GRANTS FOR<\/span> 'kullanici_adi'<\/span>@'host'<\/span>;
\n<\/code><\/div>\n<\/div>\n
\n
Bu komut se\u00e7ti\u011finiz kullan\u0131c\u0131n\u0131n MySQL \u00fczerinde sahip oldu\u011fu yetkileri g\u00f6sterir.<\/div>\n<\/div>\n
\n
<\/div>\n<\/div>\n

NOT:<\/strong> Gereksiz kullan\u0131c\u0131lar\u0131 temizlemeyi ve kullan\u0131c\u0131 \u015fifrelerini d\u00fczenli olarak g\u00fcncellemeyi ihmal etmeyin.<\/p>\n

Sizde domain sorgulama<\/a> yaparak dijital d\u00fcnyaya at\u0131l\u0131n!<\/p>\n","protected":false},"excerpt":{"rendered":"

MySQL’ de sistem kullan\u0131c\u0131lar\u0131n\u0131 listeme i\u015flemi \u00f6zellikle b\u00fcy\u00fck firmalar i\u00e7in yani birden fazla kullan\u0131c\u0131 ile \u00e7al\u0131\u015fan sistemlerde olduk\u00e7a \u00f6nemli bir ihtiya\u00e7t\u0131r. Bu yaz\u0131da MySQL kullan\u0131c\u0131lar\u0131n\u0131 nas\u0131l listeleyebilece\u011finizi ele alaca\u011f\u0131z. Haz\u0131rsan\u0131z ba\u015flayal\u0131m. \ud83d\ude42 MySQL Kullan\u0131c\u0131lar\u0131n\u0131 Listeleme...<\/p>\n","protected":false},"author":2,"featured_media":12812,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54],"tags":[],"class_list":["post-12805","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\/12805","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=12805"}],"version-history":[{"count":9,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/12805\/revisions"}],"predecessor-version":[{"id":12827,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/12805\/revisions\/12827"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media\/12812"}],"wp:attachment":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media?parent=12805"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/categories?post=12805"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/tags?post=12805"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}