how to connect my sql on azure via MySQL workbench

Question

how to connect my sql on azure via MySQL workbench

abdulraheem 20

I have a virtual machine on Azure, accessed via SSH from my Ubuntu system. I set up a database on the VM and want to connect to it using MySQL Workbench for easier modifications, without using SSH in the terminal. Despite following the Azure help page instructions, I keep encountering the error below:

Screenshot 2024-09-06 100742

Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2024-09-06T20:32:31.3266667+00:00

@abdulraheem Thank you for reaching out and sorry aout the issue you are facing connecting to your dB hosted in an azure virtual machine accessed via SSH from MySQL workbench.

Could you please share a screen shot to the sample below when you clicked on edit connection.

Please check this link, it might also be helpful https://learn.microsoft.com/en-us/azure/mysql/flexible-server/quickstart-create-connect-server-vnet
abdulraheem 20 Reputation points

2024-09-09T15:35:04.3866667+00:00
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2024-09-09T21:33:59.6566667+00:00
@abdulraheem Thank you for providing the information.

Could you please check if you have enabled ClientIP from the Azure Portal like below screen shot.

If you created your flexible server with Private access (VNet Integration), you will need to connect to your server from a resource within the same VNet as your server. You can create a virtual machine and add it to the VNet created with your flexible server. Refer to Create and manage an Azure Database for MySQL flexible server virtual network using Azure CLI.

If you created your flexible server with Public access (allowed IP addresses), you can add your local IP address to the list of firewall rules on your server. Refer to Create and manage Azure Database for MySQL flexible server firewall rules using the Azure CLI.
abdulraheem 20 Reputation points

2024-09-10T12:35:55.12+00:00

here what I have on my end
abdulraheem 20 Reputation points

2024-09-10T12:38:08.38+00:00

here what I have on my end
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2024-09-10T21:59:29.7866667+00:00

@abdulraheem

From what I understand, you are trying to connect to a MYSQL flexible server with VNET integration.

To connect to Azure Database for MySQL from on-premises sources, such as your laptop, a PC, or a VM, you will need to create a site-to-site VPN connection which is the same scenario as the one you describe above from my understanding. Your source is on-premises, and your Azure Database for MySQL server is in a vNet that’s connected to a central hub vNet that acts as a gateway.

You can follow the doc to create a Site2Site VPN connection.

https://learn.microsoft.com/en-us/azure/vpn-gateway/tutorial-site-to-site-portal#VNetGateway

Once that is done then you can try connecting to your DB from MYSQL Workbench using the details below.
abdulraheem 20 Reputation points

2024-09-13T11:10:21.36+00:00

Hi @Oury Ba-MSFT just wanted to confirm if is there any special benefit of this site-to-site VPN connection?

just saw your response.
abdulraheem 20 Reputation points

2024-09-13T17:23:29.7266667+00:00

Thank you problem solved

Accepted answer

0 additional answers

Your answer

Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2024-09-06T20:32:31.3266667+00:00

@abdulraheem Thank you for reaching out and sorry aout the issue you are facing connecting to your dB hosted in an azure virtual machine accessed via SSH from MySQL workbench.

Could you please share a screen shot to the sample below when you clicked on edit connection.

Please check this link, it might also be helpful https://learn.microsoft.com/en-us/azure/mysql/flexible-server/quickstart-create-connect-server-vnet
abdulraheem 20 Reputation points

2024-09-09T15:35:04.3866667+00:00
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2024-09-09T21:33:59.6566667+00:00

@abdulraheem Thank you for providing the information.

Could you please check if you have enabled ClientIP from the Azure Portal like below screen shot.

If you created your flexible server with Private access (VNet Integration), you will need to connect to your server from a resource within the same VNet as your server. You can create a virtual machine and add it to the VNet created with your flexible server. Refer to Create and manage an Azure Database for MySQL flexible server virtual network using Azure CLI.

If you created your flexible server with Public access (allowed IP addresses), you can add your local IP address to the list of firewall rules on your server. Refer to Create and manage Azure Database for MySQL flexible server firewall rules using the Azure CLI.
abdulraheem 20 Reputation points

2024-09-10T12:35:55.12+00:00

here what I have on my end
abdulraheem 20 Reputation points

2024-09-10T12:38:08.38+00:00

here what I have on my end
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2024-09-10T21:59:29.7866667+00:00

@abdulraheem

From what I understand, you are trying to connect to a MYSQL flexible server with VNET integration.

