distal-attribute
distal-attribute
distal-attribute
distal-attribute

Lost conection after Update

jogowa posted 2 years ago in General
I'm using now revision 4396 and now the old conection to my local database is corrupt.
I've got the Events:
/ * Connect to MySQL on localhost (TCP / IP), username root, password use: Yes ... * /
/ * SQL Error (2003) in statement # 0: Can not connect to MySQL server on 'localhost' (10061) * /
/ * Connect to MySQL on localhost (TCP / IP), username root, password use: Yes ... * /
/ * SQL Error (2003) in statement # 0: Can not connect to MySQL server on 'localhost' (10061) * /
/ * [Qnap-db] Connection to MySQL via qnap-drive (TCP / IP), username root, password use: Yes ... * /
/ * [Qnap-db] Connected. Process ID: 68039 * /

With the last used version 7 rev. 4388 it was working well.

Thr conections to extern Databases working well.
Thanks
ansgar posted 2 years ago
(Windows-) Firewall blocks it because you updated heidisql.exe?
kmette posted 2 years ago
I'm on Win7 machine - 64 bit and I added HeidiSQL to the allowed programs in the firewall but still errored. Then I turned the firewall OFF and tried with no luck.

Still getting the SQL Error (2003) when accessing my local machine. Other MySQL servers are responding perfectly.

Thanks.

Kevin
Misha v.3 posted 2 years ago
I have the same issue. Win7 Pro 64bit, MySQL 5.5.28, connection to localhost using TCP/IP with pre-saved password.

For now I downgraded back to 7.0 and it works fine.
ansgar posted 2 years ago
Shit, if that's not a firewall issue, what could cause such a pure localhost problem then?

Misha v.3 posted 2 years ago
No ideas.
I install 8.0 over 7.0 once again and get the same issue again.
I tried to disable firewall -- the issue still here.
Then I replace "localhost" by 127.0.0.1 and it is connected to local MySQL server without any problems.
I hope it helps.
jogowa posted 2 years ago
I've got the problem!
When I enter "localhost" in the field Hostname/IP the connection is not established.
With "127.0.0.1" it works. How ever.
Thanks for your help.
ansgar posted 2 years ago
Troubleshooting hints:
http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html
Misha v.3 posted 2 years ago
Thanks for the link.

- I can connect to local MySQL server using "localhost" server from HeidiSQL 7.0.
- I can connect to local MySQL server using "mysql -hlocalhost -uuser -ppassword" command.
- I can connect to local MySQL server using "telnet localhost 3306" command.

If you believe that this is not HeidiSQL 8.0 issue it is OK. Not a big deal to type in "127.0.0.1" instead of "localhost".
ansgar posted 2 years ago
I don't have that problem here, with the same HeidiSQL 8.0.0.4396 and "localhost".

One last question: Did you do a fresh install of HeidiSQL, or just an update? Please check and post the version of your installed libmysql.dll - you can see that in HeidiSQL's bottom status bar, when hovering with the mouse over the server version "MySQL x.x": "Client version: ???"

jfalch posted 2 years ago
this is most probably an ipv4/ipv6 issue. localhost on your machine is probably not bound to ipv4 127.0.0.1 (as it used to be), but to ipv6 ::1 - you can test this with a cmd window and the command ping localhost .

the mysql server listens for incoming requests on only one ip address, as specified by the bind param in its config file (my.cnf, my.ini). when this is 127.0.0.1, you can reach it via ipv4; i have not tried to use ::1 there.
this talks of using bind=0.0.0.0 - have not tried that either.
jogowa posted 2 years ago
I'm using the updates.
MySQL Server ist 5.5.27
Conectors:
ODBC 5.1.6
C++ 1.1.0
C 6.0.2
J 5.1.20.0
Net 6.5.4
I've to use this ODBC Connector because the new one dos'nt work with MSO Access 2010.
jogowa posted 2 years ago
@jfalch ping is givig a response from ::1:
So the Hosts file must have a change?
kmette posted 2 years ago
I did an uninstall of v7 and install of v8.

MySQL 5.1.61
libmysql 6.0.0

Using 127.0.0.1 does work.
ansgar posted 2 years ago
Could be the libmysql.dll bundled with HeidiSQL 7 did its own resolution of "localhost" to "127.0.0.1", while the newer libmysql from HeidiSQL 8 does not do that any longer. Now, your server may be bound to 127.0.0.1, or your hosts file has bound it to ::1, and there you got the problem.

Misha v.3 posted 2 years ago
I've installed version 8.0 over version 7.0
client libmysql version 6.0.0
ping localhost also response ::1:
There is no bind option in my.ini file.
There is no localhost binding in hosts file.
I overwrited libmysql.dll by the version from HeidiSQL 7.0 and localhost resolved correctly.
Misha v.3 posted 2 years ago
I've added line

bind-address=::


into mysqld section of my.ini and now HeidiSQL 8.0 can connect to local mysql server using libmysql 6.0 with "localhost".
jogowa posted 2 years ago
Thats it.

bind-address=::


Thanks for your posts.
Eddy-B posted 1 year ago
This issue is 3 months old... why is the solution not yet included in build 4499 ?
jfalch posted 1 year ago
because there is no solution to include. the problem depends on the changed behaviour of libmysql.dll, which is an external component, not under control of the heidisql developer. the only solution possible when using the newest version of libmysql.dll (which is advisable) is the one mentioned above, ie to modify the server configuration when using ipv6. for a client, it should also possibly work to download an earlier mysql distriution, extract libmysql.dll from that, and use it.

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