MySQL on Mac OS X

[sydneystephen]

I have installed Sugar using the Mac OS X installer for version 4.50f with whichever version of MySQL this installer includes. Sugar runs fine and i have imported data and added new customer fields.

I have now installed the GUI tool for MySQL but I cannot connect to the server. I am using the correct root password but i always get the error:

Could not connect to MySQL instance at localhost.
Error: Can't connect tto local MySQL server through soket '/tmp/mysql.sock' (2) (code 2002)

If i ping the host i get the appropriate responses.

The GUI tools are for version 5. I have no idea how to find out what version is installed - the installer doesnt come with any notes as far as i can see...

update: There are a number of posts suggesting that the default socket created on OS X is /tmp/mysql.sock and PHP looks for the socket at /var/mysql/mysql.sock. However in my php.ini file there is a line:

mysql.default_socket = /Applications/sugarcrm-4.5.0f/mysql/tmp/mysql.sock

And when I specify this socket name in the GUI Tools startup screen, waddayouknow, it works.

[cywolf]

That other default socket value refers to the one used by the standard MySQL distribution (the one from mysql.com). It seems like you're probably running the BitRock packaged installer which includes pre-configured Apache, PHP, MySQL and SugarCRM applications. A fresh installation of OS X already has Apache and PHP, so using the BitRock package isn't the only route for setting up SugarCRM.

[ridruejo]

The GUI tools are for version 5. I have no idea how to find out what version is installed - the installer doesnt come with any notes as far as i can see...

update: There are a number of posts suggesting that the default socket created on OS X is /tmp/mysql.sock and PHP looks for the socket at /var/mysql/mysql.sock. However in my php.ini file there is a line:

mysql.default_socket = /Applications/sugarcrm-4.5.0f/mysql/tmp/mysql.sock

And when I specify this socket name in the GUI Tools startup screen, waddayouknow, it works.

Correct, the /var/mysql/mysql.sock is for the default MySQL installation. The one included in the BitRock stack is configured so as not to interfere with the current installation.

Best regards

Daniel