Connecting to Azure MySQL server through Cloud Shell

Question

I followed this guide to connect to the Azure MySQL server through cloud shell. However, when attempting to login with the command:

mysql -h salmon-project.database.windows.net -u djangouser@salmon-project -p

I get the error:

ERROR 9002 (28000): The server name you tried cannot be found: salmon-project. Please check the Username and retry connection. The Username should be in <username@hostname> format.

I don't understand why cloud shell can't find my server.

Answer 1

Hi @jolateh , welcome to Microsoft Q&A forum.

The host that you are trying to connect is Azure SQL Server where the command you are using is for Azure MySQL Database. Please check below:

Azure Database for MySQL should be in this format: xxxxxxx.mysql.database.azure.com
Azure SQL Server should be in this format: xxxxxxx.database.windows.net

You can once check the server name as highlighted in below screenshot:

----------

If answer helps, please mark it 'Accept Answer'