question

SubhashGander-1654 avatar image
0 Votes"
SubhashGander-1654 asked NavtejSaini-MSFT commented

Azure Mysql Connection Issue

All,

I have created a MYSQL server on AZURE and able to connect with via WORKBENCH from LOCAL using administrator account.

Post that created couple of additional non admin accounts that was successful.

But when I am trying to connect AZURE MYSQL from local workbench using non admin account then getting below error.

ACCESS DENIED FOR THE USER 'XXXX' @ 'IP_ADDRESS' (Using password : YES)

I would appreciated any help on this issue.

Note - My local IP address is already whitelisted on AZURE for MYSQL.

Regards,
Subhash

azure-database-mysql
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.

1 Answer

SubhashGander-1654 avatar image
0 Votes"
SubhashGander-1654 answered NavtejSaini-MSFT commented

This issue was resolved by simply recreating users.

CREATE USER 'XXX'@'%' IDENTIFIED BY 'XXX';

· 1
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.

Thank you @SubhashGander-1654 for posting your answer,

0 Votes 0 ·