Unable to connect to Azure Database for MYSQL Single Server

We are unbale to login to Azure Database for MySQL Single Server. The user trying to login is set as “Admin” in Active Directory Admin blade.

Getting error: Access denied for user 'username'@'IP address' (using password: YES)

· 2

5 |1600 characters needed characters left characters exceeded

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

AnuragSharma-MSFT · Apr 28 at 09:56 AM

Hi @TwishaMistryMINDTREELIMITED-6513, welcome to Microsoft Q&A forum.

As I understand you are trying to connect to Azure MySQL - Single Server using Active Directory Admin credentials.

Could you please provide more information on how are you trying to connect, through CLI commands, workbench etc? Please provide the screenshot as well id possible for more details.

This error mostly comes when user is not present or wrong password is provided. I tried replicating by below steps as was able to succeed:

Created new Azure MySQL Single Server
Add a user as Active Directory Admin
Logged with the user in Azure Portal and ran below command and it worked:

mysql -h <ServerName>.mysql.database.azure.com --user <Username>@<domain>.onmicrosoft.com@<ServerName>--password=`az account get-access-token --resource-type oss-rdbms --output tsv --query accessToken` --ssl