Re: connection OK cannot connect to databaseserver
SOLVED !!
The problem is that workbench can't cope with different database releases.
Local I had the latest 5.7 and remote I had 5.5.37
Normally you would expect a tool like workbench to be able to cope with older databases (downward compatible) but it can't. Partly because of, I think, lazy or non-developer oriented, programming.
So I downgraded the local MySQL server to 5.5.37 (that's 1.5 years back in time) and picked the old workbench version 5.2.37.
Hurray I could access both databases again.
Also I found that the workbench installer version 5.7.9 embeds a faulty/buggy MYSQLDUMP!!!
I wonder why?
It's a long time known problem, The Installer has not been changed yet and they did not put up a notice or urge you to install and reference a working MYSQLdump.
Subject
Views
Written By
Posted
3758
October 26, 2015 12:26PM
942
October 27, 2015 03:17AM
1288
October 27, 2015 05:31AM
904
October 28, 2015 02:30AM
837
October 28, 2015 02:58AM
Re: connection OK cannot connect to databaseserver
867
October 29, 2015 02:03AM
839
November 02, 2015 02:03AM
830
November 02, 2015 01:50PM
864
November 01, 2015 09:09PM
822
November 02, 2015 01:36AM
846
November 02, 2015 06:35AM
860
November 02, 2015 01:53PM
848
November 02, 2015 02:50PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.