question

FrankvanGraafeiland-1586 avatar image
0 Votes"
FrankvanGraafeiland-1586 asked FrankvanGraafeiland-1586 commented

Azure Database for MySQL servers MySQL 8.0 unencrypted database

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

azure-database-mysql
· 7
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @FrankvanGraafeiland-1586, welcome to Microsoft Q&A forum.

Can you please try the same command at table level once and check:

 ALTER TABLE testtable ENCRYPTION='N';




0 Votes 0 ·

Hi Anurag,


I used your command on a table, which results in a different error:
Error Code: 1478. InnoDB : ENCRYPTION is not accepted syntax for CREATE/ALTER table, for tables in general/shared tablespace.

If I try creating an unencrypted database, this is the output:
Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENCRYPTION='N'' at line 1

0 Votes 0 ·
AnuragSharma-MSFT avatar image AnuragSharma-MSFT FrankvanGraafeiland-1586 ·

Hi @FrankvanGraafeiland-1586, thanks for replying back. This looks strange as I am able to run the command successfully. Can you please tell me if this is new Server you configured? Also by any chance we are not using MariaDB server.

I can escalate it to product group based on your response.

0 Votes 0 ·

Hi Anurag,

Yes, I'm working on a script that, among other things, deploys an Azure Database for MySQL servers server. I've tried CREATE DATABASE testdb ENCRYPTION='n'; on several servers and I always get a bad syntax error. Both from MySQL Workbench and from App Service SSH sessions.

I hope my answer is informative for you.

0 Votes 0 ·
Show more comments

0 Answers