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.


mysql>



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:
SPECTRUM 08.01.00.00
SPECTRUM 09.00.00.00
mysql

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


(Legacy KB ID CNC TS29632 )