{"id":2182,"date":"2017-05-28T22:10:53","date_gmt":"2017-05-28T22:10:53","guid":{"rendered":"http:\/\/www.kodcafe.com\/?p=2182"},"modified":"2020-10-22T02:57:17","modified_gmt":"2020-10-21T23:57:17","slug":"mysql-de-kullanici-islemleri","status":"publish","type":"post","link":"https:\/\/www.kodcafe.com\/?p=2182","title":{"rendered":"Mysql de Kullan\u0131c\u0131 \u0130\u015flemleri"},"content":{"rendered":"

 CREATE USER : Kullan\u0131c\u0131 olu\u015fturma<\/span><\/strong><\/h1>\n

CREATE USER user_specification<\/em><\/p>\n

[, user_specification<\/em>] …<\/p>\n

user_specification<\/em>:<\/p>\n

user<\/em><\/p>\n

[IDENTIFIED BY [PASSWORD] ‘password<\/em>‘<\/p>\n

| IDENTIFIED WITH auth_plugin<\/em> [AS ‘auth_string<\/em>‘]<\/p>\n

 <\/p>\n

    \n
  • CREATE USER \u2018ali’@’localhost’ IDENTIFIED BY \u2018sifre’;<\/li>\n
  • CREATE USER \u2018superali\u2019@\u2019%\u2019 IDENTIFIED BY \u2018zorsifre\u2019;<\/li>\n
  • CREATE USER \u2018kullanici\u2019@\u2019%.com\u2019 IDENTIFIED BY \u2018sifre\u2019;<\/li>\n
  • INSERT INTO user (host,user,password) VALUES(‘localhost’,\u2018kullanici’,PASSWORD(\u2018sifre\u2019));<\/li>\n
  • <\/li>\n<\/ul>\n

    DROP USER : KULLANICIYI S\u0130LMEK<\/strong><\/span><\/p>\n

    DROP USER \u2018ali\u2019@\u2018localhost\u2019;<\/p>\n

     <\/p>\n

    RENAME USER : Kullan\u0131c\u0131 ismi de\u011fi\u015ftirmek<\/strong><\/span><\/p>\n

    RENAME USER \u2018ali\u2019@’localhost’ TO \u2018veli’@’127.0.0.1′;<\/p>\n

    SET PASSWORD : \u015eifre de\u011fi\u015ftirme<\/strong><\/span><\/p>\n

    SET PASSWORD FOR \u2018can’@’%.edu.tr’ = PASSWORD(\u2018sifre<\/em>‘);<\/p>\n

    Update mysql.user  set password= PASSWORD(\u2018sifre<\/em>‘) where user=\u2019can\u2019 and host=\u2019%edu.tr\u2019;<\/p>\n

     <\/p>\n

     <\/p>\n

    GRANT  : YETK\u0130  VERMEK<\/span><\/p>\n

    GRANT YETKILER ON VERITABANI_ADI<\/p>\n

    TO KULLANICI IDENTIFIED BY Istenen_Sifre ;<\/p>\n

    grant all on * to ‘dilek’@’%’  identified by ‘bote’;   dilek kullan\u0131c\u0131s\u0131 tum veri tabanlar\u0131nda yetkilidir.<\/p>\n

     <\/p>\n

    GRANT CREATE DATABASE ON deneme.* TO ‘dilek’@’192.168.1.37’ IDENTIFIED BY ‘sifre1’;<\/p>\n

    dilek kullanicisina deneme veritabani uzerinde sifre1 parolasi ile 192.168.1.37 ip_adresli makineden veritaban\u0131 olu\u015fturma izni ile baglanabilmesi icin;<\/p>\n","protected":false},"excerpt":{"rendered":"

     CREATE USER : Kullan\u0131c\u0131 olu\u015fturma CREATE USER user_specification [, user_specification] … user_specification: user [IDENTIFIED BY [PASSWORD] ‘password‘ | IDENTIFIED WITH auth_plugin [AS ‘auth_string‘]  <\/p>\n","protected":false},"author":1,"featured_media":2258,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[278],"class_list":["post-2182","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-mysql-de-kullanici-islemleri"],"_links":{"self":[{"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/posts\/2182","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2182"}],"version-history":[{"count":1,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/posts\/2182\/revisions"}],"predecessor-version":[{"id":2259,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/posts\/2182\/revisions\/2259"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=\/wp\/v2\/media\/2258"}],"wp:attachment":[{"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2182"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2182"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kodcafe.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2182"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}