>Is there a List of all "key" MYSQL tables somewhere

Look at INFORMATION_SCHEMA.TABLES for a list of all tables.

>Detailing table attributes, columns, USER Privileges over a database
>or table etc....
>
>O know on the mainframe side of things the IBM DB2 product has a
>control internal table called SYSIBM.SYSTABLES and that lists about
>ALL the internal tables that DB2 uses so you can query a specific one
>say to see who has access to a specfic table etc.

The MySQL privilege system is a bit complicated so a single query
for who has access to which table may be complicated (there's global
access, per-database access, and per-table access). The relevant
real tables are in the 'mysql' database. There are also privileges
in the INFORMATION_SCHEMA database.

>I assume MYSQL must have these internal (metastore tables) uif so does
>anyone have a list of what these are ?