tag:blogger.com,1999:blog-4650152229438238529.post2737408976855174645..comments2023-12-18T15:51:40.714+01:00Comments on OBSCURED CLARITY: Install MySQL on Mac OS XTim Molterhttp://www.blogger.com/profile/09117791052747688044noreply@blogger.comBlogger46125tag:blogger.com,1999:blog-4650152229438238529.post-7813076420465604302016-09-15T09:59:24.930+02:002016-09-15T09:59:24.930+02:00Awesome post, thank you!Awesome post, thank you!Deannoreply@blogger.comtag:blogger.com,1999:blog-4650152229438238529.post-68095632401173132222013-06-06T16:17:12.535+02:002013-06-06T16:17:12.535+02:00Great, friend. thank you very much. It works prop...Great, friend. thank you very much. It works properly...Alessandro Marloshttp://www.globalead.com.brnoreply@blogger.comtag:blogger.com,1999:blog-4650152229438238529.post-77943139602374564252012-10-12T14:21:58.789+02:002012-10-12T14:21:58.789+02:00@ everyone getting and error 2002, See my update t...@ everyone getting and error 2002, See my update to this article under the section titled: "Note about error 2002 people are reporting!". The problem is most likely that MySQL is not running.Tim Molterhttps://www.blogger.com/profile/09117791052747688044noreply@blogger.comtag:blogger.com,1999:blog-4650152229438238529.post-47944292588334998892012-09-13T17:55:39.363+02:002012-09-13T17:55:39.363+02:00I am getting error a step 6-
ERROR 2002 (HY000): C...I am getting error a step 6-<br />ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)<br /><br />can you pl suggestsolution for it.<br /><br />thanks,<br />katieAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4650152229438238529.post-20872920746693502102012-08-25T16:43:20.664+02:002012-08-25T16:43:20.664+02:00Thank you for the very simple instructions! I maki...Thank you for the very simple instructions! I making my first ever server app, am on a tight deadline, and your post really helped. Thanks again!Rohitnoreply@blogger.comtag:blogger.com,1999:blog-4650152229438238529.post-18875470095309478642012-08-16T17:11:48.160+02:002012-08-16T17:11:48.160+02:00Helpful even almost 3 years later. The one thing I...Helpful even almost 3 years later. The one thing I think you are missing is the installation of MySQLStartupItem.pkg. This caused the following error to occur when I tried to connect as the root user : Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2). MySQLStartupItem.pkg can be found in the MySQL package installer, which is provided on a disk image (.dmg). Open the package/image with the appropriate tool ( e.g. right click on the image to use the DiskImageMounter default utility on Mac or Alcohol120 on Windows) and then double click on MySQLStartupItem.pkg. After a successful installation of MySQLStartupItem.pkg, run sudo /Library/StartupItems/MySQLCOM/MySQLCOM start on Mac. You should be able to connect as a root user after that.Anonymoushttps://www.blogger.com/profile/16817504078674320767noreply@blogger.comtag:blogger.com,1999:blog-4650152229438238529.post-50966174111425047662012-08-16T06:51:12.190+02:002012-08-16T06:51:12.190+02:00Great help man !! Thanks a lot!!!Great help man !! Thanks a lot!!!makshttps://www.blogger.com/profile/16883083867972304480noreply@blogger.comtag:blogger.com,1999:blog-4650152229438238529.post-72697943204671867242012-05-24T22:49:17.777+02:002012-05-24T22:49:17.777+02:00Worked Fine! Very good tutorial, thanks man!Worked Fine! Very good tutorial, thanks man!H_A_noreply@blogger.comtag:blogger.com,1999:blog-4650152229438238529.post-14294730557718174602011-11-29T22:37:35.128+01:002011-11-29T22:37:35.128+01:00Thanks a lot! Very helpful post :)Thanks a lot! Very helpful post :)Harrishttps://www.blogger.com/profile/01302603033485945996noreply@blogger.comtag:blogger.com,1999:blog-4650152229438238529.post-48479337926168093922011-11-24T22:36:13.180+01:002011-11-24T22:36:13.180+01:00OMG. Thank you so much!
And it really IS a piece...OMG. Thank you so much!<br />And it really <b> IS </b> a piece o' cake!<br /><br />After following your steps, I had a problem (in Step 6): <br />Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) <br /><br />Google then helped me:<br />https://discussions.apple.com/thread/1053234?start=0&tstart=0<br /><br />Just citing to help anyone with this problem, as I think this is simpler than what you had posted. <br />And once again, thanks a lot Tim!safhttps://www.blogger.com/profile/00332909911961536561noreply@blogger.comtag:blogger.com,1999:blog-4650152229438238529.post-80305143354141473862011-06-14T16:12:48.162+02:002011-06-14T16:12:48.162+02:00Thank you so much!Thank you so much!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4650152229438238529.post-76576591247513794992011-05-02T20:06:24.552+02:002011-05-02T20:06:24.552+02:00@Ankit Sorry, I never ran into that problem so I c...@Ankit Sorry, I never ran into that problem so I can't give you any advice. Good luck!Tim Molterhttps://www.blogger.com/profile/09117791052747688044noreply@blogger.comtag:blogger.com,1999:blog-4650152229438238529.post-8886120633312999232011-05-02T18:45:33.352+02:002011-05-02T18:45:33.352+02:00Hi Tim
I installed and uninstalled MySQL followin...Hi Tim<br /><br />I installed and uninstalled MySQL following the above instruction million times but it never works for me, not i gave up and really need to install that on my mac, ned your advice and help.<br /><br />when i am trying to run mysql from terminal i keep getting error:<br />Command i am firing:<br />/usr/local/mysql/bin/mysql -u root -p <br />error:<br />~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<br />ERROR! Manager of pid-file quit without updating file<br />~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<br /><br /><br />I downloaded the mysql from mysql.com, my mac version is Mac OS X 10.6, do you think is that the problem ?Ankit Jainhttps://www.blogger.com/profile/01163115292668990756noreply@blogger.comtag:blogger.com,1999:blog-4650152229438238529.post-42957991386998845052011-04-07T02:30:12.682+02:002011-04-07T02:30:12.682+02:00Amazing.. just it! everything here seems easyAmazing.. just it! everything here seems easyRadu kabalahhttps://www.blogger.com/profile/04323759561347372784noreply@blogger.comtag:blogger.com,1999:blog-4650152229438238529.post-41900610058835633392011-02-09T23:11:28.694+01:002011-02-09T23:11:28.694+01:00mat, I don't know exactly what's up with t...mat, I don't know exactly what's up with that. I think I just clicked on "restore" or "fix" or something to that order, and then restarted and everything worked fine.Tim Molterhttps://www.blogger.com/profile/09117791052747688044noreply@blogger.comtag:blogger.com,1999:blog-4650152229438238529.post-18470201608610581342011-02-03T10:07:14.141+01:002011-02-03T10:07:14.141+01:00Hi Tim,
thank you for the tutorial.
I`m trying aga...Hi Tim,<br />thank you for the tutorial.<br />I`m trying again to install mysql-5.5.8-osx10.6-x86_64 on 10.6.6 but when I restart a message appears: "startupitems/MySQLCOM doesn`t have the proper security settings to run" (maybe bed translation from italian).<br />Do you have any idea about that problem ?<br /><br />Thank you<br /><br />mat (from Tokyo)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4650152229438238529.post-30685907871516587732010-12-25T22:14:03.467+01:002010-12-25T22:14:03.467+01:00This worked like a charm. I have been trying to fo...This worked like a charm. I have been trying to follow the Mysql documentation and for some reason it never worked for me.<br /><br />Thanks a ton.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4650152229438238529.post-24986512807958007832010-12-10T18:54:40.256+01:002010-12-10T18:54:40.256+01:00musicman432, sorry, I don't know.musicman432, sorry, I don't know.Tim Molterhttps://www.blogger.com/profile/09117791052747688044noreply@blogger.comtag:blogger.com,1999:blog-4650152229438238529.post-64956686820682644642010-12-08T22:30:30.833+01:002010-12-08T22:30:30.833+01:00Hey, is there a place I can download a package for...Hey, is there a place I can download a package for a G4 PPC Mac?<br /><br />Thanks,<br />musicman432musicman432https://www.blogger.com/profile/07979708671968142655noreply@blogger.comtag:blogger.com,1999:blog-4650152229438238529.post-77547486404349315472010-09-13T18:09:50.968+02:002010-09-13T18:09:50.968+02:00Teddi, sorry, I don't have any advice for your...Teddi, sorry, I don't have any advice for your problem.Tim Molterhttps://www.blogger.com/profile/09117791052747688044noreply@blogger.comtag:blogger.com,1999:blog-4650152229438238529.post-74348819747277327582010-09-13T01:27:56.950+02:002010-09-13T01:27:56.950+02:00I hope you're still watching this blog. My pro...I hope you're still watching this blog. My problem is mysql used to work on my Mac SnowLeopard, until I got back from vacation. Now I only have the mysql-5.1.47-osx10.6-x86 version, not the "mysql" alias, so I can't get the server to start. I don't want to lose all the databases I've set up (with several tables each) using Workbench. I'd uninstall it but for that. Is there a way I can make an alias of mysql-5.1.47-osx10.6-x86? I've tried but no luck.<br />Thanks,<br />Tedditbearhttps://www.blogger.com/profile/01645714008932191771noreply@blogger.comtag:blogger.com,1999:blog-4650152229438238529.post-89885096147536201622010-07-18T20:00:28.429+02:002010-07-18T20:00:28.429+02:00Steve, Thanks for the heads up!Steve, Thanks for the heads up!Tim Molterhttps://www.blogger.com/profile/09117791052747688044noreply@blogger.comtag:blogger.com,1999:blog-4650152229438238529.post-87301834021562475732010-07-18T15:16:42.784+02:002010-07-18T15:16:42.784+02:00Just a note that this doesn't work on 10.6 if ...Just a note that this doesn't work on 10.6 if running on an older macbook pro, eg from 2007. See http://bugs.mysql.com/bug.php?id=54718<br /><br />I have no idea why because these instructions are correct for newer models. I have been battling with this for ages :(Steve Swinsburghttps://www.blogger.com/profile/06666785930294112797noreply@blogger.comtag:blogger.com,1999:blog-4650152229438238529.post-51339324701700743812010-06-27T12:38:46.386+02:002010-06-27T12:38:46.386+02:00Hi Chris,
I don't see a security issue in the...Hi Chris,<br /><br />I don't see a security issue in the way that I install MySQL. All I show here is how to install it and verify that it's working logging in with the default root user. Of course, configuring MySQL to be secure is a wise thing to do if you're going to be using it in the public domain. But that's outside the scope of this particular article.Tim Molterhttps://www.blogger.com/profile/09117791052747688044noreply@blogger.comtag:blogger.com,1999:blog-4650152229438238529.post-14260361225675411832010-06-25T20:50:56.104+02:002010-06-25T20:50:56.104+02:00I am no expert here, but as far as I can see there...I am no expert here, but as far as I can see there is a security issue with your approach. When installing MySQL as you described, the database will end up running as the Administrator user and having its privileges - which is not desired.<br /><br />You should use the chown and chgroup commands to reassign the files to another user account (e.g. create a "mysqluser" account with standard privileges only). You can find other manuals on the web on this and it seems to be recommended.<br /><br />But thanks nonetheless for your article (and the other articles too).Anonymousnoreply@blogger.com