0

I am not able to login into my application on azure environment.I have added driver class, username and password in my application properties file. I am using my sql workbench but everytime I login its showing me the error that connection string is not right. I have entered all correct details as shows in azure sql database in my app properties. please help?

Alberto Morillo
  • 13,893
  • 2
  • 24
  • 30
shagun dhiman
  • 7
  • 6
  • Have you visited the [official documentation](https://learn.microsoft.com/en-us/azure/mysql/connect-workbench) page? – Zohar Peled Mar 18 '19 at 10:52

2 Answers2

0

First of all, please upgrade your MySQL Workbench software to the latest version.

Please try to connect as shown on below image:

enter image description here

You can also use MySQL Workbench 8.0 CE, change your CMD directory to "C:\Program Files\MySQL\MySQL Workbench 8.0 CE". There you can use mysql.exe file and connect to Azure Database for Mysql.

Alberto Morillo
  • 13,893
  • 2
  • 24
  • 30
  • I am able to connect through my sql workbench. but in my application, I am not able to login into my application. I have written my database connection in a properties file but everytime i login it shows connection string is not right. – shagun dhiman Mar 19 '19 at 07:50
0

Firstly is make sure your connection string is right, you could go to portal get all connection strings.

Then make sure configure the right settings. When connecting from Azure App Service to Azure MySQL, you could choose Allow access to Azure services option will allow the app service to connect to the MySQL server. Or you could create a firewall rule to explicitly allow outbound IPs. The details about how to configure, you could refer to this site:Connect an existing Azure App Service to Azure Database for MySQL server.

George Chen
  • 13,703
  • 2
  • 11
  • 26