MySQL Forums
Forum List  »  MySQL Workbench

Re: connection OK cannot connect to databaseserver
Posted by: ton dewilde
Date: October 27, 2015 05:31AM

Hi Marcin

I did:
de-install workbench
Switched off AVG firewall

restarted computer

install mysql-workbench-community-6.3.5-winx64.msi

restarted computer

started workbench from cmd prompt with:
>cd "C:\Program Files\MySQL\MySQL Workbench 6.3 CE"
>MySQLWorkbench.exe -log-level=debug3

Problem still exists.

LOGFILE:
12:26:19 [INF][ WBContext]: Parsing application arguments.
12:26:19 [INF][ WBContext]: C:\Program Files\MySQL\MySQL Workbench 6.3 CE\MySQLWorkbench.exe
12:26:19 [INF][ WBContext]: -log-level=debug3
12:26:19 [INF][ WBContext]: Logger set to level 'debug3'
12:26:19 [INF][ Workbench]: Starting up Workbench
12:26:19 [INF][ Workbench]: Current environment:
Command line: MySQLWorkbench.exe -log-level=debug3
CurrentDirectory: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
HasShutdownStarted: False
OSVersion: Microsoft Windows NT 6.2.9200.0
SystemDirectory: C:\WINDOWS\system32
TickCount: 1230390
UserInteractive: True
Version: 4.0.30319.42000
WorkingSet: 32919552
12:26:19 [INF][ Workbench]: Environment variables:
SystemDrive = C:
ProgramFiles(x86) = C:\Program Files (x86)
Path = 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\
ProgramW6432 = C:\Program Files
PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 42 Stepping 7, GenuineIntel
TMP = C:\Users\Ton\AppData\Local\Temp
PROCESSOR_ARCHITECTURE = AMD64
PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
USERPROFILE = C:\Users\Ton
PROCESSOR_REVISION = 2a07
GTK_BASEPATH = C:\Program Files (x86)\GtkSharp\2.12\
TEMP = C:\Users\Ton\AppData\Local\Temp
FPS_BROWSER_APP_PROFILE_STRING = Internet Explorer
FPS_BROWSER_USER_PROFILE_STRING = Default
LOGONSERVER = \\TON-PC2
XNAGSShared = C:\Program Files (x86)\Common Files\Microsoft Shared\XNA\
USERNAME = Ton
SystemRoot = C:\WINDOWS
VS100COMNTOOLS = c:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\Tools\
FP_NO_HOST_CHECK = NO
LOCALAPPDATA = C:\Users\Ton\AppData\Local
CommonProgramFiles = C:\Program Files\Common Files
ProgramData = C:\ProgramData
windows_tracing_logfile = C:\BVTBin\Tests\installpackage\csilogfile.log
HOMEPATH = \Users\Ton
COMPUTERNAME = TON-PC2
ALLUSERSPROFILE = C:\ProgramData
CommonProgramW6432 = C:\Program Files\Common Files
windows_tracing_flags = 3
SESSIONNAME = Console
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
PSModulePath = C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules\
XNAGSv4 = C:\Program Files (x86)\Microsoft XNA\XNA Game Studio\v4.0\
PROMPT = $P$G
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
12:26:19 [INF][ Workbench]: Current version given by meta info is: 6.3.5
12:26:19 [DB1][ Workbench]: Creating single instance setup
12:26:19 [DB2][ Workbench]: Trying to open existing event wait handle
12:26:19 [DB2][ Workbench]: This is the first application instance
12:26:19 [DB2][ Workbench]: Registering IPC channel and instance proxy
12:26:19 [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\
12:26:19 [INF][ mforms managed]: Initializing mforms wrapper
12:26:19 [DB2][ mforms backend]: Initializing mforms factory
12:26:19 [DB1][ WBContext]: Creating WBContext
12:26:19 [DB1][WBContext managed]: Creating WbContext
12:26:19 [DB1][ Managed Notify]: Registered managed observer for GNColorsChanged
12:26:19 [DB1][ Managed Notify]: Registered managed observer for GNFocusChanged
12:26:19 [DB1][ mforms managed]: Creating application wrapper
12:26:19 [DB1][ WBCallbacks]: Creating callbacks wrapper
12:26:19 [INF][ WBContext UI]: Initializing workbench context UI with these values:
base dir: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
plugin path: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
struct path:
module path: C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules
library path: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
user data dir: C:\Users\Ton\AppData\Roaming\MySQL\Workbench
open at start:
open type:
run at startup:
run type:
Force SW rendering: No
Force OpenGL: No
quit when done: No
12:26:19 [INF][ WBContext]: WbContext::init
12:26:19 [DB1][ GRTDispatcher]: starting worker thread
12:26:19 [DB1][ GRTDispatcher]: worker thread running
12:26:20 [DB1][ grt]: Looking for modules in 'C:\Users\Ton\AppData\Roaming\MySQL\Workbench\modules'.
12:26:20 [INF][ grt]: Scanning module directory C:\Users\Ton\AppData\Roaming\MySQL\Workbench\modules.
12:26:20 [DB1][ grt]: 0 modules found
12:26:20 [DB1][ grt]: Looking for modules in '.'.
12:26:20 [INF][ grt]: Scanning module directory ..
12:26:20 [DB2][ grt]: Trying to load module '.\db.grt.dll' (cpp)
12:26:20 [DB2][ grt]: Trying to load module '.\db.mysql.grt.dll' (cpp)
12:26:20 [DB2][ grt]: Trying to load module '.\db.mysql.parser.grt.dll' (cpp)
12:26:20 [DB2][ grt]: Trying to load module '.\db.mysql.query.grt.dll' (cpp)
12:26:20 [DB2][ grt]: Trying to load module '.\db.mysql.sqlparser.grt.dll' (cpp)
12:26:20 [DB2][ grt]: Trying to load module '.\wb.fabric.interface.grt.dll' (cpp)
12:26:20 [DB2][ grt]: Trying to load module '.\wb.model.grt.dll' (cpp)
12:26:20 [DB2][ grt]: Trying to load module '.\wb.mysql.import.grt.dll' (cpp)
12:26:20 [DB2][ grt]: Trying to load module '.\wb.utils.native.grt.dll' (cpp)
12:26:20 [DB1][ grt]: 9 modules found
12:26:20 [DB1][ grt]: Looking for modules in 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules'.
12:26:20 [INF][ grt]: Scanning module directory C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules.
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\code_utils_grt.py' (python)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\db_copy_grt.py' (python)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\db_generic_migration_grt.py' (python)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\db_generic_re_grt.py' (python)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\db_msaccess_migration_grt.py' (python)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\db_msaccess_re_grt.py' (python)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\db_mssql_grt.py' (python)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\db_mssql_migration_grt.py' (python)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\db_mysql_fe_grt.py' (python)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\db_mysql_migration_grt.py' (python)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\db_mysql_re_grt.py' (python)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\db_postgresql_migration_grt.py' (python)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\db_postgresql_re_grt.py' (python)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\db_sql92_migration_grt.py' (python)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\db_sql92_re_grt.py' (python)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\db_sqlanywhere_migration_grt.py' (python)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\db_sqlanywhere_re_grt.py' (python)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\db_sqlite_migration_grt.py' (python)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\db_sqlite_re_grt.py' (python)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\db_sybase_migration_grt.py' (python)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\db_sybase_re_grt.py' (python)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\migration_grt.py' (python)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\sqlide_grt.py' (python)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\table_utils_grt.py' (python)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\text_grt.py' (python)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\wbfabric_grt.py' (python)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\wb_admin_grt.py' (python)
12:26:20 [INF][ WBA]: Looking for extension modules for WBA...
12:26:20 [INF][ WBA]: 0 extension modules found
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\wb_dev_utils_grt.py' (python)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\wb_docs_grt.py' (python)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\wb_query_analysis_grt.py' (python)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules\wb_utils_grt.py' (python)
12:26:20 [DB1][ grt]: 31 modules found
12:26:20 [DB1][ grt]: Looking for user plugins in C:\Users\Ton\AppData\Roaming\MySQL\Workbench\modules
12:26:20 [DB1][ mforms managed]: Get special folder
12:26: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
12:26: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
12:26: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
12:26:20 [DB1][ grt]: Looking for user plugins in C:\Users\Ton\AppData\Roaming\MySQL\Workbench\plugins
12:26:20 [DB1][ grt]: Looking for plugins in C:\Users\Ton\AppData\Roaming\MySQL\Workbench\C:\Program Files\MySQL\MySQL Workbench 6.3 CE
12:26:20 [DB1][ grt]: Looking for modules in 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE'.
12:26:20 [INF][ grt]: Scanning module directory C:\Program Files\MySQL\MySQL Workbench 6.3 CE.
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE\db.mysql.diff.reporting.wbp.dll' (cpp)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE\db.mysql.editors.wbp.be.dll' (cpp)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE\db.mysql.wbp.dll' (cpp)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE\db.search.wbp.dll' (cpp)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE\wb.model.editors.wbp.be.dll' (cpp)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE\wb.model.snippets.wbp.dll' (cpp)
12:26:20 [DB2][ grt]: Trying to load module 'C:\Program Files\MySQL\MySQL Workbench 6.3 CE\wb.printing.wbp.be.dll' (cpp)
12:26:20 [DB1][ grt]: 7 modules found
12:26:20 [DB1][ WBContext]: Initializing rdbms modules
12:26:20 [DB1][ WBContext]: Cleaning up old options
12:26:20 [WRN][ grt]: C:\Users\Ton\AppData\Roaming\MySQL\Workbench\connections.xml:27: link '{58904A7A-467E-42AA-AC3A-B4207CFA18B0}' <object GrtObject> key=owner could not be resolved
12:26:20 [DB1][component_physical]: Loaded connection list, 11 connections found.
12:26:20 [DB2][ WBModule]: Opening wmi session
12:26:20 [DB1][ wmi]: Creating WmiServices for local server (user: )
12:26:20 [DB1][ wmi]: Allocating wbem locator
12:26:20 [DB2][ WBModule]: Running a wmi query
12:26:20 [DB3][ wmi]: Running wmi query: select * from Win32_VideoController
12:26:20 [DB2][ WBModule]: Closing wmi session
12:26:20 [DB2][ WBModule]: Closing all wmi monitors
12:26:20 [DB1][ wmi]: Destroying services
12:26:20 [DB1][ wmi]: Deallocating wbem locator
12:26: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
OS: Microsoft Windows 10 Home
CPU: 4x Intel(R) Core(TM) i5-2320 CPU @ 3.00GHz, 6.0 GiB RAM
Active video adapter NVIDIA GeForce GT 545
Installed video RAM: 1536 MB
Current video mode: 1920 x 1080 x 4294967296 colors
Used bit depth: 32
Driver version: 10.18.13.5362
Installed display drivers: nvd3dumx.dll,nvwgf2umx.dll,nvwgf2umx.dll,nvwgf2umx.dll,nvd3dum,nvwgf2um,nvwgf2um,nvwgf2um
Current user language: Dutch (Netherlands)

12:26:20 [DB1][ grt]: MySQL Generic Runtime Environment 4.1.0
12:26:20 [DB1][ grt]:
Type '?' for help.
12:26:20 [DB1][ grt]: Python Shell initialized. (Use Preferences -> General to set language)
12:26:20 [DB1][ grt]: Ready.
12:26:20 [DB1][ grt]:
12:26:20 [INF][ Workbench]: UI is up
12:26:20 [DB2][WBContext managed]: Activating appview avid2
12:26:20 [DB1][ WBContext]: Saved connection list (MySQL: 11)
12:26:20 [DB1][ WBContext]: Calling SQLIDEUtils.initialize0()...
12:26:20 [DB1][ WBContext]: Calling WbAdmin.initialize()...
12:26:20 [INF][ Workbench]: Running the application
12:26:28 [ERR][ SqlEditor]: SQL editor could not be connected: Could not open database
12:26:28 [ERR][ SqlEditor]: Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306:
Could not open database

Please:
1 Check that mysql is running on server 127.0.0.1
2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the root has rights to connect to 127.0.0.1 from your address (mysql rights define what clients can connect to the server and from which machines)
4 Make sure you are both providing a password if needed and using the correct password for 127.0.0.1 connecting from the host address you're connecting from
12:26:28 [DB1][ mforms managed]: Showing an error to the user
12:26:28 [DB1][ mforms managed]: Hiding the wait message
12:26:28 [DB2][ mforms managed]: Wait message was not visibile, nothing to do
12:26:28 [DB1][ mforms managed]: About to show a custom message box
12:26:28 [DB1][ mforms managed]: Creating and showing custom message box
12:26:28 [DB1][ mforms managed]: Running custom message box
12:26:32 [DB1][ mforms managed]: Custom message box closed
12:26:44 [DB1][ mforms managed]: Opening the URL: C:\Users\Ton\AppData\Roaming\MySQL\Workbench\log\wb.log

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.