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@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.