Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
Old 03-30-2009, 07:23 AM Remote MySQL???
Super Talker

Posts: 114
Name: Marijan Sivric
Trades: 0
Hello!

How can I access a remote MySql database? I have an application and I would like it to save various data to a MySQL database which is on a web hosting server...somewhere

How can I access it, what's the path to this database? If it's on my computer, it is "localhost", but what if it's far away?

Thank you very very much!
__________________

Please login or register to view this content. Registration is FREE
miksy123 is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 03-30-2009, 07:28 AM Re: Remote MySQL???
willcode4beer's Avatar
Super Moderator

Posts: 1,533
Name: Paul Davis
Location: San Francisco
Trades: 1
just replace localhost with the hostname or ip address of the remote MySql server.

You'll need to make sure it's configured to accept remote traffic though
__________________

Please login or register to view this content. Registration is FREE

willcode4beer is offline
Reply With Quote
View Public Profile
 
Old 03-30-2009, 07:38 AM Re: Remote MySQL???
Super Talker

Posts: 114
Name: Marijan Sivric
Trades: 0
Thank you!

But the problem is this. I can define which ip addresses can access it,but...
Here is the idea-I would like to make a multiplayer game in c++ and store player data,location etc. in a MySQL database because it's working fast!

Every player will have a different ip address, and of course I can't add each ip manually

I can allow all ip addresses to access the database, but I don't know what's gonna happen with the security!

Last edited by miksy123; 03-30-2009 at 07:40 AM.. Reason: Added more questions
miksy123 is offline
Reply With Quote
View Public Profile
 
Old 03-30-2009, 05:06 PM Re: Remote MySQL???
willcode4beer's Avatar
Super Moderator

Posts: 1,533
Name: Paul Davis
Location: San Francisco
Trades: 1
I meant the IP of the mysql server not the users.

on another topic, please tell me the client applications are not going to communicate directly with your MySql server.
__________________

Please login or register to view this content. Registration is FREE

willcode4beer is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to Remote MySQL???
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.14236 seconds with 12 queries