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

book

Article ID: 51857

calendar_today

Updated On:

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.