0

I've created a database on a local MySQL server with MySQL Workbench version 8.0 on Windows 10, but when I make a table in said database with a manually typed query

CREATE TABLE newtable (column1 INTEGER NOT NULL, column2 VARCHAR(30), PRIMARY KEY column1);

I can't see the table in the Navigator panel on the left hand side, even after right-clicking the schema and clicking Refresh All. However, the query was completed successfully according to the output. If I right-click the database and open the Schema inspector, in the Tables column, I can see the new table. I can even work with the new table with typed queries - I just can't seem to open the GUI. That is, until I restart Workbench, and then it shows up.

I tried creating a new table using the GUI, that is, right-click on "Tables" in the Navigator and then creating a new table, and that works as expected and the new table is visible in the Navigator.

Is this a bug in MySQL Workbench or am I doing something wrong? (I am very new to this, I'm still learning!)

EDIT: After rebooting my computer, the problem is gone and refreshing schemas works as expected. ¯\_(ツ)_/¯

closed as off-topic by Colin 't Hart, mustaccio, Md Haidar Ali Khan, Michael Green, hot2use Sep 21 '18 at 8:14

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Colin 't Hart, mustaccio, Md Haidar Ali Khan, Michael Green, hot2use
If this question can be reworded to fit the rules in the help center, please edit the question.

  • For me the new table shows up after manually refreshing the schema tree. Does the same happen when you fully qualify the table name? – Mike Lischke Sep 20 '18 at 7:04
  • sigh it didn't when I posted this question... but now it does. I guess a reboot fixed everything. – Neil Banerjee Sep 20 '18 at 7:37
0

After rebooting my computer, the problem is gone and refreshing schemas works as expected. ¯\_(ツ)_/¯

Not the answer you're looking for? Browse other questions tagged or ask your own question.