We are in the process of upgrading from v7.9 and MySQL v5.4 to v8.1 and MySQL v8.4. We still have two gateways left and one of them is accessing some of the new MySQL v8.4 server(s), which is where we get these errors:
"Cannot create PoolableConnectionFactory (Client does not support authentication protocol requested by server; consider upgrading MySQL client)"
MySQL >v8.0 has deprecated native passwords so I've looked at setting MySQL to allow native passwords (what MySQL suggests):
I put "mysql_native_password=ON" in the "My.ini" file but the MySQL service fails to restart afterwards.
I was wondering if there is something I need to do to get Ignition v7.9 to use SHA2 authentication with v8.4.