Azure Mysql Connection Issue

Question

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

Answer 1

This issue was resolved by simply recreating users.

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