[GRLUG] sugarcrm/mysql issue

[Eric Beversluis]

THanks to all. 

On Mon, 2011-06-06 at 16:02 -0400, David van Geest wrote:
> 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.