I have following alias and it is working as expected.
alias mysql='LD_LIBRARY_PATH=/usr/local//mysql/lib/:/usr/local//mysql/lib//mysql /usr/local//mysql/bin//mysql'
My question is there are a few other commands like mysqldump , mysqladmin those needs to be linked as well. How to I let the shell prompt know where to look for mysql command without using alias?
This is an issue only on one server where cluster is installed. On all other servers I can type "mysql" or "mysqladmin".