{"id":1210,"date":"2019-01-25T16:37:04","date_gmt":"2019-01-25T07:37:04","guid":{"rendered":"http:\/\/kiwamaqs.ddo.jp\/weblog\/?p=1210"},"modified":"2024-02-19T10:06:05","modified_gmt":"2024-02-19T01:06:05","slug":"mysqlsocklock","status":"publish","type":"post","link":"https:\/\/kiwamaqs.com\/weblog\/mysqlsocklock\/","title":{"rendered":"Error upon HighSierra x mysql.sock.lock"},"content":{"rendered":"<p>The errors I met were below.<\/p>\n<p>ERROR 2002 (HY000): Can\u2019t connect to local MySQL server through socket \u2018\/var\/mysql\/mysql.sock'(#2), (38)<br \/>\nOSError: [Errno 13] Permission denied.<br \/>\nThe server quit without updating PID file (\/usr\/local\/var\/mysql\/xxxx.local.pid).<br \/>\n#2002 Failure to login MySQL server.<\/p>\n<p>Finally, I couldn&#8217;t access localhost or failed to connect to Wi-Fi.<br \/>\n(Maybe this has nothing to do with the server error)<\/p>\n<p>It seemed the mysql.sock file was not working.<br \/>\nFirst, I installed the latest version of MySQL(ver 8.1), but it didn&#8217;t work.<br \/>\nThen I uninstalled MYSQL and installed ver 5.7, but it didn&#8217;t work&#8230;<br \/>\nI tried the method that google suggested, but none of them solved my error.<\/p>\n<p>At that time, MYSQL couldn&#8217;t be controlled through system preferences.<br \/>\nWhen installed ver 8.1, the status turns to start and stop in a few seconds.<br \/>\nThen I checked the folder including .sock file, mysql.sock.lock was deleted and appeared every few seconds.<br \/>\nThis .sock file was added after ver 5.7.<br \/>\nSo I installed ver 5.6 which doesn&#8217;t have .sock file, and then everything went smoothly.<br \/>\nSomeone suggests to delete this .sock file, But in my case, I couldn&#8217;t catch the file.<br \/>\nThis is not a fundamental solution, but now my server is working well!!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The errors I met were below. ERROR 2002 (HY000): Can\u2019t connect to local MySQL server through socket \u2018\/var\/mysq [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"_lightning_design_setting":{"layout":"default"},"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1210","post","type-post","status-publish","format-standard","hentry","category-3"],"_links":{"self":[{"href":"https:\/\/kiwamaqs.com\/weblog\/wp-json\/wp\/v2\/posts\/1210","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kiwamaqs.com\/weblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kiwamaqs.com\/weblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kiwamaqs.com\/weblog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/kiwamaqs.com\/weblog\/wp-json\/wp\/v2\/comments?post=1210"}],"version-history":[{"count":4,"href":"https:\/\/kiwamaqs.com\/weblog\/wp-json\/wp\/v2\/posts\/1210\/revisions"}],"predecessor-version":[{"id":2369,"href":"https:\/\/kiwamaqs.com\/weblog\/wp-json\/wp\/v2\/posts\/1210\/revisions\/2369"}],"wp:attachment":[{"href":"https:\/\/kiwamaqs.com\/weblog\/wp-json\/wp\/v2\/media?parent=1210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kiwamaqs.com\/weblog\/wp-json\/wp\/v2\/categories?post=1210"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kiwamaqs.com\/weblog\/wp-json\/wp\/v2\/tags?post=1210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}