OK, scratch that, I was being stupid. I had two ODBC configuration dialogs
open and they must have been conflicting.
Another question though, during the ODBC config, I noticed I could pick
either the caddb for which the account had access or "information_schema"
for which I had not explicitly
I want to add a user who can login from anywhere but has restricted
privileges on a single DB.
I tried:
GRANT SELECT, INSERT, UPDATE ONcaddb.* TO 'autocad'@'%' IDENTIFIED BY
'password';
The query ran and the user was entered with the proper privileges, however,
when I tried to setup an ODBC
