var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SSL enable?
I have set up MySql to use SSL (I think).
I generated certs and modified the mysql start-up file to use the certs. When I open the local Workbench it shows SSL is enable and shows the certs.
however, i can connect to the MySQL DB that is supposed to have SSL enabled from a client running workbench without setting up workbench to use the SSL certs
i should be denied access to the remote DB that has SSL enabled.
am i missing something?
In fact even you enabled the ssl on the server, you can connect without ssl
if you connect with an user without the option 'Require SSL'.
You have to set the option like this :
When you will connect with the user 'username', you have to use the SSL certs.
GRANT SELECT ON dbname.* TO 'username'@'%' REQUIRE SSL;
If the connection is using SSL, This command
will show you something like that :
mysql -uusername -ppassword --ssl-ca=/../cacert.pem --ssl-cert=/../clientcert.pem --ssl-key=/../clientkey.pem -e '\s'
Current user: username@localhost
SSL: Cipher in use is DHE-RSA-AES256-SHA