connection OK cannot connect to databaseserver
Suddenly workbench fails with the message:
Cannot connect attempt failed for user root from your host to server 127.0.0.1:3306.
Could not open database.
From asp.net i can access the database
Also my connections on a remote server like musql.xxxx.nl:3306 have the same error whilst the website is stille running smoothly.
I Did edit connection->test connection,
result: successfully made the MySQL connection
Restarted Workbench -> problem remains
Restarted computer -> problem remains
installed newest workbench version 6.3.5 CE build 201 (64 bit)
Restarted computer -> problem remains
What is going on???
INFO:
PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 42 Stepping 7, GenuineIntel
PROCESSOR_REVISION = 2a07
ROCESSOR_ARCHITECTURE = AMD64
MySQL Workbench Community (GPL) for Windows version 6.3.5 CE build 201 (64 bit)
Data Directory: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
Cairo Version: 1.10.2
OS: Microsoft Windows 10 Home
CPU: 4x Intel(R) Core(TM) i5-2320 CPU @ 3.00GHz, 6.0 GiB RAM
CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files
HOMEDRIVE = C:
windir = C:\WINDOWS
CLASSPATH = C:\Users\Ton\AndroidDev\adt-bundle-windows\sdk\platform-tools;C:\Users\Ton\AndroidDev\adt-bundle-windows\sdk\tools;%ANT_HOME%\bin
NUMBER_OF_PROCESSORS = 4
OS = Windows_NT
ProgramFiles = C:\Program Files
ComSpec = C:\WINDOWS\system32\cmd.exe
XNAGSv4 = C:\Program Files (x86)\Microsoft XNA\XNA Game Studio\v4.0\
PSModulePath = C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules\
APPDATA = C:\Users\Ton\AppData\Roaming
USERDOMAIN = Ton-PC2
PROCESSOR_LEVEL = 6
ANDROID_NDK_PATH = C:\Program Files\Android\ndk\android-ndk-r8d
USERDOMAIN_ROAMINGPROFILE = Ton-PC2
PUBLIC = C:\Users\Public
16:18:17 [INF][ Workbench]: Current version given by meta info is: 6.3.5
16:18:17 [INF][ Workbench]: Setting PATH to: C:\WINDOWS\system32;C:\ProgramData\Oracle\Java\javapath;C:\Windows\SysWOW64;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Windows Live\Shared;C:\Program Files\MySQL\MySQL Server 5.5\bin;c:\Program Files (x86)\Microsoft ASP.NET\ASP.NET Web Pages\v1.0\;C:\Program Files\SourceGear\Common\DiffMerge\;C:\Program Files\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files (x86)\GtkSharp\2.12\bin;C:\Program Files (x86)\QuickTime\QTSystem\;C:\Program Files\Microsoft\Web Platform Installer\;C:\dev\MapWinGIS;C:\Program Files\Microsoft SQL Server\120\Tools\Binn\
16:18:17
open at start:
open type:
run at startup:
run type:
Force SW rendering: No
Force OpenGL: No
quit when done: No
16:18:17 [INF][ WBContext]: WbContext::init
16:18:19 [INF][ grt]: Scanning module directory C:\Users\Ton\AppData\Roaming\MySQL\Workbench\modules.
16:18:19 [INF][ grt]: Scanning module directory ..
16:18:19 [INF][ grt]: Scanning module directory C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules.
16:18:20 [INF][ WBA]: Looking for extension modules for WBA...
16:18:20 [INF][ WBA]: 0 extension modules found
16:18:20 [WRN][ grt]: C:\Program Files\MySQL\MySQL Workbench 6.3 CE\data/table_templates.xml:21: link 'com.mysql.rdbms.mysql.datatype.timestamp' <object db.SimpleDatatype> key=simpleType could not be resolved
16:18:20 [WRN][ grt]: C:\Program Files\MySQL\MySQL Workbench 6.3 CE\data/table_templates.xml:106: link 'com.mysql.rdbms.mysql.datatype.varchar' <object db.SimpleDatatype> key=simpleType could not be resolved
16:18:20 [WRN][ grt]: C:\Program Files\MySQL\MySQL Workbench 6.3 CE\data/table_templates.xml:229: link 'com.mysql.rdbms.mysql.datatype.int' <object db.SimpleDatatype> key=simpleType could not be resolved
16:18:20 [INF][ grt]: Scanning module directory C:\Program Files\MySQL\MySQL Workbench 6.3 CE.
16:18:20 [WRN][ grt]: C:\Users\Ton\AppData\Roaming\MySQL\Workbench\connections.xml:24: link '{13479954-30BC-4FA9-9F65-EFE585507CB4}' <object GrtObject> key=owner could not be resolved
16:18:20 [INF][ WBContext]: System info:
MySQL Workbench Community (GPL) for Windows version 6.3.5 CE build 201 (64 bit)
Configuration Directory: C:\Users\Ton\AppData\Roaming\MySQL\Workbench
Data Directory: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
Cairo Version: 1.10.2
If the rules make me miss my goal I normally question the rules not the goal!
What's in a hobby?: Algol68, tiny-basic, basic, cobol, sybol, dbIII, VB,java, VB.Net, ASP, SQL and some more.
Subject
Views
Written By
Posted
connection OK cannot connect to databaseserver
3749
October 26, 2015 12:26PM
938
October 27, 2015 03:17AM
1285
October 27, 2015 05:31AM
900
October 28, 2015 02:30AM
834
October 28, 2015 02:58AM
865
October 29, 2015 02:03AM
837
November 02, 2015 02:03AM
828
November 02, 2015 01:50PM
859
November 01, 2015 09:09PM
818
November 02, 2015 01:36AM
842
November 02, 2015 06:35AM
851
November 02, 2015 01:53PM
845
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.