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

Products

• CA Spectrum

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.