security - No access to tables remote MySQL database -


i'm trying link in ms access tables in mysql database on remote computer. i'm using system dsn (odbc), when try link tables (link tables dialog) dialog empty. no error message, empty list. i'm sure i've connection because after changing limit connectivity hosts matching field in mysql security tab (mysql workbench) "%" "localhost", error. fields in administrative roles tab checked!

a few questions consider:

  1. is dsn associated database schema includes tables want linked?
  2. does dsn work in opposite direction ... can export access table mysql using dsn?
  3. are there provisions in mysql monitor client connections, requests, , forth?

i'm grasping @ straws on one. i'm wondering if maybe dsn functional, perhaps not pointing @ mysql location includes tables want.

point #2 should tell whether dsn working @ all. if can export, find out exported table wound in mysql , compare location of other tables.


Comments

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

c++ - Is it possible to compile a VST on linux? -

url - Querystring manipulation of email Address in PHP -