| View previous topic :: View next topic |
| Author |
Message |
Hymn
Joined: 12 Feb 2006
Posts: 3
|
| Posted: Sun Feb 12, 2006 3:19 am Post subject: MySQL Remotely from 2 Locations. No Go :( |
|
|
Well, just some background information.
I am running an online radio, and my broadcasting software requires me to use MySQL so it can categorize song names, and alot of other data.
In addition, SQL is the mainframe of my online request system, and currently playing song data.
I am using MySQL from Apache2Triad 1.5.3.
My broadcasting software (localhost) and my webhost (*****-fx.net) has to be able to access my SQL database.
For what ever reason, my computer (localhost) can access my SQL database, but my webhost can not.
My broadcasting software is out of the picture, and it is not a problem. Some reason, remote hosts can not access my SQL database.
Please help me / tell me how I can allow my Apache2Triad setup to allow external (remote) hosts, as well as internal (network) to access my SQL databases.
Thanks in advanced,
Hymn
PS. I have already tried removing the "bind-address" line in my.ini and it still wont work. |
|
| Back to top |
|
Twirp
Joined: 07 May 2005
Posts: 14
Location: Md
|
| Posted: Sun Feb 12, 2006 1:49 pm Post subject: |
|
|
You have to make sure you allow that computer to connect to MySQL.
(I'll post how when I get time... Sorry...) |
|
| Back to top |
|
Vlad Alexa Mancini
Joined: 07 Jul 2003
Posts: 1538
|
| Posted: Sun Feb 12, 2006 2:08 pm Post subject: |
|
|
just read the FAQ  damn Question #16 allready |
|
| Back to top |
|
Hymn
Joined: 12 Feb 2006
Posts: 3
|
| Posted: Mon Feb 20, 2006 7:15 pm Post subject: |
|
|
Vlad Alexa Mancini wrote: just read the FAQ damn Question #16 allready
just so ya know pal, that didnt and doesnt help a bit.
i need futher help.
...and yes i have port forwarding on TOO. |
|
| Back to top |
|
dawg
Joined: 11 Apr 2004
Posts: 180
|
| Posted: Mon Feb 20, 2006 9:13 pm Post subject: |
|
|
Did you try:
Quote:
Remove that line altogether and make mysql bind on all interfaces
as the FAQ reads?? |
|
| Back to top |
|
Hymn
Joined: 12 Feb 2006
Posts: 3
|
| Posted: Sat Mar 11, 2006 9:35 pm Post subject: |
|
|
yes, i have tried that too...
...been busy working on other things so i havent been able to get on here.
it'd still be nice if there was a SOLUTION to this.
-hymn |
|
| Back to top |
|
Joshua Meadows (DemoRic)
Joined: 29 Dec 2004
Posts: 783
Location: S.E. Kansas
|
| Posted: Sun Mar 12, 2006 12:01 am Post subject: |
|
|
since your having such difficulty, is it possible for you to use an ssl tunnel?
I've used this for MySQL connections between pc's within a network using stunnel. It has the added benifet of having an ssl data channel.
it works along these lines (forgive the crude diagram)
LocalhostMySQLport -> stunnelservice -> SSL -> stunnelclient -> MySQLClient
http://www.stunnel.org/
http://www.google.com/search?q=mysql+stunnel |
|
| Back to top |
|
| |
