How to restore mysql root password on Linux when you forget password? This task will be very simple if you follow the steps in this article.<\/p>\n
Step 1<\/strong> : Stop MySQL Server Service service mysqld stop<\/p><\/blockquote>\n Step 2<\/strong> : Restart MySQL Server without password<\/p>\n mysqld_safe –skip-grant-tables &<\/p><\/blockquote>\n After you run the command above, you enter to continue running other commands<\/p>\n [root@server ~]# 180531 10:57:35 mysqld_safe Logging to ‘\/var\/log\/mysqld.log’. Step 3<\/strong> : Connect MySQL Server via MySQL client<\/p>\n mysql -u root<\/p><\/blockquote>\n [root@server ~]# mysql -u root Copyright (c) 2000, 2013, Oracle and\/or its affiliates. All rights reserved.<\/p>\n Oracle is a registered trademark of Oracle Corporation and\/or its Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the current input statement.<\/p>\n mysql><\/p><\/blockquote>\n Step 4<\/strong>: Set\u00a0 new password MySQL Server for user root<\/p>\n USE mysql; Reading table information for completion of table and column names Database changed mysql> flush privileges; mysql> quit Step 5<\/strong> : Restart MySQL Server<\/p>\n service mysqld restart<\/p><\/blockquote>\n Step 6<\/strong> : Recheck new password of user root<\/p>\n mysql -u root -p<\/p><\/blockquote>\n Now you completely reset password for Mysql. How to restore mysql root password on Linux when you forget password? This task will be very simple if you follow the steps in this article. Step 1 : Stop MySQL Server Service You run this command to stop MySQL Server on linux service mysqld stop Step 2 : Restart MySQL Server without password mysqld_safe […]<\/p>\n","protected":false},"author":1,"featured_media":533,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7],"tags":[65,86,85],"_links":{"self":[{"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/posts\/60"}],"collection":[{"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/comments?post=60"}],"version-history":[{"count":5,"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/posts\/60\/revisions"}],"predecessor-version":[{"id":532,"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/posts\/60\/revisions\/532"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/media\/533"}],"wp:attachment":[{"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/media?parent=60"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/categories?post=60"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/tags?post=60"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nYou run this command to stop MySQL Server on linux<\/p>\n
\n180531 10:57:35 mysqld_safe Starting mysqld daemon with databases from \/var\/lib\/mysql<\/p><\/blockquote>\n
\nWelcome to the MySQL monitor. Commands end with ; or \\g.
\nYour MySQL connection id is 2
\nServer version: 5.1.73 Source distribution<\/p>\n
\naffiliates. Other names may be trademarks of their respective
\nowners.<\/p>\n
\nUPDATE user set password=PASSWORD(“NEW-ROOT-PASSWORD”) WHERE User=”root”;
\nflush privileges;
\nquit
\nmysql> USE mysql;
\nNo connection. Trying to reconnect…
\nConnection id: 3
\nCurrent database: *** NONE ***<\/p>\n
\nYou can turn off this feature to get a quicker startup with -A<\/p>\n
\nmysql> UPDATE user set password=PASSWORD(“NEW-ROOT-PASSWORD”) WHERE User=”root”;
\nQuery OK, 3 rows affected (0.01 sec)
\nRows matched: 3 Changed: 3 Warnings: 0<\/p>\n
\nQuery OK, 0 rows affected (0.00 sec)<\/p>\n
\nBye
\n[root@server ~]#<\/p><\/blockquote>\n
\nGood luck!<\/p>\n","protected":false},"excerpt":{"rendered":"