path in environment variable PATH, but command still not found

Question

I am working with a Redhat distribution. Mysql is installed with the binary in the following path:

/root/opt/rh/mysql55/root/usr/bin/mysql

Furthermore, the environmental variable PATH echos:

echo $PATH
/root/opt/rh/mysql55/root/usr/bin/mysql:/usr/lib64/qt-3.3/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/root/opt/rh/mysql55/root/usr/bin/mysql

The server has been restarted but if I type

mysql

into bash it returns the following:

# mysql -u root
-bash: mysql: command not found

Please advise

EDIT

Altered PATH EV to

/root/opt/rh/mysql55/root/usr/bin

using

export  mysql /opt/rh/mysql55/root/usr/bin
export  PATH  ${mysql}:${PATH}

Still get command not found

After rebooting the server, echo $PATH is now:

/usr/lib64/qt-3.3/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin

So, the path to mysql is gone.

Run /root/opt/rh/mysql55/root/usr/bin/mysql -u root, what is the result? — Braiam, Jul 21 '14 at 19:38
If I fully qualify the path for mysql, then the client utility starts. — Roy Hinkley, Jul 21 '14 at 20:04
Why is it installed in root's subdir? Most users (including the mysql user) cannot read or search in root's subdir. Probably works when you type the path yourself since you're already root. Your directory structure implies it would work just dandy in /opt/rh/... ... move it there, make owned by mysql:mysql and be done with it. — lornix, Jul 22 '14 at 05:59

score 7 · Accepted Answer · answered Jul 21 '14 at 19:27

7

You should add only the path, not the mysql executable itself. PATH is list of directories, not files.

Try adding:

/root/opt/rh/mysql55/root/usr/bin/

answered Jul 21 '14 at 19:27

cuonglm

153,898

i changed it but it still gives me the same error. – Roy Hinkley Jul 21 '14 at 19:38
@AndroidAddict: Did you add to PATH of your user? Can you give output locate bin/mysql? – cuonglm Jul 21 '14 at 19:39
I don't think so. I don't know what that means? – Roy Hinkley Jul 21 '14 at 19:41
@AndroidAddict: What ouput when you run locate bin/mysql? – cuonglm Jul 21 '14 at 19:43
Command not found – Roy Hinkley Jul 21 '14 at 19:43
I just rebooted the server and echoed $PATH. Now, the path to mysql is gone! How do I make it permanent? – Roy Hinkley Jul 21 '14 at 19:44
Add the line to your .bashrc, refer to this: http://unix.stackexchange.com/questions/26047/how-to-correctly-add-a-path-to-path – cuonglm Jul 21 '14 at 19:44
Would you please help me find it? might I use find / -name .bachrc type -f ? – Roy Hinkley Jul 21 '14 at 19:46
It is located in /home/youruser/.bashrc – cuonglm Jul 21 '14 at 19:48
Okay, I am in home folder for root and I don't see that file. – Roy Hinkley Jul 21 '14 at 19:49
Just create it. You should read man bash to see more details. – cuonglm Jul 21 '14 at 19:54
Okay, I created .bashrc in my home user directory. I still get command not found. I have rebooted and echoed PATH and the path to mysql is still not in PATH. – Roy Hinkley Jul 21 '14 at 20:07
run echo -e "PATH=$PATH:/root/opt/rh/mysql55/root/usr/bin/\nexport PATH" >> ~/.bashrc – dchirikov Jul 21 '14 at 20:09
@dchirikov now I cannot use mysql at all, even from the directory. Please advise – Roy Hinkley Jul 21 '14 at 20:29
execute PATH=/root/opt/rh/mysql55/root/usr/bin/mysql:/usr/lib64/qt-3.3/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/root/opt/rh/mysql55/root/usr/bin/mysql; export PATH – dchirikov Jul 21 '14 at 20:42
Why is /root/opt/rh/mysql55/root/usr/bin/mysql in there twice? – Roy Hinkley Jul 21 '14 at 20:55

path in environment variable PATH, but command still not found

1 Answers1