Re: Turning Of Encryption Between ODBC to Localhost Database
In "%ProgramData%\MySQL\MySQL Server 5.7\my.ini" I have added
[mysqld]
require_secure_transport=OFF
In mysql.exe I have:
mysql> CREATE USER 'user_localhost'@'localhost' IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.01 sec)
mysql> CREATE USER 'user_remotehost'@'localhost' IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL ON *.* TO 'user_localhost'@'localhost';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT USAGE ON *.* TO 'user_remotehost'@'localhost' REQUIRE SSL;
Query OK, 0 rows affected, 1 warning (0.00 sec)
In ODBC GUI, I have:
System DNS Tab > My Connection *Click Configure*
1. Connection Tab > Disable default SSL
2. SSL Tab > Disable TLS Version 1
3. SSL Tab > Disable TLS Version 1.1
4. SSL Tab > Disable TLS Version 1.2
I have tested using user_localhost and user_remotehost for my connections.
I may expect to see samples between the two users for yaSSL as it would be used when the database connection is established to hide the password.
However, still, for both users, I see the same amount of samples over time.
I can completely disable the SSL ("disable-ssl")
Any further help would be greatly appreciated.
Regards,
Carl
Subject
Written By
Posted
Re: Turning Of Encryption Between ODBC to Localhost Database
October 19, 2021 11:22PM
November 09, 2021 10:12PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.