{"id":2770,"date":"2017-12-09T12:24:56","date_gmt":"2017-12-09T12:24:56","guid":{"rendered":"http:\/\/www.scmgalaxy.com\/tutorials\/?p=2770"},"modified":"2020-01-09T07:00:59","modified_gmt":"2020-01-09T07:00:59","slug":"mysql-error-1045-28000-access-denied-for-user-rootlocalhost-using-password-yes","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/mysql-error-1045-28000-access-denied-for-user-rootlocalhost-using-password-yes\/","title":{"rendered":"MySQL Error 1045 (28000): Access denied for user \u2018root\u2019@\u2019localhost\u2019 (using password: YES)"},"content":{"rendered":"<p><strong>rajeshkumar created the topic: MySQL ERROR 1045 (28000): Access denied for user \u2018root\u2019@\u2019localhost\u2019 (using password: YES)<\/strong><\/p>\n<p>MySQL ERROR 1045 (28000): Access denied for user \u2018root\u2019@\u2019localhost\u2019 (using password: YES)<\/p>\n<p>root@server [~]# mysql<\/p>\n<p>ERROR 1045 (28000): Access denied for user \u2018root\u2019@\u2019localhost\u2019 (using password: YES)<br \/>\nroot@server [~]#<\/p>\n<p>root@server [\/var\/lib\/mysql\/mysql]# ls -lhd \/var\/lib\/mysql<br \/>\ndrwxr-x\u2013x 179 mysql mysql 12K Aug 25 01:44 \/var\/lib\/mysql\/<\/p>\n<p>root@server [\/var\/lib\/mysql\/mysql]# chmod 711 \/var\/lib\/mysql\/mysql<\/p>\n<p>root@server1 [\/var\/lib\/mysql\/mysql]# ls -lhd \/var\/lib\/mysql\/mysql<br \/>\ndrwx\u2013x\u2013x 2 mysql mysql 4.0K Aug 25 01:32 \/var\/lib\/mysql\/mysql\/<\/p>\n<p>root@server1 [\/var\/lib\/mysql\/mysql]# service mysql restart<br \/>\nShutting down MySQL.. [ OK ]<br \/>\nStarting MySQL [ OK ]<br \/>\nroot@server1 [\/var\/lib\/mysql\/mysql]# mysql<br \/>\nWelcome to the MySQL monitor. Commands end with ; or \\g. Your MySQL connection id is 1<br \/>\nServer version: 5.0.51a-community MySQL Community Edition (GPL)Type \u2018help;\u2019 or \u2018\\h\u2019 for help. Type \u2018\\c\u2019 to clear the buffer.<\/p>\n<p>mysql&gt; quit<\/p>\n<p>Bye<br \/>\nRegards,<br \/>\nRajesh Kumar<br \/>\nTwitt me @ <a href=\"http:\/\/twitter.com\/RajeshKumarIn\" target=\"_blank\" rel=\"noopener\">twitter.com\/RajeshKumarIn<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>rajeshkumar created the topic: MySQL ERROR 1045 (28000): Access denied for user \u2018root\u2019@\u2019localhost\u2019 (using password: YES) MySQL ERROR 1045 (28000): Access denied for user \u2018root\u2019@\u2019localhost\u2019 (using password: YES) root@server [~]# mysql ERROR 1045 (28000): Access denied for user \u2018root\u2019@\u2019localhost\u2019 (using password: YES) root@server [~]# root@server [\/var\/lib\/mysql\/mysql]# ls -lhd \/var\/lib\/mysql drwxr-x\u2013x 179 mysql mysql 12K Aug&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","_joinchat":[],"footnotes":""},"categories":[2],"tags":[493],"class_list":["post-2770","post","type-post","status-publish","format-standard","hentry","category-uncategorised","tag-mysql"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/2770","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=2770"}],"version-history":[{"count":2,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/2770\/revisions"}],"predecessor-version":[{"id":8512,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/2770\/revisions\/8512"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=2770"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=2770"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=2770"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}