How do I connect to my mysql database from a remote host?

August 11, 2014 1.7k views

Is it possible to connect to my database remotely using jdbc, like
jdbc:mysql://<myipaddress>/db?
I've tried all the possible combinations of host/port/db/user and don't seem to get anywhere. I created an user with phpMyAdmin that should allow connections from any host.

1 Answer

Please ensure your my.cnf specifies that the bind-address is not 127.0.0.1, and that skip-networking is not specified. Otherwise your mysqld is not listening on any interface that can receive traffic from a remote host.

Have another answer? Share your knowledge.