MySql 8 or MariaDB 10.3.8 on Amazon AWS

Hi Guys,

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] [2003] 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?

Many thanks!

Community Page
Last updated: