Thanks for the recommendations. We’ll definitely start upgrading.
Regarding the odbc, and passing the string. Can you tell me where do i have to add the string?
When i open the windows 10 odbc screen and select MySql 8.x driver, i have the following options:
Data Source Name: << i am guessing this is my own choice and i don’t pass here>>
Description: << i am guessing this is my own choice and i don’t pass here>>
TCP/IP Server: For AWS hosted databases, I just put the AWS connection address here and it works. do i append “–default-auth=MYMEMSQLPASSWORD” at the end here?
so if my aws string is “ec2-123.456.com”, does it become “ec2-123.456.com–default-auth=mysql_native_password” or does it become “ec2-123.456.com–default-auth=MYPASSWORD”
Password: Is it here?
I tried a couple of combinations so i am probably not appending it right. Appreciate your help.