Hi, Andy Smith wrote: > > On Wed, Jul 17, 2002 at 01:24:41PM -0700, Jeremy Zawodny wrote: > > On Wed, Jul 17, 2002 at 08:04:47PM +0100, Andy Smith wrote: > > > Hi, > > > > > > I've compiled mysql-4.0.2-alpha from source, and I cannot seem to > > > get it to bind to an interface and allow TCP connections. > > > > > > When I do a SHOW VARIABLES I see skip_networking=ON yet I am not > > > starting mysql with --skip-networking. To reverse this situation I > > > tried putting: > > > > > > set-variable = skip_networking=OFF > > > > > > in my.cnf, but it told me it was an unknown variable. > > > > > > Anyone got any ideas? > > > > Is there a rogue .my.cnf file or my.cnf lurking about elsewhere maybe? > > Ah, you're absolutely right. In /etc/my.conf there appears > > skip-networking > > The problem is, I need to run multiple mysql servers on this > machine. Is there a way I can reverse the effect of > skip-networking,
Yes, Comment out or remove the line > or else skip reading /etc/my.cnf (the one in the > basedir and $HOME/.my.cnf is enough)? > Yes, Place the ``my.cnf'' file into the --datadir= > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php