I am trying to connect to MySQL using RStudio on macbook pro M1 Max running on MacOS Sonoma 14.5 Error: Failed to connect: Connections using insecure transport are prohibited while ...

While using the service of mysql, ive stumble upon this error on builds that were working last week (no changes to code made): MySql.Data.MySqlClient.MySqlException : SSL Connection error.

Researchers have identified a serious vulnerability in some versions of Oracle’s MySQL database product that allows an attacker to strip SSL/TLS connections of their security wrapping transparently.

Relatively new to Linux, so forgive that "newbie smell," but I've Googled 'til my fingers are raw, searched all the relavant sites, and still can't find a clear tutorial covering the following goal, ...