Meaningless Drivel is fun!
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

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
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
It's not a secret anymore!