[GRLUG] sugarcrm/mysql issue

David van Geest david.vangeest at gmail.com
Mon Jun 6 16:02:13 EDT 2011

On Mon, Jun 6, 2011 at 2:58 PM, Eric Beversluis
<ebever at researchintegration.org> wrote:
> Well, for some reason, that worked (using 'mysql -u root -p -h
> (from 'ps -ef |grep mysql*':
> root      3170     1  0 Jun05 ?
> 00:00:00 /bin/sh /opt/sugarcrm-5.5.4/mysql/bin/safe_mysqld --port=3306
> --socket=/opt/sugarcrm-5.5.4/mysql/tmp/mysql.sock --old-passwords


By default, the MySQL client tries to connect using the Unix socket at
it's default location (/tmp/mysql.sock).  Your output shows it's
actually at a different location (/opt/sugarcrm....).

Using the -h parameter forces it to use a TCP/IP connection instead of
a Unix socket connection, so that gets around the changed location of
the Unix socket.

If you were to use "--socket=/opt/sugarcrm-5.5.4/mysql/tmp/mysql.sock"
instead of "-h" I suspect it would work as well.


This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

More information about the grlug mailing list