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

[bruce]

hi...

how do i set my environment path? when i try to run mysql (foo>mysql -u
root -p) i get an err, stating that the mysql isn't in the '/usr/local/bin'
dir. however, the mysql is in the '/usr/bin' dir. i would have thought that
this dir would have been searched....

when i do a 'which mysql', it points to the '/usr/bin/mysql'.

if i run '/usr/bin/mysql' mysql works. if i simply run 'mysql' it complains
that it can't find the '/usr/local/bin/mysql'.

any ideas as to what's going on, or what i should change to simply point to
the '/usr/bin' for mysql? i'm not quite sure if i even need the
'/usr/local/bin' mysql files...

thanks

bruce
bedouglas at earthlink.net