MySQL server question

[jabster]

hello yet again.

I am trying to set up a (small) MySQL server for my biker gang. I currently (temporarily) have the server setup on my machine, and will transfer it to a dedicated machine later on. I have 2 static IP addresses. One I'm using now, and the other I'll use for the MySQL server.

Here's my question/problem: I've got the user db set up. I left my computer on with MySQL running all day. I went to work and tried to log in, but got an error that user can't connect to that server. The user can connect locally, so it's not a username/password problem. I have hosts.deny set with All:ALL. DO I need to open a port up or something on my computer/server to allow people on the outside into the server? If so, how? If something else, what?

Thanks.

--john

[i8degrees]

Hello, what does the hosts.allow file look like? You have to put the IP addresses of the people you allow access to (in hosts.allow) or hosts.deny will block any connection.

[jabster]

hosts.allow is currently empty.

But what if don't know where people are going to login from? everybody else has 56k modems right now, dynamic ip addresses.

do i need to allow everything from aol.com for instance?

--john

[i8degrees]

Oh, well I don't know anything about setting up any servers, much less MySQL stuff. http://www.linuxnewbie.org/ubb/smile.gif I have just set up a local network so far. Sorry!

------------------
Windows for play and Linux for work.

[dex]

it doesn't sound like a problem with the hosts.deny or host.allow files, you should probrably double check to ensure that you
have the myqsl access system setup correctly.
It sounds like you need to create another account for yourself with access rights to connect from foreign computers aside from the local hosts. Check out the mysql documentation and search for "grant tables" or "user privileges". This should put you on the right path.

[jabster]

i do have allowable hosts as '%', but ill double check the server stuff and see what i may need to do.
thanks,
john

[jabster]

Ummmm....

It also helps to spell my name correctly in the user db. 8^P

D'oh!

--john