Hmmm..

 
Post new topic   Reply to topic    Aprelium Forum Index -> Databases
View previous topic :: View next topic  
Author Message
leaker07
-


Joined: 11 Apr 2008
Posts: 28

PostPosted: Sun May 25, 2008 3:17 pm    Post subject: Hmmm.. Reply with quote

Accessing MYSQL Database Remotely?
Coz like I would want a webhost to just host the pages but I want the databases to come from My PC.
_________________
E.Yo~!
Back to top View user's profile Send private message
rrinc
-


Joined: 24 Feb 2006
Posts: 725
Location: Arkansas, USA

PostPosted: Sun May 25, 2008 4:03 pm    Post subject: Reply with quote

This is easily done. You just need to make sure your computer is accessible and if you have a dynamic IP I would suggest you have a dynamic DNS setup. MySQL just has to be allowed to accept connections from any host (or specifically your webhosting). When installing a script just set the Database Host as your dynamic dns subdomain or IP.
_________________
-Blake | New Server :D
SaveTheInternet
Soy hispanohablante. Puedes contactarme por mensajes privados.
Back to top View user's profile Send private message Visit poster's website Yahoo Messenger MSN Messenger
leaker07
-


Joined: 11 Apr 2008
Posts: 28

PostPosted: Sun May 25, 2008 11:00 pm    Post subject: Hmm.. Reply with quote

Yeah..
I tried that already..
I replaced localhost with my DNS Setup then root and my password..
When I open the webpage it says
Error Code 1..
Then like some words..
See.
http://spherepatcher.zxq.net/sgcp/

Wait.
Before you answer that,
How do you allow MYSQL to accept connections from the webhost?
_________________
E.Yo~!
Back to top View user's profile Send private message
Moxxnixx
-


Joined: 21 Jun 2003
Posts: 1226
Location: Florida

PostPosted: Mon May 26, 2008 12:10 am    Post subject: Reply with quote

If you're going through a router, you need to forward port 3306 to allow external connections to MySQL.
Back to top View user's profile Send private message Visit poster's website
leaker07
-


Joined: 11 Apr 2008
Posts: 28

PostPosted: Mon May 26, 2008 1:28 am    Post subject: Mmm.. Reply with quote

Uhmm..
This question is stupid but for connecting remotely is the username still root?
Anyway..
Tried it but it still hasn't worked.
Is there any other more specific way?
_________________
E.Yo~!
Back to top View user's profile Send private message
rrinc
-


Joined: 24 Feb 2006
Posts: 725
Location: Arkansas, USA

PostPosted: Mon May 26, 2008 4:45 am    Post subject: Reply with quote

Yes. But personally I would make a less privileged account for remote access. Make sure your user is configured to accept remote connections.
_________________
-Blake | New Server :D
SaveTheInternet
Soy hispanohablante. Puedes contactarme por mensajes privados.
Back to top View user's profile Send private message Visit poster's website Yahoo Messenger MSN Messenger
leaker07
-


Joined: 11 Apr 2008
Posts: 28

PostPosted: Mon May 26, 2008 6:50 am    Post subject: Hmm.. Reply with quote

[quote=rrinc]Yes. But personally I would make a less privileged account for remote access. Make sure your user is configured to accept remote connections.[/quote]

For that you mean by the on in the Instance COnfigure w/e in MySQL?
OH and about the username for remote connections is it still "root"?[/quote]
_________________
E.Yo~!
Back to top View user's profile Send private message
leaker07
-


Joined: 11 Apr 2008
Posts: 28

PostPosted: Mon May 26, 2008 6:51 am    Post subject: Re: Hmm.. Reply with quote

leaker07 wrote:
[quote=rrinc]Yes. But personally I would make a less privileged account for remote access. Make sure your user is configured to accept remote connections.


For that you mean by the on in the Instance COnfigure w/e in MySQL?
OH and about the username for remote connections is it still "root"?

~(Crap not sure why It double posted when I pressed edit.
Dang Sry bout that)
_________________
E.Yo~!
Back to top View user's profile Send private message
rrinc
-


Joined: 24 Feb 2006
Posts: 725
Location: Arkansas, USA

PostPosted: Mon May 26, 2008 7:55 am    Post subject: Reply with quote

You should get phpMyAdmin, it makes this much easier to configure.
_________________
-Blake | New Server :D
SaveTheInternet
Soy hispanohablante. Puedes contactarme por mensajes privados.
Back to top View user's profile Send private message Visit poster's website Yahoo Messenger MSN Messenger
leaker07
-


Joined: 11 Apr 2008
Posts: 28

PostPosted: Mon May 26, 2008 2:36 pm    Post subject: hmm.. Reply with quote

Oh..
Do you have a guide?
_________________
E.Yo~!
Back to top View user's profile Send private message
AbyssUnderground
-


Joined: 31 Dec 2004
Posts: 3855

PostPosted: Mon May 26, 2008 3:14 pm    Post subject: Re: hmm.. Reply with quote

leaker07 wrote:
Oh..
Do you have a guide?


www.abyssunderground.co.uk will help you with phpMyAdmin.
_________________
Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk
Back to top View user's profile Send private message Visit poster's website
leaker07
-


Joined: 11 Apr 2008
Posts: 28

PostPosted: Mon May 26, 2008 4:25 pm    Post subject: mmm.. Reply with quote

Hmm..
W/e..
I can't even connect to my own sql server from my own pc if I use my ipaddress for the host..
damn..
For the username how do I put it in?
Just root?
_________________
E.Yo~!
Back to top View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Aprelium Forum Index -> Databases All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB phpBB Group