{"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&#46;&#46;&#46;<\/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}]}}