How to connect to a remote MySQL database with Java?

by

Just supply the IP / hostname of the remote machine in your database connection string, instead of localhost. For example:

jdbc:mysql://192.168.15.25:3306/yourdatabase

Make sure there is no firewall blocking the access to port 3306

Also, make sure the user you are connecting with is allowed to connect from this particular hostname. For development environments it is safe to do this by 'username'@'%'. Check the user creation manual and the GRANT manual.

More Related Contents:

  1. Connect Java to a MySQL database
  2. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  3. Solving a “communications link failure” with JDBC and MySQL [duplicate]
  4. MySQLSyntaxErrorException near “?” when trying to execute PreparedStatement
  5. Can we connect remote MySQL database in Android using JDBC? [closed]
  6. java.sql.SQLException Parameter index out of range (1 > number of parameters, which is 0) [closed]
  7. Cannot issue data manipulation statements with executeQuery()
  8. Handling MySQL datetimes and timestamps in Java
  9. java.sql.SQLException: Access denied for user ‘root’@’localhost’ (using password: YES)
  10. JDBC MySql connection pooling practices to avoid exhausted connection pool
  11. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  12. right syntax to use near ‘?’
  13. Running a .sql script using MySQL with JDBC
  14. Java JDBC Access denied for user [closed]
  15. Passing parameters to a JDBC PreparedStatement
  16. JDBC character encoding
  17. JDBC returning MySQLSyntaxError Exception with correct statement
  18. Problems reading/writing UTF-8 data in MySQL from Java using JDBC connector 5.1
  19. MySQL connector error “The server time zone value Central European Time” [duplicate]
  20. com.mysql.jdbc.PacketTooBigException
  21. Error “A JNI error has occurred. Please check your installation and try again in Eclipse x86 Windows 8.1”
  22. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server [duplicate]
  23. Should a database connection stay open all the time or only be opened when needed?
  24. No matter what, I can’t batch MySQL INSERT statements in Hibernate
  25. Converting mysql table to spark dataset is very slow compared to same from csv file
  26. MySQL & Java – Get id of the last inserted value (JDBC) [duplicate]
  27. Performance of MySQL Insert statements in Java: Batch mode prepared statements vs single insert with multiple values
  28. A persistent connection with JDBC to MySQL
  29. JDBC MySQL connection using Unix Socket
  30. JDBC connection error : unrecognized timezone [duplicate]

Leave a Comment