[GRLUG] sugarcrm/mysql issue

[David van Geest]

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
> 127.0.0.1').
>
> (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

<snip>

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 127.0.0.1" I suspect it would work as well.

-David

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