File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes mysql remote connection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "mysql remote connection" Watch "mysql remote connection" New topic

mysql remote connection

kev james

Joined: Apr 06, 2004
Posts: 1
Hi, I'm having a problem using an ip address to connect to my mysql database. If i connect using localhost like below it works great, however if i use my ip address as shown below as well, it cant connect.
Thanks for the help
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

Have you granted the remote IP permission to connect?
I'll go double check the syntax, but you have to execute the following on the database first:
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

more or less correct, except that you may require quotes around some stuff like the password, and you may also have to grant on <database> and <database>.*
I agree. Here's the link:
subject: mysql remote connection
jQuery in Action, 3rd edition