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