Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: jeff on November 12, 2001, 11:42:15 PM

Title: remote access to MySQL
Post by: jeff on November 12, 2001, 11:42:15 PM

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?  

Any response would be greatly appreciated.
Thanks,

Jeff

Title: Re: remote access to MySQL
Post by: darren on November 14, 2001, 06:47:36 AM

you have to add a user to the mysql.db table
INSERT INTO db VALUES('Address', 'Database', 'User', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y')

use % as any

then you will find you have access
and the address is where you a accessing from if it changes all the time set it to
% but any one with a pwd can access it.
ps dont forget to add a user as well