I just set up a new app with App Service using the "db included" option.
However, I'm having trouble importing my database.
Here's the command I am using:
mysql -h mydbname.mysql.database.azure.com -u myusername -p sys
However, I keep getting the following error:
ERROR 2005 (HY000): Unknown MySQL server host 'mydbname.mysql.database.azure.com' (-2)
I obtained the Server Name and Server Admin Login Name from the Azure dashboard.
I double-checked the password, and when that didn't work, I reset the password and waited for the server to be rebooted and then tried again-- same error.
Some of the docs I looked at (like this one) mention setting up a firewall rule under "Connection security", but I can't find any security options on the admin screen for my database (Azure Database for MySQL flexible server).
Any help on how to get a connection to mySQL would be much appreciated.