To connect to Azure Database for MySQL from on-premises sources, such as your laptop, a PC, or a VM, you will need to create a site-to-site VPN connection which is the same scenario as the one you describe above from my understanding. Your source is on-premises, and your Azure Database for MySQL server is in a vNet that’s connected to a central hub vNet that acts as a gateway.

You can follow the doc to create a Site2Site VPN connection.

https://learn.microsoft.com/en-us/azure/vpn-gateway/tutorial-site-to-site-portal#VNetGateway

Once that is done then you can try connecting to your DB from MYSQL Workbench using the details below.
abdulraheem 20 Reputation points

2024-09-13T11:10:21.36+00:00

Hi @Oury Ba-MSFT just wanted to confirm if is there any special benefit of this site-to-site VPN connection?

just saw your response.
abdulraheem 20 Reputation points

2024-09-13T17:23:29.7266667+00:00

Thank you problem solved

Answer 1

Vinodh247 34,661 MVP Volunteer Moderator

Hi abdulraheem,

Thanks for reaching out to Microsoft Q&A.

You are trying to connect to a MySQL database on an Azure Virtual Machine using MySQL Workbench from your local Ubuntu system, but you're encountering an error. The error message mentions that it cannot connect to the database server and refers to potential issues with rights, the MySQL server address, and port reachability.

SSH into your Azure VM and check if MySQL is running
MySQL, by default, listens on localhost (127.0.0.1). To allow remote connections, ensure that the the server is bound to the correct IP address
Make sure the user you are using (mdsteogust in this case) has access from remote machines
Ensure that port 3306 (default MySQL port) is open for inbound traffic in the NSG settings of your azure vm
Once the steps above are completed, go back to MySQL Workbench and use the public IP of your azure vm in the connection settings

Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.

abdulraheem 20 Reputation points

2024-09-06T15:19:26.81+00:00
''To allow remote connections, ensure that the server is bound to the correct IP address'' How?

. ''Make sure the user you are using (mdsteogust in this case) has access from remote machines''
here I have a problem too when I ssh the user name is ky-admin@xyz so I don't know why on Azure sql page the username is ''mdsteogust''

yes it is running on port 3306
abdulraheem 20 Reputation points

2024-09-06T15:28:01.1+00:00
how?
"To allow remote connections, ensure that the the server is bound to the correct IP address"

"Make sure the user you are using (mdsteogust in this case) has access from remote machines"
here when I ssh the VM name is 'ky-admin' but on the azure MySQL portal page it shows 'mdsteogust'.

Yes, port 3306 is opened.
Vinodh247 34,661 Reputation points MVP Volunteer Moderator

2024-09-07T13:03:24.21+00:00
To allow mysql to accept remote connections, you need to make sure that MySQL is not only listening on localhost (127.0.0.1) but on the public IP address of the VM or on all interfaces (0.0.0.0).

Steps:

Open the MySQL configuration file:

SSH into your Azure VM as ky-admin:
ssh ky-admin@<VM_Public_IP>

Once connected, open the MySQL configuration file using a text editor:
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

Locate the bind-address directive:

Find the line that contains:
bind-address = 127.0.0.1

Change this line to:
bind-address = 0.0.0.0
This will allow MySQL to listen on all network interfaces.
Vinodh247 34,661 Reputation points MVP Volunteer Moderator

2024-09-09T13:19:24.07+00:00

abdulraheem: Just checking if you had a chance to look at this. if so, can you please update it?
abdulraheem 20 Reputation points

2024-09-09T15:30:36.8133333+00:00

I have done this
abdulraheem 20 Reputation points

2024-09-09T15:45:09.0533333+00:00
Vinodh247 34,661 Reputation points MVP Volunteer Moderator

2024-09-09T15:57:26.0266667+00:00

are you still facing the same error?
abdulraheem 20 Reputation points

2024-09-09T16:13:05.3433333+00:00

yes, should I share my Azure portal page settings here?
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
abdulraheem 20 Reputation points

2024-09-09T16:49:12.3533333+00:00
abdulraheem 20 Reputation points

2024-09-09T17:13:51.7566667+00:00

this is the db from cli when I ssh
abdulraheem 20 Reputation points

2024-09-13T17:23:02.7466667+00:00

so I had two lines
bind-address = 0.0.0.0
mysqlx-bind-address = 127.0.0.0 (you need to also change to 0.0.0.0 for it to work)

Thanks

Share via

how to connect my sql on azure via MySQL workbench

0 additional answers

Your answer