{"id":560,"date":"2013-04-18T08:32:47","date_gmt":"2013-04-18T06:32:47","guid":{"rendered":"http:\/\/www.ayhanarda.com\/blog\/?p=560"},"modified":"2013-04-18T08:32:47","modified_gmt":"2013-04-18T06:32:47","slug":"plesk-error-1045-28000-access-denied-for-user-adminlocalhost-using-password-yes-hatasi","status":"publish","type":"post","link":"https:\/\/www.ayhanarda.com\/blog\/2013\/04\/plesk-error-1045-28000-access-denied-for-user-adminlocalhost-using-password-yes-hatasi\/","title":{"rendered":"Plesk ERROR 1045 (28000): Access denied for user \u2018admin\u2019@&#8217;localhost\u2019 (using password: YES) hatas\u0131"},"content":{"rendered":"<p><strong>ERROR 1045 (28000): Access denied for user \u2018admin\u2019@&#8217;localhost\u2019 (using password: YES)<\/strong> hatas\u0131n\u0131 al\u0131yor ve mysql de admin kullan\u0131c\u0131s\u0131n\u0131n \u015fifresini de\u011fi\u015ftirmedi iseniz mysql privilege leri ile ilgili bir sorununuz var demektir.<\/p>\n<p>\u00d6nce my.cnf dosyam\u0131z\u0131 a\u00e7\u0131yoruz.<\/p>\n<p><strong>nano \/etc\/my.cnf<\/strong><\/p>\n<p>\u0130\u00e7ine a\u015fa\u011f\u0131daki sat\u0131r yok ise ekleyiniz.<\/p>\n<p><strong>skip_grant_tables=1<\/strong><\/p>\n<p>Dosyay\u0131 kaydedip \u00e7\u0131k\u0131n\u0131z ve mysql i restart ediniz.<\/p>\n<p><strong>service mysqld restart<\/strong><\/p>\n<p>Sonras\u0131nda a\u015fa\u011f\u0131daki komutu \u00e7al\u0131\u015ft\u0131r\u0131n\u0131z.<\/p>\n<p><strong>mysql_fix_privilege_tables &#8211;user=admin &#8211;password=&#8217;SIFRENIZ&#8217; &#8211;verbose<\/strong><\/p>\n<p>***(\u015fifreyi g\u00f6rmek i\u00e7in <strong>cat \/etc\/psa\/.psa.shadow<\/strong> komutunu kullanabilirsiniz)<\/p>\n<p>Sonra tekrar mysql i restart edelim.<\/p>\n<p><strong>service mysqld restart<\/strong><\/p>\n<p>\u015eimdi muhtemelen d\u00fczelmi\u015f olmal\u0131.<\/p>\n<p>Ayhan ARDA<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_toolbar\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/tr\/share-medium.png\" style=\"border:0px; padding-top: 5px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_t=new Array(\"Twitter\",\"Facebook\",\"Google Plus\",\"Pinterest\",\"Linkedin\");var hupso_background_t=\"#EAF4FF\";var hupso_border_t=\"#66CCFF\";var hupso_toolbar_size_t=\"medium\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"ayhanarda\";var hupso_url_t=\"\";var hupso_title_t=\"Plesk%20ERROR%201045%20%2828000%29%3A%20Access%20denied%20for%20user%20%E2%80%98admin%E2%80%99%40%27localhost%E2%80%99%20%28using%20password%3A%20YES%29%20hatas%C4%B1\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/share_toolbar.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"ERROR 1045 (28000): Access denied for user \u2018admin\u2019@&#8217;localhost\u2019 (using password: YES) hatas\u0131n\u0131 al\u0131yor ve mysql de admin kullan\u0131c\u0131s\u0131n\u0131n \u015fifresini de\u011fi\u015ftirmedi iseniz mysql privilege leri ile ilgili bir sorununuz var demektir. \u00d6nce my.cnf dosyam\u0131z\u0131 a\u00e7\u0131yoruz. nano \/etc\/my.cnf \u0130\u00e7ine a\u015fa\u011f\u0131daki sat\u0131r yok ise ekleyiniz. skip_grant_tables=1 Dosyay\u0131 kaydedip \u00e7\u0131k\u0131n\u0131z ve mysql i restart ediniz. service mysqld restart Sonras\u0131nda [&hellip;]","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","footnotes":""},"categories":[23],"tags":[24,394,393],"class_list":["post-560","post","type-post","status-publish","format-standard","hentry","category-plesk","tag-plesk-2","tag-plesk-mysql","tag-psa"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/posts\/560","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/comments?post=560"}],"version-history":[{"count":2,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/posts\/560\/revisions"}],"predecessor-version":[{"id":562,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/posts\/560\/revisions\/562"}],"wp:attachment":[{"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/media?parent=560"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/categories?post=560"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/tags?post=560"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}