Re: connection OK cannot connect to databaseserver
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
Subject
Views
Written By
Posted
3726
October 26, 2015 12:26PM
932
October 27, 2015 03:17AM
Re: connection OK cannot connect to databaseserver
1277
October 27, 2015 05:31AM
887
October 28, 2015 02:30AM
829
October 28, 2015 02:58AM
859
October 29, 2015 02:03AM
830
November 02, 2015 02:03AM
820
November 02, 2015 01:50PM
856
November 01, 2015 09:09PM
809
November 02, 2015 01:36AM
833
November 02, 2015 06:35AM
848
November 02, 2015 01:53PM
839
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.