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

150,973
38
327
406

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