

You can have the full list of available regions by entering az account list-locations. You can use eastus by default, but we recommend that you configure a region closer to where you live.

You can connect to your server using a popular client tool, mysql.exe command-line tool with Azure Cloud Shell. If you're using a Windows machine and want to run the samples locally, install and use the latest Windows Subsystem for Linux (WSL).We recommend Azure Cloud Shell so you'll be logged in automatically and have access to all the tools you'll need. Azure Cloud Shell or Azure CLI 2.37.0 or above required.Because these passwords are stored in MySQL, you'll need to manage the rotation of the passwords by yourself. If you choose to use passwords as credentials for the accounts, these credentials will be stored in the user table. MySQL authentication uses accounts stored in MySQL.

With Azure AD authentication, you can manage database user identities and other Microsoft services in a central location, which simplifies permission management. The Passwordless tab shows the Azure AD authentication and the Password tab shows the MySQL authentication.Īzure AD authentication is a mechanism for connecting to Azure Database for MySQL using identities defined in Azure AD. In this article, we'll include two authentication methods: Azure Active Directory (Azure AD) authentication and MySQL authentication. The Java Persistence API (JPA) is the standard Java API for object-relational mapping. This article demonstrates creating a sample application that uses Spring Data JPA to store and retrieve information in Azure Database for MySQL.
