Topic: remote access to MySQL

[jeff]

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

[darren]

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