Unable to connect to Azure Database for MYSQL Single Server

Question

Twisha Mistry 1 Microsoft External Staff

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)

Anurag Sharma 17,636 Reputation points

2022-04-28T09:56:24.643+00:00
Hi @Twisha Mistry , 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
Anurag Sharma 17,636 Reputation points

2022-04-29T08:41:54.053+00:00

Hi @Twisha Mistry , just wanted to check if you were able to connect to Server?

Your answer

Anurag Sharma 17,636 Reputation points

2022-04-28T09:56:24.643+00:00

Hi @Twisha Mistry , 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
Anurag Sharma 17,636 Reputation points

2022-04-29T08:41:54.053+00:00

Hi @Twisha Mistry , just wanted to check if you were able to connect to Server?