I’m posting here just in case anybody else has seen something like this: I am trying to launch MODX using Ploi and/or Cleavr which are interfaces that connect to and deploy VPS servers to multiple modern providers like Linode, Digital Ocean, Vultr, etc.
The problem I’m running into is that MODX cannot connect to the MySQL database on any of these setups. They’re running NGINX on Ubuntu 20.04 with MySQL 8 and PHP 7.4.
I can connect using PHP myadmin, and Wordpress works without a problem. But during installation, MODX can never ever connect to the db. Is there something that I need to change in an LEMP setup to allow MODx to connect to MySQL?