MySQL Bugs: #61266: Workbench Connection SSL (without client certificates)

Bug #61266	Workbench Connection SSL (without client certificates)
Submitted:	23 May 2011 17:31	Modified:	5 Dec 2012 6:47
Reporter:	Ruben Goethals	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S4 (Feature request)
Version:	5.2.33 CE	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	SSL, workbench

Description:
Apparently, SSL connection is not integrated yet in above version of Workbench.

I read this in several places (e.g. mysql.com) and I also tested it with my remote-SSL-only server.  
For the test, Workbench gives "access denied" error, though the exact same connection works in Navicat and Aqua Data Studio.

(I am talking about SSL without client keys or certificates.)

I would be very glad if someone could implement/fix this once.  Thanks in advance!! :-)

How to repeat:
Make connection:
Username, password, port, etc.. as it should be. 
(The user is allowed on server via remote (%), but with ssl only!)

Advanced connection Tab: ONLY "Use SSL if available" 
(All the file fields are emtpy.)

Hello Ruben
Thanks a lot for your report.
Can you please provide more details?
If you can attach the my.ini (or my.cnf) will be great.
Also, what are you using to link the user with SSL conection? (GRANT ALL ON *.* TO 'user'@'%' REQUIRE SSL;).
Thanks.

my.ini (or my.cnf):
I will attach the one from my server.

-----------------

"Also, what are you using to link the user with SSL conection?"
I dunno, here is the info in the mysql user table, that tells it too, right?
host: %
From Select_priv upto Trigger_priv: all Y
ssl_type:any
all the rest is 0 or 0 bytes.

my.cnf

Attachment: my.cnf (application/octet-stream, text), 3.89 KiB.

Verified using ssl related options from my.cnf provided by user and a user created and having ssl_type field of mysql.user set to 'ANY'.

To verify the ssl connection from cmdline, use:
mysql -ussl --ssl-key=
(anything else should prevent the connection)

Fixed as of the upcoming MySQL Workbench 5.2.45, and here's the changelog entry:

An SSL connection required a client certificate.

Thank you for the bug report.