Connecting to DigitalOcean Managed MySQL Database

I’m getting an error setting up my Target connection to a managed MySQL database on DigitalOcean. I’m getting the error below.

I suspect it may have to do with password encryption, but I don’t know. I receive this message using both MySQL 8 ( caching_sha2_password) encryption and Legacy MySQL 5 ( mysql_native_password) encryption.

Any ideas?

Testing Connection …

• set color:use-color yes
• set cmd:interactive yes
• set file:charset utf-8
• set xfer:clobber on
• set ftp:timezone
• set cmd:show-status yes
• set cmd:set-term-status yes
• set ftp:list-options -a
• set cmd:fail-exit yes
• set cmd:time-style “%Y-%m-%d %H:%M:%S”
• set ftp:ssl-allow no
• set ssl:verify-certificate no
• set net:max-retries 3
• set net:timeout 20
• set net:reconnect-interval-base 5
• set net:reconnect-interval-multiplier 1
• open -u user,pass ftp://mysite.com
  ---- Resolving host address…
  open `mysite.com’ [Resolvi---- 1 address found: xxx.xxx.xxx.xxx
• ls
  ---- Connecting to mysite.com (xxx.xxx.xxx.xxx) port 25060
  <— J!!!
  8.0.19!▒Y!!/HK!▒!!!izrN╚MrDU!caching_sha2_password!
  **** Peer closed connection
  ---- Closing control socket
  ---- Connecting to mysite.com (xxx.xxx.xxx.xxx) port 25060
  <— J!!!
  8.0.19!▒Y!!Jx>J!x!▒!!!UU_*f p!caching_sha2_password!
  **** Peer closed connection
  ---- Closing control socket
  ---- Connecting to mysite.com (xxx.xxx.xxx.xxx) port 25060
  <— J!!!
  J;!caching_sha2_password!!!)2Abt
  **** Peer closed connection
  ---- Closing control socket
  ls: Fatal error: max-retries exceeded