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)
Release: Any version of Spectrum installed on Linux or Solaris
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.