Turning Of Encryption Between ODBC to Localhost Database

[Carlin Connell]

Hi,

I am hoping that I have found the right place.

I have been tasked with optimizing our server.

I am trying to turn off encryption and decryption for SQL requests made to localhost.
But would like to be able to encrypt requests sent to replication databases.

I have noticed that there is a large portion of exclusive samples come from the TaoCrypt library doing encryption, decryption, and transform.

TaoCrypt::AES::decrypt 5,998 5,998 1.42% 1.42%
TaoCrypt::SHA::Transform 4,954 4,954 1.17% 1.17%
TaoCrypt::AES::encrypt 4,296 4,296 1.01% 1.01%

Looking into this a bit more, I have found the following stack trace:

TaoCrypt::AES::encrypt
TaoCrypt::Mode_BASE::CBC_Encrypt
yaSSL::`anonymous namespace`::buildMessage
yaSSL::sendData
vio_ssl_write
net_write_raw_loop
net_write_packet
net_flush
net_write_command
cli_advanceed_command
mysql_send_query
mysql_real_query
do_query
my_SQLExecute

This is basically the same for TaoCrypt::AES::decrypt.

In this test, the database is not issuing replication commands.
I would like to be able to employ encryption & decryption to non-local host databases.

I am using MySQL ODBC 5.3 Unicode driver.

What I have tried to do:
In the MySQL Connector/ODBC GUI window

Under the connections tab
[x] Disable default SSL

Under the SSL tab
[X] Disable TLS Version 1
[X] Disable TLS Version 1.1
[X] Disable TLS Version 1.2

I have been unable to find any documentation on this subject otherwise.

I am hoping that you would be able to provide me with how or guide me to the correct documentation so that I can turn off commands being encrypted and decrypted for requests being sent from ODBC to the database on the same server.

Sincere Regards,
Carl