1

I have a MySQL database on a Linux server that I am able to access through putty logging into servers terminal. When I try to connect to the MySQL database remotely, I get the error:

Lost connection to MySQL server at 'reading initial communication packet, system error: 0

I have added bind-address:127.0.0.1 in my.cnf file and port 3306 is already opened. What other configurations do I need to change to be able to connect to MySQL remotely?

I am using Navicat / HeidiSQL + SSH to connect remotely.

0

1 Answer 1

1

Your bind-address needs to be 0.0.0.0 or at the very least the IP address of the interface you will be connecting to from your remote machine.

If you set it to 127.0.0.1 only loopback connections from the server can be made.

1
  • ok,does 0.0.0.0 enable connectivity from all remote machines. apart from this any other configuration changes i need to make?? Jul 30, 2015 at 10:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.