With my server this resulted in not returning to the command prompt. Press “Enter” to get the command prompt again.
\nThen open up mysql for a mysql prompt<\/p>\n
mysql -u root -p<\/p><\/blockquote>\n
Which should result in a mysql> command prompt<\/p>\n
From the original post this next command appears redundant on Ubuntu so skip this one. mysql client – mysql -u root<\/em><\/p>\nThe next command is done at the mysql prompt and again I differ from the original post<\/p>\n
use mysql;<\/p><\/blockquote>\n
Note the semi-colon to complete the command. If you do copy and paste the two lines successfully then skipping the semi-colon on the first line is ok, but I like most people will initially try to do it a line at a time so I think it is clearer to execute as a sequence.<\/p>\n
The next command sets up your new password and you need to edit this line with your new password and your relevant user account name.<\/p>\n
update user set password=PASSWORD(\u201dNEW-ROOT-PASSWORD\u201d) where User=\u2019root\u2019;<\/p><\/blockquote>\n
Ok, so now you possibly have an error. Depending on the way you held your lips you may or may not have the correct syntax copied to your command line. I am not sure if this is consistent with all browsers and all telnet clients but I use PuTTy and when I copy\/paste the above from the original thread I get this<\/p>\n
update user set password=PASSWORD(.NEW-ROOT-PASSWORD.) where User=.root.;<\/p><\/blockquote>\n
Note that the quote marks in the command were converted to a ‘.’ (period) character and when I hit the enter key I got an error<\/p>\n
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1<\/p><\/blockquote>\n
So if you check your syntax and make sure you have the quotes correctly placed then it will work fine.<\/p>\n
Finish up by closing the mysql command line with ‘exit’ and stop \/ start mysql to get it to use passwords again.<\/p>\n
\/etc\/init.d\/mysql stop<\/p><\/blockquote>\n
\/etc\/init.d\/mysql start<\/p><\/blockquote>\n
And that should get your account running again.<\/p>\n","protected":false},"excerpt":{"rendered":"
Changing the MySQL root password when you cannot recall what it was.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,10],"tags":[68],"class_list":["post-190","post","type-post","status-publish","format-standard","hentry","category-linux-servers-and-software","category-mysql","tag-mysql-root-password-fails-forgotten"],"_links":{"self":[{"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/posts\/190","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/comments?post=190"}],"version-history":[{"count":0,"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/posts\/190\/revisions"}],"wp:attachment":[{"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/media?parent=190"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/categories?post=190"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howden.net.au\/thowden\/wp-json\/wp\/v2\/tags?post=190"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}