[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 127.0.0.1" 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