MySQL Bugs: #77989: MySQL Instance Scan is Not Locating MySQL on OS X

Bug #77989	MySQL Instance Scan is Not Locating MySQL on OS X
Submitted:	7 Aug 2015 23:16	Modified:	22 Sep 2015 1:08
Reporter:	Philip Olson	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S3 (Non-critical)
Version:	6.3.4	OS:	MacOS (10.10)
Assigned to:		CPU Architecture:	Any

Description:
The "Rescan for local MySQL instances" operation is not discovering connections on my OS X system. 

However, adding a connection and accepting all defaults works, which makes it seem like the scan should locate the the instance.

How to repeat:
1. Download and install MySQL server for OS X from dev.mysql.com
2. Open Workbench
3. Note the connection is not there
4. Right-click the home screen and choose "Rescan for local MySQL instances"
5. Note that it says none are found
6. Click [+] to add a new connection
7. Immediately click [Test Connection]
8. It says "Successfully made the MySQL connection"

NOTE: MySQL Bug #74434 introduced launchd. In doing so, it defaulted MySQL to 3307 instead of 3306. That is a bug that will be fixed soon. So, I fixed that for step 7. However, I do not think this is the cause for the bug here.

NOTE: Here's related process information:

MacBook-Pro:LaunchDaemons philip$ ps aux |grep mysql
_mysql           1836   0.0  2.7  3094916 451144   ??  Ss    4:05PM   0:00.40 /usr/local/mysql/bin/mysqld --user=_mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --log-error=/usr/local/mysql/data/mysqld.local.err --pid-file=/usr/local/mysql/data/mysqld.local.pid --port=3306

Suggested fix:
Considering these are official MySQL builds, Workbench should locate them. 

I do not know how the scan feature works, but the user is _mysql, perhaps it's looking for mysql. Not sure if that ever changed.

Message Dialog

Attachment: no_servers.png (image/png, text), 185.02 KiB.

Thank you for the bug report.

Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 6.3.5 release, and here's the changelog entry:

On OS X, the Rescan for local MySQL instances operation was not
discovering local MySQL server connections.

Thank you for the bug report.