Hi there,
I've been working with Azure Database for MySQL servers version 8.0 and App Services to deploy WordPress websites. Apparently, with MySQL 8.0, new databases are encrypted by default. This is a problem for me because I can't configure WordPress to work with encrypted databases. I tried creating an unencrypted database with the following command:
CREATE DATABASE testdb ENCRYPTION='n';
Unfortunately, this results in a syntax error. When I perform the same command on a VM with MySQL 8.0 Community edition, however, the command works. Perhaps Azure PaaS MySQL server has a different syntax?
The ideal solutions would be to get WordPress to work with MySQL's encrypted databases, but I don't expect such a solution from the Azure community.
Does anybody know whether it is possible to create unencrypted databases in Azure Database for MySQL servers version 8.0? And if so: how?
Thanks a bunch!
Kind regards,
Frank