{"id":59,"date":"2003-06-29T16:20:34","date_gmt":"2003-06-29T21:20:34","guid":{"rendered":"http:\/\/ywwg.com\/wordpress\/?p=59"},"modified":"2005-10-17T11:21:37","modified_gmt":"2005-10-17T16:21:37","slug":"tip-mysql-rejecting-access","status":"publish","type":"post","link":"https:\/\/ywwg.com\/wordpress\/archives\/59","title":{"rendered":"tip:  mysql rejecting access"},"content":{"rendered":"<p>problem:  mysql rejects access no matter what you do<br \/>\n<!--more--><br \/>\nsolution, I think:<br \/>\nshut down mysql<br \/>\n<code><br \/>\nrun \/usr\/bin\/safe_mysqld --skip-grant-tables<br \/>\nmysql -u root --host=localhost mysql<br \/>\nUPDATE user SET Password=PASSWORD('mynewpassword')  WHERE User='root';<br \/>\nafter that<br \/>\nGRANT ALL ON *.* TO user@localhost IDENTIFIED BY \"\";<br \/>\n<\/code><br \/>\nseemed to work.<br \/>\nI think it was the host field<\/p>\n","protected":false},"excerpt":{"rendered":"<p>problem: mysql rejects access no matter what you do<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[],"_links":{"self":[{"href":"https:\/\/ywwg.com\/wordpress\/wp-json\/wp\/v2\/posts\/59"}],"collection":[{"href":"https:\/\/ywwg.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ywwg.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ywwg.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ywwg.com\/wordpress\/wp-json\/wp\/v2\/comments?post=59"}],"version-history":[{"count":0,"href":"https:\/\/ywwg.com\/wordpress\/wp-json\/wp\/v2\/posts\/59\/revisions"}],"wp:attachment":[{"href":"https:\/\/ywwg.com\/wordpress\/wp-json\/wp\/v2\/media?parent=59"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ywwg.com\/wordpress\/wp-json\/wp\/v2\/categories?post=59"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ywwg.com\/wordpress\/wp-json\/wp\/v2\/tags?post=59"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}