MySQL Bugs: #78208: WB can´t get a connect, even the Server 5.6.26 is running properly and do his wo

Bug #78208	WB can´t get a connect, even the Server 5.6.26 is running properly and do his wo
Submitted:	25 Aug 2015 13:44	Modified:	25 Aug 2015 14:37
Reporter:	Burkhard Kaiser	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	6.3.4	OS:	MacOS (OS X 10.10.x Yosemite)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
----[For better reports, please attach the log file after submitting. You can find it in /Users/kabey_admin/Library/Application Support/MySQL/Workbench/log/wb.log]

15:21:10 [INF][      WBContext]: Parsing application arguments.
15:21:10 [INF][      WBContext]:     /Applications/MySQLWorkbench.app/Contents/MacOS/MySQLWorkbench
15:21:10 [INF][      Workbench]: Starting up Workbench
15:21:10 [INF][      Workbench]: Loading main window
15:21:10 [INF][   WBContext UI]: Initializing workbench context UI with these values:
	base dir: /Applications/MySQLWorkbench.app/Contents/Resources
	plugin path: /Applications/MySQLWorkbench.app/Contents/PlugIns
	struct path: /Applications/MySQLWorkbench.app/Contents/Resources/grt
	module path: /Applications/MySQLWorkbench.app/Contents/PlugIns:/Applications/MySQLWorkbench.app/Contents/Resources/plugins
	library path: /Applications/MySQLWorkbench.app/Contents/Resources/libraries
	user data dir: /Users/kabey_admin/Library/Application Support/MySQL/Workbench
	open at start: 
	open type: 
	run at startup: 
	run type: 
	Force SW rendering: No
	Force OpenGL: No
	quit when done: No
15:21:10 [INF][      WBContext]: WbContext::init
15:21:11 [INF][            WBA]: Looking for extension modules for WBA...
15:21:11 [INF][            WBA]: 0 extension modules found
15:21:11 [WRN][            grt]: /Applications/MySQLWorkbench.app/Contents/Resources/data/table_templates.xml:21: link 'com.mysql.rdbms.mysql.datatype.timestamp' <object db.SimpleDatatype> key=simpleType could not be resolved
15:21:11 [WRN][            grt]: /Applications/MySQLWorkbench.app/Contents/Resources/data/table_templates.xml:106: link 'com.mysql.rdbms.mysql.datatype.varchar' <object db.SimpleDatatype> key=simpleType could not be resolved
15:21:11 [WRN][            grt]: /Applications/MySQLWorkbench.app/Contents/Resources/data/table_templates.xml:229: link 'com.mysql.rdbms.mysql.datatype.int' <object db.SimpleDatatype> key=simpleType could not be resolved
15:21:11 [WRN][            grt]: /Users/kabey_admin/Library/Application Support/MySQL/Workbench/connections.xml:24: link '70D128DF-2B3D-4219-9843-3571ADA12FE1' <object GrtObject> key=owner could not be resolved
15:21:11 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Mac OS X version 6.3.4  revision 0 build 828 (32 bit)
	Configuration Directory: /Users/kabey_admin/Library/Application Support/MySQL/Workbench
	Data Directory: /Applications/MySQLWorkbench.app/Contents/Resources
	Cairo Version: 1.10.2
	OS: OS X 10.10.x Yosemite
	CPU: 4x Intel(R) Core(TM) i5-4260U CPU @ 1.40GHz - 4.00GiB RAM

 

How to repeat:
System: Mac OS X 10.10.5 and mySQL community Server 5.6.26 try to build a root connect with the Workbench 6.3.4. It will return with no Server found and failed to connect. 
But the sever is definitively running and do it´s works well. 

Suggested fix:
no Suggestion, sorry

Ok i fixed this problem. The bug is in the launch deamon file "_com.oracle.oss.mysql.mysqld.plist"

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
	<key>Disabled</key>
	<false/>
	<key>ExitTimeOut</key>
	<integer>600</integer>
	<key>GroupName</key>
	<string>_mysql</string>
	<key>KeepAlive</key>
	<true/>
	<key>Label</key>
	<string>com.oracle.oss.mysql.mysqld</string>
	<key>LaunchOnlyOnce</key>
	<false/>
	<key>ProcessType</key>
	<string>Interactive</string>
	<key>Program</key>
	<string>/usr/local/mysql/bin/mysqld</string>
	<key>ProgramArguments</key>
	<array>
		<string>/usr/local/mysql/bin/mysqld</string>
		<string>--user=_mysql</string>
		<string>--basedir=/usr/local/mysql</string>
		<string>--datadir=/usr/local/mysql/data</string>
		<string>--plugin-dir=/usr/local/mysql/lib/plugin</string>
		<string>--log-error=/usr/local/mysql/data/mysqld.local.err</string>
		<string>--pid-file=/usr/local/mysql/data/mysqld.local.pid</string>
		<string>--port=3307</string>
	</array>
	<key>RunAtLoad</key>
	<true/>
	<key>SessionCreate</key>
	<true/>
	<key>UserName</key>
	<string>_mysql</string>
	<key>WorkingDirectory</key>
	<string>/usr/local/mysql</string>
</dict>
</plist>

Here is defined the connection port 3307. That is wrong! It is to change to 3306. Restart the server with the control panel and after that the Workbench will work properly. 

It took me some nerves and it is an annoying bug!!!