{"id":561,"date":"2010-03-14T06:43:28","date_gmt":"2010-03-14T10:43:28","guid":{"rendered":"http:\/\/linuxhostingsupport.net\/blog\/?p=561"},"modified":"2014-01-18T07:16:34","modified_gmt":"2014-01-18T11:16:34","slug":"mysql-access-denied-for-user-rootlocalhost","status":"publish","type":"post","link":"https:\/\/linuxhostingsupport.net\/blog\/mysql-access-denied-for-user-rootlocalhost","title":{"rendered":"Mysql: Access denied for user ‘root’@’localhost’"},"content":{"rendered":"

You may receive the “Access denied for user ‘root’@’localhost'”<\/strong> message while accessing mysql from the command prompt.<\/p>\n

The error message states that the Mysql password for user ‘root’ is incorrect and need to reset the password using the skip-grant-tables method.<\/strong><\/p>\n

\n
ERROR 1045 (28000): Access denied for user 'root'@'localhost' <\/span>\r\n(using password: NO)<\/span><\/pre>\n<\/blockquote>\n
How to reset root Mysql password in Linux?<\/strong><\/p>\n
First stop the mysql service
\n<\/strong><\/p>\n
\n
# \/etc\/init.d\/mysql stop<\/span><\/pre>\n<\/blockquote>\n
Make sure all the mysql processes are stopped by executing the killall command<\/p>\n
\n
# killall -9 mysqld<\/span><\/pre>\n<\/blockquote>\n
Next, start mysql is safe mode i.e. the privileges will be skipped while connecting to the mysql server<\/p>\n
\n
# \/usr\/bin\/mysqld_safe --skip-grant-tables &<\/span><\/pre>\n<\/blockquote>\n
now, connect to your Mysql prompt using the ‘mysql’ command<\/p>\n
\n
# mysql<\/span>\r\n Welcome to the MySQL monitor. Commands end with ; or \\g.<\/span>\r\n Your MySQL connection id is 23056<\/span>\r\n mysql><\/span><\/pre>\n<\/blockquote>\n
Goto the ‘mysql’ database<\/p>\n
\n
mysql> use mysql;<\/span><\/pre>\n<\/blockquote>\n
Now set a password for user ‘root’<\/p>\n
\n
mysql> update user set password=PASSWORD(\"passhere\") where user='root';<\/span><\/pre>\n<\/blockquote>\n
OR you can also set a blank password for user ‘root’<\/p>\n
\n
mysql> update user set password=PASSWORD(\"\") where user='root';<\/span><\/pre>\n<\/blockquote>\n
Once done, reload privileges and quit<\/p>\n
\n
mysql> flush privileges;<\/span>\r\nmysql> quit<\/span><\/pre>\n<\/blockquote>\n
Now, restart the mysql service<\/p>\n
\n
# \/etc\/init.d\/mysql restart<\/span><\/pre>\n<\/blockquote>\n
and you should be able to connect to your mysql server:<\/p>\n
\n
# mysql<\/span>\r\nOR\r\n# mysql -uroot -p<\/span><\/pre>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"
You may receive the “Access denied for user ‘root’@’localhost’” message while accessing mysql from the command prompt.
\nThe error message states that the Mysql password for user ‘root’ is incorrect and need to reset the password using the skip-grant-tables method.<\/p>\n
ERROR 1045 (28000): Access denied for user ‘root’@’localhost’
\n(using password: NO)<\/p>\n
How to reset root Mysql password in Linux?
\nFirst stop the mysql service<\/p>\n
# \/etc\/init.d\/mysql stop<\/p>\n
Make sure all the mysql processes are stopped by executing the killall command<\/p>\n
# killall -9 mysqld<\/p>\n
Next, start mysql is safe mode i.e. the privileges will be skipped […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[111],"tags":[742,744,745,1487,746],"_links":{"self":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts\/561"}],"collection":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/comments?post=561"}],"version-history":[{"count":10,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts\/561\/revisions"}],"predecessor-version":[{"id":2177,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts\/561\/revisions\/2177"}],"wp:attachment":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/media?parent=561"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/categories?post=561"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/tags?post=561"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}