Koozali.org: home of the SME Server
Legacy Forums => Experienced User Forum => Topic started by: jeff on November 13, 2001, 05:34:07 AM
-
I'm trying to set up a remote MySQL server on my e-smith machine for a school project. I don't seem to be able to connect remotely. Everything works locally. I have all of the passwords and users set up ok, but when I try to connect from a remote computer, it won't work. I read somewhere that there is a firewall that only allows local access to server programs. Is this accurate? And, is there some way that I can disable it? Or, does my problem lie elswhere?
I need to run it for about two weeks. I don't care about security.
I'm new to this and I'm having alot of difficulty. I've spent hours looking at other posts, as well as reading documentation and I'm about to give up. This is my last hope.
I'm just a rookie at this stuff and any feedback would be a big help.
Thanks,
Jeff
-
As always, you would have been better off reading the mysql-docs :)
You might want to search it for the GRANT statement, as your problem lies in the fact that will have to grant some (remote) host access to your MySQL-db
Another way is to edit the entry in the mysql-db, in table user:
replace the host with * (or might be %, cannot remember right now)
instead of localhost. That will allow other hosts than your localhost to connect to the db. Then restart MySql.
Good luck,
Bart
-
Thanks for the response Bart. I've spent hours going through the MySQL docs and I still can't get it to work. I've granted all priveleges to users , I have the wildcare '%' in the table for the all the users' 'host' and it won't work. I'm thinking my problem lies in the e-smiths 'hosts.allow' and 'hosts.deny' files. It seems to only allow remote access for some applications and MySQL isn't one of them. All the documentation is geared towards not allowing access and improving security and there is little regarding how to let people in.
Anyways,
Thanks.
If anyone has any other ideas I would appreciate them .
-
Just curious, can the server be reached at all from outside of your local network?
-
Yes, it can be reached through telnet.
I have set all of the options on the remote access section of the web server administration to be public....
-
Hmmm.... We need help here!