Menu
I'm having problem trying to access the MySQL server (I'd like to replace a table with another) provided as part of the Windows Azure service. I have downloaded the publishsettings XML file, and the closest thing that I can find is 'Data Source=us-cdbr-azure-east-a.cloudapp.net;'. However, it's not accessible from the web browser, so I'm not sure what to do next.
464
Choosing the "Allow access to Azure services" option will allow the app service to connect to the MySQL server. On the MySQL server blade, under the Settings heading, click Connection Security to open the Connection Security blade for Azure Database for MySQL. Select ON in Allow access to Azure services, then Save.
Always use port 3306 when connecting to Azure Database for MySQL. Type in the server admin login username supplied when you created the Azure Database for MySQL earlier. Our example username is myadmin. Follow the steps in the previous section to get the connection information if you do not remember the username.
You can get the full connection string from the dashboard of your Azure Web Site
Then you can use those credentials in a MySQL administration program, such as MySQL Workbench.
165
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
