Dear Glyndower,
All remote db connections are blocked so
This says it! You are not allowed to connect to the database server
from anywhere else but from localhost.
Try:
GRANT ALL ON *.* TO me_as_odbc_user@% IDENTIFIED BY my_password
This will grant access to me_as_odbc_user from everywhere
This is the email I recieved from tech support of the host i'm using, in
reference to using MyOdbcand MyAccess to connect from Access on a windoze
machine to MySql on a unix machine.
All remote db connections are blocked so
phpmyadmin or using ssh to connection (secure telnet) is the two