SPECTRUM: Error when logging into mysql from the $SPECROOT/mysql/bin directory on Solaris and Linux

Article Id: 51857

Status: Published

Updated On: 03-02-2020 07:26

Legacy Id: TEC517808

Products:

Issue/Introduction:

SPECTRUM: Error when logging into mysql from the $SPECROOT/mysql/bin directory on Solaris and Linux

ERROR:ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Environment:

Release: Any version of Spectrum installed on Linux or Solaris
Component:

Resolution:

The my-spectrum.cnf file is located in the $SPECROOT/mysql directory. To resolve the issue, login into mysql from the $SPECROOT/mysql/bin directory using the following command:

./mysql --defaults-file=../my-spectrum.cnf -uroot -proot

NOTE: This command can also be used from a bash shell on a Spectrum install on Windows.