basic question -linux path..(/usr/bin, /usr/local/bin)

[Paul Howarth]

bruce wrote:

Please don't top-post on this mailing list.

> when i do an
>  #echo $PATH
> /usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/b
> in:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/java/j2sdk1.4.1_02/bin:/opt/condor
> -6.6.6/sbin:/opt/condor-6.6.6/bin:/root/bin
> 
> which says that i have both '/usr/local/bin' and '/usr/bin'.

But crucially, you have the following directories *before* /usr/bin:
/usr/kerberos/sbin
/usr/kerberos/bin
/usr/local/sbin
/usr/local/bin
/sbin
/bin
/usr/sbin

So you are picking up "mysql" from one of those directories by default.

$ which mysql

should tell you where it is.

> when i do
>  #mysql, i get
> -bash: /usr/local/bin/mysql: No such file or directory

You're probably running a script that is expecting to find mysql in 
/usr/local/bin

> however, the mysql file is in the '/usr/bin' dir, and if i do
>  #/usr/bin/mysql, mysql runs....
> 
> the '/usr/bin/my*' dir is:
> [root at lserver2 /]# ls /usr/bin/my*
> /usr/bin/myisamchk                   /usr/bin/mysqld_multi
> /usr/bin/myisamlog                   /usr/bin/mysqldump
> /usr/bin/myisampack                  /usr/bin/mysqldumpslow
> /usr/bin/my_print_defaults           /usr/bin/mysql_find_rows
> /usr/bin/mysql                       /usr/bin/mysql_fix_privilege_tables
> /usr/bin/mysqlaccess                 /usr/bin/mysqlhotcopy
> /usr/bin/mysqladmin                  /usr/bin/mysqlimport
> /usr/bin/mysqlbinlog                 /usr/bin/mysql_install_db
> /usr/bin/mysqlbug                    /usr/bin/mysql_setpermission
> /usr/bin/mysqlcheck                  /usr/bin/mysqlshow
> /usr/bin/mysql_config                /usr/bin/mysqltest
> /usr/bin/mysql_convert_table_format  /usr/bin/mysql_zap
> 
> any ideas as to how to get mysql to run from the command line..??

Find out where you're currently getting "mysql" from (see the "which" 
command above) and investigate why that command is present in that 
directory. Is it a script? How did it get there?

Paul.