bad path in bash

[Walton Hoops]

Whoops! Sorry for no subject in original message!

From: ubuntu-users-bounces at lists.ubuntu.com
[mailto:ubuntu-users-bounces at lists.ubuntu.com] On Behalf Of Walton Hoops
Sent: Monday, March 23, 2009 12:44 PM
To: ubuntu-users at lists.ubuntu.com
Subject: 

OK wise Ubuntu’ers.
So I’ve built MySQL from source as the version in the repository does not
support partitioning.  Got it installed, running, all is well and good
.
Until

root at grunt:/usr/local# mysql
bash: /usr/bin/mysql: No such file or directory
root at grunt:/usr/local# which mysql
/usr/local/bin/mysql
root at grunt:/usr/local# ls -l /usr/local/bin/mysql
-rwxr-xr-x 1 root root 340157 2009-03-23 11:48 /usr/local/bin/mysql
root at grunt:/usr/local# /usr/local/bin/mysql --password
Enter password:

Any idea why bash is trying to exec /usr/bin/mysql (which does not exist),
when which says it should be /usr/local/bin/mysql (which does and works)?