Privilege Issue with remote connections

Morning All,

I have a MySQL database with privileges set up for access locally and
from a remote server. Both sets of priviliges use the same username
and password, but define different access (i.e. from the remote server
only select access is allowed, but local access can do everything).
The problem I am seeing seems to involve the remote access privileges
being applied to local connections. The following steps illustrate
the problem:

1. From the remote server, connect to the database using the MySQL
command line (MySQL is installed on that server as well) or via an
ODBC connection.

2. I can run select queries but not updates remotely, as expected (but
I don't actually have to make a query to force the problem - I just
connect and disconnect).

3. Disconnect the remote connection.

4. Connect locally, via ODBC, and try to do an update query - I get
access denied. I can run select queries. If I connect locally direct
to MySQL then the privileges applied are as expected - I can run
update queries.

If I change the username/password of the remote access, everything is
fine, so I assume this is to do with the ODBC driver not being able to
distinguish between the same username/password coming from different
hosts. Maybe its cacheing the privileges from the remote connection
and re-using them for the local one?

Is there anything I can change in the ODBC settings (or MySQL
settings) to make this work, or am I going to have to change my
username/pwd for remote access? I'd like to keep them the same as I
have scripts which can connect locally or remotely and would like to
have them just work..

Thanks,
Al.