{"id":11,"date":"2006-05-04T20:10:38","date_gmt":"2006-05-05T01:10:38","guid":{"rendered":"http:\/\/www.onvural.net\/melih\/wordpress\/?p=6"},"modified":"2006-05-04T20:10:38","modified_gmt":"2006-05-05T01:10:38","slug":"mysql-startup-error-2002-hy000","status":"publish","type":"post","link":"https:\/\/www.onvural.net\/melih\/thoughts\/2006\/05\/04\/mysql-startup-error-2002-hy000\/","title":{"rendered":"MySQL: Startup Error 2002 (HY000)"},"content":{"rendered":"<p>I installed MySQL 5.0 on my MacBook Pro and got the following error when I tried starting the server after a computer restart:<\/p>\n<p><em>ERROR 2002 (HY000): Can&#8217;t connect to local MySQL server through socket &#8216;\/tmp\/mysql.sock&#8217; (2)<\/em><\/p>\n<p>It turns out that others were having this problem, and I wanted to go ahead and post the solution that I found to work the best:<\/p>\n<p>Type the following commands into a Terminal window:<br \/>\n<em><br \/>\n$ cd \/usr\/local\/mysql<br \/>\n$ sudo .\/scripts\/mysql_install_db &#8211;rpm<br \/>\n$ sudo chown -R mysql data<br \/>\n<\/em><\/p>\n<p>Note that the line \/usr\/local\/mysql is looking for the symlink at which your MySQL installation points. I pointed mine to \/Library\/MySQL and changed the line appropriately for my setup. After this, make sure you set the root password to access MySQL, and you should be all set.\n<\/p>\n<p>\n<font size=\"-3\"><em>*Note* I haven&#8217;t investigated this all the way through yet, but I now have to start using <\/p>\n<p>myqld_safe &#8211;skip-grant &amp;<\/p>\n<p>as my daemon starting command. I will research this to understand what&#8217;s going on, and update this entry.<\/em><\/font><\/p>\n<p>\n","protected":false},"excerpt":{"rendered":"<p>I installed MySQL 5.0 on my MacBook Pro and got the following error when I tried starting the server after a computer restart: ERROR 2002 (HY000): Can&#8217;t connect to local MySQL server through socket &#8216;\/tmp\/mysql.sock&#8217; (2) It turns out that others were having this problem, and I wanted to go ahead and post the solution [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false},"categories":[2,1],"tags":[],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pQyAq-b","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":81,"url":"https:\/\/www.onvural.net\/melih\/thoughts\/2007\/12\/27\/installing-dbdmysql-on-os-x-10411\/","url_meta":{"origin":11,"position":0},"title":"Installing DBD::mysql on OS X (10.4.11)","date":"December 27, 2007","format":false,"excerpt":"I was trying to get Bugzilla installed to act as my task manager on my local machine. It's a new project that I'm trying out as part of my New Year's Resolution of spending two hours everyday on a project of my own choice. It will help me to be\u2026","rel":"","context":"In &quot;Technology&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":255,"url":"https:\/\/www.onvural.net\/melih\/thoughts\/2010\/02\/08\/another-bug-bites-the-dust\/","url_meta":{"origin":11,"position":1},"title":"Another bug bites the dust","date":"February 8, 2010","format":false,"excerpt":"I've been working on an interesting project lately that I hope to share with everyone soon. I keep running into the oddest of problems trying to get things going. It's almost as if just getting the whole thing started is the biggest challenge. After that... it's going to be a\u2026","rel":"","context":"In &quot;Technology&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":85,"url":"https:\/\/www.onvural.net\/melih\/thoughts\/2008\/02\/21\/chronicling-my-visualizaton-project-start-with-an-error\/","url_meta":{"origin":11,"position":2},"title":"Chronicling My Visualizaton Project - Start with an error","date":"February 21, 2008","format":false,"excerpt":"It seems that you can't claim that a project has started until there is a bug of some sort that has nothing to do with any code that you have written. In fact, it's a bug in you setting up your system, which often tends to convince folks that the\u2026","rel":"","context":"In &quot;School Year 07-08&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":10,"url":"https:\/\/www.onvural.net\/melih\/thoughts\/2006\/04\/27\/installing-tomcat-5517-and-mod_jk-125-on-apache-13-for-mac-os-104\/","url_meta":{"origin":11,"position":3},"title":"Installing Tomcat 5.5.17 and Mod_Jk 1.2.5 on Apache 1.3 for Mac OS 10.4","date":"April 27, 2006","format":false,"excerpt":"I've seen a general lack of content on the latest versions of Tomcat and how to install it on the Mac operating system. This is really frustrating when you don't know what you're doing, and you just need some help. After compiling a bunch of how-tos into my memory, I\u2026","rel":"","context":"In &quot;Technology&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.onvural.net\/melih\/thoughts\/wp-json\/wp\/v2\/posts\/11"}],"collection":[{"href":"https:\/\/www.onvural.net\/melih\/thoughts\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.onvural.net\/melih\/thoughts\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.onvural.net\/melih\/thoughts\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.onvural.net\/melih\/thoughts\/wp-json\/wp\/v2\/comments?post=11"}],"version-history":[{"count":0,"href":"https:\/\/www.onvural.net\/melih\/thoughts\/wp-json\/wp\/v2\/posts\/11\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.onvural.net\/melih\/thoughts\/wp-json\/wp\/v2\/media?parent=11"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.onvural.net\/melih\/thoughts\/wp-json\/wp\/v2\/categories?post=11"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.onvural.net\/melih\/thoughts\/wp-json\/wp\/v2\/tags?post=11"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}