Search code examples
mysqlazureazure-database-mysql

Connection to Azure MySQL server fails due to incorrect connection string


When trying to connect to my MySQL server in Azure from mysql client, I get the following error, even though I am using the correct username and server name. How can I fix this?

The connection string may not be right. Please visit portal for references.


Solution

  • When connecting to your server instance of Azure Database for MySQL, you are required to follow the <username@hostname> format , whether you are doing it from mysqlexe client or MySQL workbench. We recommend you get the complete connection string for your client from the Azure portal and use it when connecting to your MySQL server.

    Read How to get Connection Information to understand more about how to connect to your MySQL server from various clients.