When I look in Object Explorer under a database I have created, I don't see any of the tables listed that I created. No list at all. When I right-click and select refresh....nothing happens. I've tried granting all to the user I'm logged in with, close and re-open Toad for MySQL, rebooted everything, installed the update to TOAD. What am I missing?thanks
Icewast,to check whether your tables were really created, select the information_schema 'database' and query the TABLES table. You can add a filter to only view the tables in the database you created by adding a where clause on the table_schema field. If your tables are not listed, they were not created... If they are, then you more than likely have a permission issue with the user you have set up. If you do not have permission to read the information_schema 'database', then you may have to switch to the root user to do so.Good luck,Chris
To refresh a list just press F5 and the list you are currently looking at will be refreshed. You can also throw away all the cached data with Shift-F5.
Assuming you use Toad to create objects it will refresh itself (If it doesn't then that is a bug). If you create your objects in the editor it also does refresh itself in some cases, but not all because it is very hard for us to know what exactly you are doing with the SQL you are executing in the editor.