MySQL Forums
Forum List  »  MySQL Workbench

connection OK cannot connect to databaseserver
Posted by: ton dewilde
Date: October 26, 2015 12:26PM

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.

Options: ReplyQuote




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.