Azure-docs: Wrong documented command to connect to MySQL Server requiring SSL

[RobertoPrevato]

There is a wrong command documented here: Tutorial: Build a PHP and MySQL app in Azure.

Following the instructions, at the point Connect to production MySQL server locally, the command is documented as:

mysql -u <admin_user>@<mysql_server_name> -h <mysql_server_name>.mysql.database.azure.com -P 3306 -p

This doesn't work and fails with the following message:

ERROR 1045 (28000): Access denied for user '<USER>'@'<IP_ADDRESS>' (using password: YES)

Because SSL verification is required, as documented here.

The correct command (after following prior instructions in the same article) is as follows:

1. download the .pem file as documented here
2. add --ssl-mode=REQUIRED and --ssl-ca=

mysql -u <admin_user>@<mysql_server_name> -h <mysql_server_name>.mysql.database.azure.com -P 3306 -p<PASSWORD> --ssl-mode=REQUIRED --ssl-ca=<PATH_TO_PEM>

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 10b459c4-6266-6e0a-33a0-ee2ae2106036
• Version Independent ID: 34a6f1f5-cad7-6ce2-3019-2834dda6f828
• Content: Tutorial: PHP app with MySQL - Azure App Service
• Content Source: articles/app-service/app-service-web-tutorial-php-mysql.md
• Service: app-service
• GitHub Login: @cephalin
• Microsoft Alias: cephalin

[MarileeTurscak-MSFT]

@RobertoPrevato
Thanks for your feedback! We will investigate and update as appropriate.

[BryanTrach-MSFT]

@RobertoPrevato Thank you for bringing up this doc bug. We have made the suggested changes and those should be public in 24 hours.

We will now proceed to close this thread. If there are further questions regarding this matter, please tag me in your reply. We will gladly continue the discussion and we will reopen the issue.