How to make Database Accessible worldwide

Question

0.00/5 (No votes)

See more:

I am developing a project whose database I want to keep global, i.e. my application can access it remotely. So how many ways can I achieve that? Is it possible if I install MySQL in one machine and provide a static IP to that machine and provide that link to my application? Please help...

Posted 30-Jul-13 3:33am

Sarjit

Add a Solution

Comments

Prasad Khandekar 30-Jul-13 9:35am

Exposing database directly over the internet is not a good idea. Instead try to create web services and publish those. Who are all the intended users? Is everyone in this world can use your app?

Sarjit 30-Jul-13 12:52pm

Yes that's right Prasad Khandekar anyone can access it... And m not going to expose it... But my idea is I will provide the connection string(containg my static IP and directory containing DBMS) of my database to JDBC...Will it work then?

ZurdoDev 30-Jul-13 16:38pm

1. Reply to the comment so that the user is notified instead of adding a new comment to your own question.
2. The way you are describing this, yes, you are exposing your database to the whole world. As Prasad said, use webservices or some other method to control it much better and only expose what you need to. Then your webservice can be exposed to the world.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mohibur Rashid · Accepted Answer · 2013-07-30T15:59:00

First of all follow the suggestion of Prasad Khandekar.

Secondly if you want to access mysql from outside world you would need two thing.

1. Server which is accessible from outside world
2. User account properly configured to access from outside world.

about 2:
say if you are connected in your local machine with IP. 192.1681.1.100

now you want to create a user name user1 with some privileges who will be able to connect with your machine with the ip 192.168.1.100

so you will have to create a user with name user1 and host "192.168.1.100", then user who can access 192.168.1.100 will be able to connect with your server.

Now, say you have a machine, who has IP 192.168.1.100 in local and out-side world can access this machine using this ip 173.194.38.95(actually this ip response is from google.co.jp). So when people from outside your local net will want to use this mysql then they will have to request:

C++

#mysql -h 173.194.38.95 -u user1 -p

But server will deny that request. Cause user1 only response for host 192.168.1.100, in this case you will have to create another user name user1 with host 173.194.38.95

Now if you don't care about the host issue. then just set the host to '%' that will cover everything(It should be my first line)