MySQL connector doesn't show new table on schema

Hi Grazi,

Thank you for your question to the forum.

A new table not appearing in your MySQL connector usually means you are caching metadata, missing permissions, or not refreshing the schema properly. Most commonly, the connector or tool (Power BI, ODBC, Workbench, etc.) is holding onto an old schema snapshot and won’t display new tables until you force a metadata reload.

With your current set up, if the new table is not showing, here are some possible solutions to try out:

1. Schema Metadata Is Cached
Many tools (Power BI, ODBC drivers, Workbench) cache the list of tables.
- Even if you refresh data, the schema may not refresh.
- Some connectors only reload metadata when you reconnect or clear cache.

This is the most common cause.

2. User Permissions Are Missing
If the MySQL user doesn’t have `SELECT` or `SHOW TABLES` privileges on the new table, it won’t appear.
- This is especially common with ODBC connections.
- Ensure the SQL code includes:

GRANT SELECT, SHOW VIEW ON yourdb.* TO 'user'@'%';
FLUSH PRIVILEGES;

Missing permissions are a known cause in ODBC setups.

3. Connector/Driver Issues
Older or mismatched ODBC/MySQL drivers sometimes fail to update schema lists.
- Updating the connector often resolves this.
- MySQL’s own documentation notes that many issues disappear after upgrading the driver.

4. Workbench Navigator Not Refreshing
If you're using MySQL Workbench:
- The Navigator panel doesn’t always auto-refresh.
- You may need to right‑click the schema → Refresh All.
- Some users report that tables created via SQL don’t appear until Workbench is restarted.

5. Table Exists but Is Corrupted or Inaccessible
Rare, but possible:
- `SHOW TABLES` may list a table even if the underlying file is corrupted.
- In such cases, selecting from it fails, and some tools hide it.
This behaviour is documented in MySQL troubleshooting.

I hope this helps to resolve the issue.

Kind regards
Martin Sutherland
(IT Trainer)