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.