Thank you, yes. Just before I saw your reply, the brain fog cleared and I came to the same conclusion.

To get around this issue I just use the MySQL workbench which is a free download from the MySQL website. It doesn't address the why of your question above,...