The thing you want to connect to, is it Azure SQL database?

Well, how can I help you?

Can you tell the steps

To do so easily

Of course

1. Install Linux

Yes then

Have you already finished?

What distro do you use?

I want to istall it from mysql site

I use windows 10

You need Linux

No it can be done on windows too

How do you know? And why are you not finished yet?

Check the requirement section if it had any missing requirement ?

Not sure but I think you should try installing latest version of visual c++ redistributable package

it’s a good idea in my opinion, probably fast enough if you can filter a good amount of results in first

i suppose that you can’t change that table’s engine because of the incremental backup, am i wrong?

Anyone here can provide solution for below issue related to connectivity.

I have mysql server 5.7.25 installed on azure vm (CentOS server). I have created one user for remote connection and while it is working from command line it’s throughing error while trying to connect from mysql workbench 8.0.23.

Error msg : failed to connect to mysql at ip address:port with username
Unable to connect to localhost.

Anyone faced this issue?

Open file
vi /etc/my.cnf
And add
bind-address=ip of your vm

Is that machine on azure?
Are in the same machine/host?

You are trying to connect to localhost

To what host did your try to connect and from which host?

Kinda you can’t connect from command line through Workbench.

Where is this Workbench running?

Why would I do that, I want to allow remote connections

Local laptop on which I have mysql workbench installed and azure vm on which mysql server installed

Hello , Does proxysql restarts failed read transaction when a particular slave server in a hostgroup crashes. It has multiple slaves in that hostgroup. Does it resend the transaction to other slaves?

Usually there is no net connection at all from the outside world to the hosted services. So you can’t connect locally installed MySQL work bench from your PC to the hosted MySQL, the latter clean only be connected from the local network of the provider, or through some VPN to the local network of the provider.

Do you have MySQL installed on an Azure host? Who have installed it there?

Isn’t it SQL Azure Database ?

I don’t know for sure, but I suspect transactions are not restarted.

Installed on azure vm normally like we install on any premise servers
Azure sql database is azure service

The thing you want to connect to, is it Azure SQL database?

Mysql community server installed on azure vm

Ok, then you can connect to it

While am using putty to login to the host and then accessing mysql using mysql -uroot -p it’s working
But its not working from workbench it’s giving localhost error but mysql workbench is not even installed on localhost it is supposed to be a remote connection

You must install some VPN connection to the provider’s network and connect via it.

F.e. you can use ssh tunnel provided by PUTty.

And you’d better throw this MySQL work bench away and use some normal client