mysql on macbook

Question

Level 1

0 points

mysql on macbook

hello, i have a macbook running mac os x, version 10.6.1. I have apached setup and
am running php as well. I recently downloaded and installed mysql and mysql gui tools.
I tried to connect to mysql via mysql administrator and got the following error:
connection error
could not connect to mysql instance at localhost
error can't connect to local mysql server through socket 'tmp/mysql.sock'(2) (code2002)

I'm a developer and have picked up a mac to begin coding on the mac. I have a VAMP running and
it works great; just want to figure out how to get mysql running on the mac.

thanks

macbook, Mac OS X (10.6.1), i am new to mac

Posted on Oct 8, 2009 4:41 PM

Reply

Answer 1

Miles Xx

Level 1

35 points

Oct 13, 2009 8:00 PM in response to fwsteal

HI,

Im having a similar problem.

However, here are some things I've discovered. If you go to the directory that you're pointing at, there's nothing there.

If you've downloaded and installed the 5.1.x version from MySQL site, then you're probably having the same problem I'm having....PHP sees the 5.0.51 version but not the correct version that you've installed.

Are you running the proper 64bit version or 32 ? It makes a difference. Im running 64 and I can't get PHP to connect.

Further the MySQL admin is a piece of crap! Always has been on the mac. Get Navicat. You'll be happier. You can at least connect to your databases. PHP is a whole other story.

Still another little detail is the date.timezone bug that's now present. Find this line in your PHP.INI file:

;date.timezone =

and uncomment it. Then add your time zone location. http://php.net/manual/en/timezones.php

Hope that helps....

Miles

Reply

Answer 2

Miles Xx

Level 1

35 points

Oct 15, 2009 7:02 PM in response to fwsteal

Hi,

I think I have another piece of the puzzle because I got mine working...

Instead of localhost, supply the loopback address 127.0.0.1 AND the port number of MySQL 3306.

I think that will solve your problem.

Miles.

Reply