• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Remote Access

 
Ranch Hand
Posts: 641
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Is is possible to access the database(Mysql) which resides at www.xyz.com through a remote client. That is, can an application which DOES NOT reside on the server ( where the database is )can acess the database by specifying the following statements :
String url = "jdbc:mysql://ip of the site:3306/xxx?user=root&password=";
connection = DriverManager.getConnection(url);
Thanks in advance
 
Ranch Hand
Posts: 83
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by raghav mathur:
Is is possible to access the database(Mysql) which resides at www.xyz.com through a remote client. That is, can an application which DOES NOT reside on the server ( where the database is )can acess the database by specifying the following statements :
String url = "jdbc:mysql://ip of the site:3306/xxx?user=root&password=";
connection = DriverManager.getConnection(url);
Thanks in advance


Yes, as long as the owner of the database has given access privileges to the indicated user, coming from the given host. Since MySql allows one to use wild card hostnames when setting up privileges, it is indeed possible to allow root access from any client machine on the network. That is why the MySql documentation says that one of the first things you should do is give root a password and restrict access to the root account.
 
Raghav Mathur
Ranch Hand
Posts: 641
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by Kevin Mukhar:

Yes, as long as the owner of the database has given access privileges to the indicated user, coming from the given host. Since MySql allows one to use wild card hostnames when setting up privileges, it is indeed possible to allow root access from any client machine on the network. That is why the MySql documentation says that one of the first things you should do is give root a password and restrict access to the root account.


I spoke to my administrator and what he told me that he has already given permission for clients accessing the database other than localhost.
Does he have to specify IPS individually ? to which he wants to give access to ?
I continue to get the following exception:
NoRouteToHostException
This is the exception which occurs when i change the DB user to "root" and when again change it to the actual original one , it gives me "Acess Denied"
According to the administrator he has set the permission for the database so that client besides localhost can access the database .
PLease help me out
Thanks in advance
[ July 01, 2003: Message edited by: raghav mathur ]
 
Raghav Mathur
Ranch Hand
Posts: 641
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Any Suggestions ?
 
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hello,
Just got the same problem but this is with MS Access. How to connect the MS Access db file on a remote network?
Thanks,
Rema
 
Rema Remulta
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hello,
Got the same problem but this is with MS Access. Have to do remote accessing of database file, what are the right syntax or code when including the ip address of the machine where the file is stored? Normally, if it's not accessing on remote, the url is url="jdbc dbc RIVER={Microsoft Access Driver (*.mdb)};DBQ="mydb.mdb";
Some hints?
Cheers,
Rema
 
Rema Remulta
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hello,
Got the same problem but this is with MS Access. Have to do remote accessing of database file, what are the right syntax or code when including the ip address of the machine where the file is stored? Normally, if it's not accessing on remote, the url is url="jdbc dbc RIVER={Microsoft Access Driver (*.mdb)};DBQ="mydb.mdb";
Some hints?
Cheers,
Rema
 
Rema Remulta
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hello,
Got the same problem but this is with MS Access. Have to connect to the db file that resides in the other machine in a network. Normally, when the database access isn't done on a remote, the url is url="jdbc dbc RIVER={Microsoft Access Driver (*.mdb)};DBQ="mydb.mdb"; So what would be the parameters then when connecting on a remote? Some hints?
Thanks,
Rema
 
Rema Remulta
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hello,
Got the same problem but this is with MS Access. Have to connect to the db file that resides in the other machine in a network. Normally, when the database access isn't done on a remote, the url is url="jdbc dbc RIVER={Microsoft Access Driver (*.mdb)};DBQ="mydb.mdb"; So what would be the parameters then when connecting on a remote? Some hints?
Thanks,
Rema
 
The world's cheapest jedi mind trick: "Aw c'mon, why not read this tiny ad?"
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic