Azure Database forMYSQL接続制御をIPアドレス以外でできますか？

Hi @柴田 巧

Thank you for your question.

For Azure Database for MySQL Flexible Server, if you are using Public Access, firewall rules are based on IP addresses. It is not possible to create a firewall rule using a hostname or FQDN instead of an IP address.

If your client IP changes frequently, you can consider using a Private Endpoint. This allows you to connect to the MySQL server through a private network instead of managing changing public IP addresses.

If you need to continue using Public Access, another option is to use a static public IP address for the client and add that IP to the firewall rule.

You can also use Microsoft Entra ID authentication to control which users or applications can connect. Please note that this controls authentication and does not replace the network firewall.

I hope this helps. Please let us know if you have any further questions.