Access to MySQL server not displaying tables

[Slim Shamble]

Hi Guys,

i linked my access table to MySQL server ODBC 5.7. AFTER i did that, the ODBC is not displaying any tables in the column

Any idea on how to resolve this please?

i tried Compact and repair, still not good

 

[The_Doc_Man]

The question is whether the MySQL server is set to require passwords and you didn't give it one? Your question doesn't address this.

 

[Slim Shamble]

Yes, i assigned a password to it and the connection was successful.

secondly,

i later remove password from the server yet my table still not dispaying in the column