SPECTRUM: Error when logging into mysql from the $SPECROOT/mysql/bin directory on Solaris and Linux (Legacy KB ID CNC TS29632 )

Document ID : KB000051857
Last Modified Date : 14/02/2018
Show Technical Document Details
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

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

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 6 to server version: 5.0.26-pro

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.


Related Issues/Questions:
Receiving 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)

Problem Environment:

Causes of this problem:
mysql is unable to find the my-spectrum.cnf file

(Legacy KB ID CNC TS29632 )