{"id":10935,"date":"2024-10-07T13:44:23","date_gmt":"2024-10-07T10:44:23","guid":{"rendered":"https:\/\/www.inetmar.com\/blog\/?p=10935"},"modified":"2024-12-06T15:48:06","modified_gmt":"2024-12-06T12:48:06","slug":"mysql-access-denied-super-privilege-required-hatasi-cozumu","status":"publish","type":"post","link":"https:\/\/www.inetmar.com\/blog\/mysql-access-denied-super-privilege-required-hatasi-cozumu\/","title":{"rendered":"MySQL Access Denied: SUPER Privilege Required Hatas\u0131 \u00c7\u00f6z\u00fcm\u00fc"},"content":{"rendered":"<p>MySQL veritabanlar\u0131yla i\u015flem yaparken kar\u015f\u0131la\u015f\u0131lan\u00a0 <strong>\u201cAccess denied; you need (at least one of) the SUPER privilege(s) for this operation.\u201d<\/strong> hatas\u0131 kullan\u0131c\u0131n\u0131z\u0131n belirli bir i\u015flemi ger\u00e7ekle\u015ftirmek i\u00e7in gereken yetkilere sahip olmad\u0131\u011f\u0131n\u0131 g\u00f6sterir. Bu hatay\u0131 \u00e7\u00f6z\u00fcmlemek i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 takip edebilirsiniz.<\/p>\n<h2>\u00d6rnek Hata \u00c7\u0131kt\u0131s\u0131<\/h2>\n<pre class=\"lang-sql s-code-block\"><code class=\"hljs language-sql\" data-highlighted=\"yes\">ERROR <span class=\"hljs-number\">1227<\/span> (<span class=\"hljs-number\">42000<\/span>) <span class=\"hljs-keyword\">at<\/span> line <span class=\"hljs-number\">35<\/span>: Access denied; you need (<span class=\"hljs-keyword\">at<\/span> least <span class=\"hljs-keyword\">one<\/span> <span class=\"hljs-keyword\">of<\/span>) the SUPER privilege(s) <span class=\"hljs-keyword\">for<\/span> this operation\r\n<\/code><\/pre>\n<h2>Hata \u00c7\u00f6z\u00fcmleri<\/h2>\n<p>SQL yede\u011fi y\u00fcklerken yada yeni bir tablo olu\u015ftururken bu hatay\u0131 al\u0131yorsan\u0131z a\u015fa\u011f\u0131daki komutu uygulay\u0131n.<\/p>\n<p><code>GRANT <span class=\"hljs-keyword\">ALL<\/span> PRIVILEGES <span class=\"hljs-keyword\">ON<\/span> veritabani_adi.<span class=\"hljs-operator\">*<\/span> <span class=\"hljs-keyword\">TO<\/span> <span class=\"hljs-string\">'kullanici_adi'<\/span>@<span class=\"hljs-string\">'localhost'<\/span>; FLUSH PRIVILEGES;<\/code><\/p>\n<p>Bu komut gerekli yetkileri vererek hatay\u0131 \u00e7\u00f6z\u00fcmleyecektir.<\/p>\n<p>E\u011fer ba\u015fka kullan\u0131c\u0131lar\u0131n oturumlar\u0131n\u0131 sonland\u0131r\u0131rken ya da root yetkisi gerektiren ba\u015fka bir i\u015flem yaparken bu hatay\u0131 al\u0131yorsan\u0131z kullan\u0131c\u0131ya <strong>SUPER<\/strong> yetkisi vermeniz gerekir. Bu yetkiyi a\u015fa\u011f\u0131daki komutla verebilirsiniz.<\/p>\n<p><code>GRANT SUPER <span class=\"hljs-keyword\">ON<\/span> <span class=\"hljs-operator\">*<\/span>.<span class=\"hljs-operator\">*<\/span> <span class=\"hljs-keyword\">TO<\/span> <span class=\"hljs-string\">'kullanici_adi'<\/span>@<span class=\"hljs-string\">'localhost'<\/span>; FLUSH PRIVILEGES;<\/code><\/p>\n<p><strong>Access denied; you need (at least one of) the SUPER privilege(s) for this operation<\/strong> hatas\u0131 \u00e7\u00f6z\u00fcm\u00fc i\u00e7in yukar\u0131daki ad\u0131mlar\u0131 uygulad\u0131ktan sonra sorun \u00e7\u00f6z\u00fclecektir. Gerekli yetkileri sa\u011flad\u0131\u011f\u0131n\u0131zda istedi\u011finiz i\u015flemleri sorunsuz bir \u015fekilde ger\u00e7ekle\u015ftirebilirsiniz. Daha fazla i\u00e7erik i\u00e7in blog sayfam\u0131z\u0131 ziyaret etmeyi unutmay\u0131n!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL veritabanlar\u0131yla i\u015flem yaparken kar\u015f\u0131la\u015f\u0131lan\u00a0 \u201cAccess denied; you need (at least one of) the SUPER privilege(s) for this operation.\u201d hatas\u0131 kullan\u0131c\u0131n\u0131z\u0131n belirli bir i\u015flemi ger\u00e7ekle\u015ftirmek i\u00e7in gereken yetkilere sahip olmad\u0131\u011f\u0131n\u0131 g\u00f6sterir. Bu hatay\u0131 \u00e7\u00f6z\u00fcmlemek i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 takip edebilirsiniz. \u00d6rnek Hata \u00c7\u0131kt\u0131s\u0131 ERROR 1227 (42000) at line 35: Access denied; you need (at least one &hellip;<\/p>\n","protected":false},"author":2,"featured_media":10943,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54],"tags":[],"class_list":["post-10935","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\/10935","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=10935"}],"version-history":[{"count":7,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/10935\/revisions"}],"predecessor-version":[{"id":10942,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/10935\/revisions\/10942"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media\/10943"}],"wp:attachment":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media?parent=10935"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/categories?post=10935"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/tags?post=10935"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}