Question

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

Posted August 11, 2014 2.6k 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.

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

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.

Submit an Answer