Connecting to DigitalOcean Managed MySQL Database

Server Side Components
, ,
#1

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
#2

Are you trying to connect to your database server with FTP? Dat is for files only.

You can connect to Databases and specially to Managed Databases in Digital Ocean with the new Database Manager that is now in preview.

#3

You’re right :man_facepalming:, I was thinking a remote target needed to point there as well, my mistake.

FYI- it connects now using Server Connect, but password encryption does need to be set up on Legacy MySQL 5

#4

Btw just published an article about using Digital Ocean Managed Databases with the new Database Manager in Wappler: