I need to use recursive CTE on one of my projects and it is only available on MySQL 8 and from MariaDB 10.2.2, so I created a database server on Amazon AWS, but I can’t connect to it from wappler.
The error message:
SQLSTATE[HY000]  Can’t connect to MySql server on ‘server’ (111 - “connection refused”)
I can connect to the server using SQLyog or MySql Workbench, so it is only an issue from websites (including phpmyadmin…)
As far as I know MySql changed the default password encryption and since then it stopped working even on the newest php version.
Any of you had this problem before and have a workaround so I could use CTE queries on wappler?