On Wed, Jul 17, 2002 at 02:42:23PM -0700, Jeremy Zawodny wrote: > On Wed, Jul 17, 2002 at 09:33:37PM +0100, Andy Smith wrote: > > > > > > 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, or else skip reading /etc/my.cnf (the one in the > > basedir and $HOME/.my.cnf is enough)? > > Put the most common stuff in /etc/my.cnf. > > Then put the instance-specific stuff in a my.cnf file in each server's > data directory. That should do the trick.
To expand on that, MySQL will read (in order): /etc/my.cnf <datadir>/my.cnf ~/my.cnf And use all the options in that order. Those read later in the process override those earlier in the process. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 48 days, processed 1,042,881,257 queries (246/sec. avg) --------------------------------------------------------------------- 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
