In this article, we will see how to connect to Azure MySQL Database with new user from Workbench.
Steps to connect to Azure MySQL Database with new user from Workbench:
1. Connect to Azure portal, then click on Azure MySQL Server. From left menu click on connection security. Then, provide name for your firewall, IP address as show below. Then click on Save.
2. Open MySQL workbench.
3. Click on + symbol as as marked in the below image.
4. Then, provide connection name, select connection method, hostname and user name. User name should like username@hostname. david@couponmysql where user name is david and hostname is couponmysql.
5. Now, click on Test Connection.
We have successfully made connection to Azure MySQL Server.