Re: MySQL Workbench

[Henrique Garcia]

Hi Nick, how are you?

MySQL Workbench connects to a server, not to a single database.
Disconnecting or deleting a schema does not close the server connection, so commands may still run against the previously selected (or default) database.

You can change the active database explicitly using:
USE db_name;

Editor vs command-line differences are usually caused by session state, selected schema, or client-side parsing in Workbench, not by the MySQL server itself.


Best regards,
Henrique Garcia.