As far as my fuzzy memory of the install process goes, the install_db
script made the /etc/mysql directory and put the my.cnf file there. In the
my.cnf file, it says
# You can copy this to one of:
# /etc/mysql/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /var/lib/mysql) or
# ~/.my.cnf to set user-specific options.
Since this was how it was setup, I figured it was correct.
At 03:30 PM 2/27/01 +0200, Sinisa Milivojevic wrote:
>Joel Gwynn writes:
> > I'm running mysql 3.23.33 on debian. I'm using /etc/init.d/mysql.server
> > to start up and shut down mysql server. My configuration file is
> > /etc/mysql/my.cnf. In that file, I've set my socket as follows:
> >
> > socket = /var/run/mysqld/mysqld.sock
> >
> > When mysql starts, it seems to ignore this directive, and set up the socket
> > on /tmp/mysql.sock. I looked into the mysql.server file, and found that it
> > was looking for my.cnf at /etc/my.cnf, so I tried a couple of things.
> > First I moved my.cnf to /etc/my.cnf. No difference. So I moved it back
> > and edited the mysql.server file to look at /etc/mysql/my.cnf as follows:
> >
> > conf=/etc/mysql/my.cnf
> >
> > Still nothing. The only way I could get it to run on
> > /var/run/mysqld/mysqld.sock was to edit the line in mysql.server that
> > starts safe_mysql, ie:
> > I had to change
> > $bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file &
> > to
> > $bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file
> > --socket=/var/run/mysqld/mysqld.sock &
> >
> > Isn't there a more elegant way to do this? Why is mysql.server ignoring
> > the /etc/mysql/my.cnf file?
> >
> > Thank you for your time.
> > ---------------------------------------------------------------------
> > Joel Gwynn Designers' CADD Company, Inc.
> > A bus station is where a bus stops.
> > A train station is where a train stops.
> > So now you know why they call this a workstation...
> >
>
>
>Hi!
>
>Where in a documentation have you found that MySQL is looking for a
>config file in /etc/mysql directory ??
>
>Our manual is very precise on the location of config files.
>
>
>Regards,
>
>Sinisa
>
> ____ __ _____ _____ ___ == MySQL AB
> /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
> /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
> /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
> /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
> ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
> /*/ \*\ Developers Team
>
>---------------------------------------------------------------------
>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
---------------------------------------------------------------------
Joel Gwynn Designers' CADD Company, Inc.
A bus station is where a bus stops.
A train station is where a train stops.
So now you know why they call this a workstation...
---------------------------------------------------------------------
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