Connection to Azure MySQL server fails due to incorrect connection string

mysql azure azure-database-mysql
Shantanu picture Shantanu · May 18, 2017 · Viewed 23k times · Source

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.

Answer

Shantanu picture Shantanu · May 18, 2017

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.

Related questions

Why does connection to my MySQL server in Azure fail if my app does not have SSL enabled?

I get a connection failure when I try to connect to my MySQL server in Azure from my app/client, which does not have SSL enabled. The error message is as follows: SSL connection is required. Please specify SSL options …

Read More
ERROR 1064 (42000) in MySQL

I am trying to populate a new MySQL empty database with a db dump created from MS SQL Azure database, and I get the following error ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; Check the manual …

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More