MySQL Workbench Unable to Connect to Azure Databases for MySQL

I hope your problem might have been already resolved.

However, I recently had a similar experience and I had to do following to resolve it.

1. Launch MySQL Workbench (Mine was 5.2.36 CE Revision 8542)
2. Double click on a server instance to manage the server instance
3. Goto Users and Privileges
4. Select root or other user you wish to check from the list in "Server Access Management" tab
5. Change the "Limit connectivity to hosts matching:" to IP that you are using to connect OR just change it to "%" to remove the IP restriction.<6> 6. In my case I had to change it to "%" to make it work.

Hope this will be helpful to someone, someday!
Cheers Manish.

After reseting root password, I could connect with workbench. I still can't connect with old users (which were already created), but connecting with root and creating new users with workbench allows me to connect with these new users.

It looks it has something to do with the password, or the way MySQL Server stores password for users. I don't know the actual reason for the error, but this solved my problem.

Thanks for the suggestions!