View previous topic :: View next topic |
Author |
Message |
leaker07 -
Joined: 11 Apr 2008 Posts: 28
|
Posted: Sun May 25, 2008 3:17 pm Post subject: Hmmm.. |
|
|
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 |
|
|
rrinc -
Joined: 24 Feb 2006 Posts: 725 Location: Arkansas, USA
|
Posted: Sun May 25, 2008 4:03 pm Post subject: |
|
|
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 |
|
|
leaker07 -
Joined: 11 Apr 2008 Posts: 28
|
Posted: Sun May 25, 2008 11:00 pm Post subject: Hmm.. |
|
|
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 |
|
|
Moxxnixx -
Joined: 21 Jun 2003 Posts: 1226 Location: Florida
|
Posted: Mon May 26, 2008 12:10 am Post subject: |
|
|
If you're going through a router, you need to forward port 3306 to allow external connections to MySQL. |
|
Back to top |
|
|
leaker07 -
Joined: 11 Apr 2008 Posts: 28
|
Posted: Mon May 26, 2008 1:28 am Post subject: Mmm.. |
|
|
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 |
|
|
rrinc -
Joined: 24 Feb 2006 Posts: 725 Location: Arkansas, USA
|
Posted: Mon May 26, 2008 4:45 am Post subject: |
|
|
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 |
|
|
leaker07 -
Joined: 11 Apr 2008 Posts: 28
|
Posted: Mon May 26, 2008 6:50 am Post subject: Hmm.. |
|
|
[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 |
|
|
leaker07 -
Joined: 11 Apr 2008 Posts: 28
|
Posted: Mon May 26, 2008 6:51 am Post subject: Re: Hmm.. |
|
|
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 |
|
|
rrinc -
Joined: 24 Feb 2006 Posts: 725 Location: Arkansas, USA
|
Posted: Mon May 26, 2008 7:55 am Post subject: |
|
|
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 |
|
|
leaker07 -
Joined: 11 Apr 2008 Posts: 28
|
Posted: Mon May 26, 2008 2:36 pm Post subject: hmm.. |
|
|
Oh..
Do you have a guide? _________________ E.Yo~! |
|
Back to top |
|
|
AbyssUnderground -
Joined: 31 Dec 2004 Posts: 3855
|
|
Back to top |
|
|
leaker07 -
Joined: 11 Apr 2008 Posts: 28
|
Posted: Mon May 26, 2008 4:25 pm Post subject: mmm.. |
|
|
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 |
|
|
|