Bug #60170 WB only recognises service names starting with 'mysql ..'
Submitted: 18 Feb 2011 19:19 Modified: 25 Jun 2011 0:52
Reporter: Peter Laursen (Basic Quality Contributor) Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.2.31 OS:Windows (7/64)
Assigned to: CPU Architecture:Any

[18 Feb 2011 19:19] Peter Laursen
Description:
I have a MariaDB instance running on port 3310. The service name is 'maria52' (it was installed wiht a .msi installer under development.

Trying to register this instance in WB results in complete mess.  I can specify port, provide user/password and WB finds the service running.  Next I am prompted to select the server instance to manage.  Only my mySQL 5.0, 5.1 and 5.5 instances (named mysql50, mysql51 and mysql55) are listed.  I select one randomly (I have no other option).

Screenshots will be attached demonstrating the complete mess resulting from this.

How to repeat:
See above

Suggested fix:
There should be a 'more' button so that user can specify her service in case it does not start with 'mysql..'
[18 Feb 2011 19:20] Peter Laursen
WB is able to connect .. and identifies the server as MariaDB 5.2

Attachment: 1st.jpg (image/jpeg, text), 16.88 KiB.

[18 Feb 2011 19:21] Peter Laursen
There is no option to specify the 'maria52' service on my system

Attachment: nomaria.jpg (image/jpeg, text), 20.69 KiB.

[18 Feb 2011 19:22] Peter Laursen
proceeding results in complete garbage/mess

Attachment: garbage.jpg (image/jpeg, text), 22.21 KiB.

[18 Feb 2011 19:25] Peter Laursen
This report is a derivate of http://bugs.mysql.com/bug.php?id=60167.

I do not face any problem with 'protected memory'.  But I cannot in any meaningful way register my 'maria52' service in WB.
[18 Feb 2011 19:32] Peter Laursen
Haha!  Now also this report is marked as 'QA review' what guarantees that nothing will ever happen!
[18 Feb 2011 21:52] Alfredo Kojima
Setting as verified, but considering default installations will all be named as some variation of MySQL, this is a low priority issue.
[19 Feb 2011 1:08] Vladislav Vaintroub
Not sure about some variations of MySQL. Once MySQL is installed on the box , in some version say 5.0, this name is not reusable for any other instance say 5.5. So people would probably name the service ProductionDatabase, AlfredoDatabase, MyDB or something, rather what ConfigWizard proposes (currently, for 5.5 it proposes MySQL501). Assumption about "some variation of mysql" won't not hold here anymore, unless of course they have a single DB per machine, where probability that service is named MySQL is better.
[25 Jun 2011 0:52] Paul DuBois
Duplicate of Bug 11829856)