title: How determine if using SSL in a MySql Connection?
body: <p>We are using v6.9.9 of the .Net MySql Connector to access MySql using this connection string, specifying that SSL is required. </p>
  
  <pre><code>Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
  SSL Mode=Required
  </code></pre>
  
  <p>Our DBA has turned on support for SSL, but during my testing, I am able to connect to the server regardless of whether I have certificates installed on my machine, and also regardless of whether I have "SSL Mode=Required" or not.</p>
  
  <p>However, when my DBA disabled SSL, if I use the above connection string, I got an error that SSL was not enabled.</p>
  
  <p>Therefore, I really just don't know if my network traffic is being encrypted or not. How can I verify?</p>
  
  <p>--</p>
  
  <p>My question is a bit of a duplicate to this one with no accepted answer.</p>
  
  <p><a href="https://stackoverflow.com/questions/14389921/how-to-check-whether-a-mysql-connection-is-ssl-encrypted">How to check whether a MySQL connection is SSL encrypted?</a></p>
  
  <p>Some recommend using WireShark to test. Does anyone have step-by-step instructions on how to use this tool to verify my SSL connections? </p>
  
  <p>--</p>
  
  <p>This link talks about calling "status" from the MySql client.
  <a href="https://dba.stackexchange.com/questions/36776/how-can-i-verify-im-using-ssl-to-connect-to-mysql">https://dba.stackexchange.com/questions/36776/how-can-i-verify-im-using-ssl-to-connect-to-mysql</a></p>
  
  <p>I asked my DBA to try it - but he isn't able to call that method against my connection, only against his local connection. Is there anyway to call this, for example, within my c# code?
  I tried this, but I don't think the returned values tell me if the connection is SSL or not.</p>
  
  <pre><code>SHOW SESSION STATUS LIKE '%Ssl%';
  </code></pre>
  
  <p>Anyone with detailed information on how to verify my SSL connections would be greatly appreciated! Thank you!</p>