Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

"Cannot connect to MySQL server on 'Webserver IP" (10061)"

Marcel99's profile image Marcel99 posted 4 weeks ago in General Permalink

Hello,

I made a Ubuntu Web-Server and installed mariadb on it. Now i wanted to create a database table with heidisql. I added my server IP but i get the messag: "Cannot connect to MySQL server on 'Webserver IP" (10061)"

BubikolRamios's profile image BubikolRamios posted 4 weeks ago Permalink

Firewall block ?

bob's profile image bob posted 2 weeks ago Permalink

i am not sure. both of my computers, 100% of my connections are now doing this, while mysql workbench connected fine. connections that have been working for the past many months.

ClarkeyBoy1987's profile image ClarkeyBoy1987 posted 2 days ago Permalink

I get a similar error when connecting to localhost in HeidiSQL without first connecting in MySQL Workbench.

If you connect in Workbench first, can you then connect in HeidiSQL?

Note that this happens, for me, every time I reboot.

bob's profile image bob posted 2 days ago Permalink

ah forgot about this: follow up time - for me, it was caused by hyper-v. when you enable it, it makes new virtual network adaptors, and then for some unholy reason it also makes virtual duplicates of all the ones you already have. heidisql was unable to navigate this dumpster fire to choose the correct interface, while mysql workbench was. once i right click disabled all the hyper-v interfaces in Network Connections, heidisql worked again.

heidi probably legit needs an interface selector since workbench was able to figure out which one actually works.

bob's profile image bob posted 2 days ago Permalink

(im using it in ssh tunnel mode in this case. the ssh part worked. but either the local port forward was bound to a bad adapter or heidi was looking at the wrong one. it doesnt tell me much to know exactly how it went wrong, only that it was.)

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.