> I compiled mysql w/o this option.  Is there any file that I can modify and
> bounce the server to take this?  I modified:
>
> my-path/share/mysql
>
> -rw-r--r--   1 root     other       4938 Jul 23 10:32 my-huge.cnf
> -rw-r--r--   1 root     other       4914 Jul 23 10:33 my-large.cnf
> -rw-r--r--   1 root     other       4897 Jul 23 10:33 my-medium.cnf
> -rw-r--r--   1 root     other       2482 Jul 23 10:34 my-small.cnf
>
> where
>
> socket         = /tmp/mysql.sock
>
> to
>
> socket             = /software/mysql-4.0.14/tmp/mysql.sock
>
> and bounced the server, but it still created /tmp/mysql.sock
>
> There might be another config file the server reads when it started, that
> I didn't modified, but I don't which?
>
>
> Thanks!
> Annie
>
Well.... None of the files you edited are actually in use. :-)

You should have picked on of those cnf files and copied it to your
sysconfigdir specified by ./configure --sysconfdir=/path

Typically, the sysconfig directory is /etc so you'll want to copy on of
those example cnf files like "my-medium.cnf" to /etc/my.cnf

http://dev.mysql.com/doc/mysql/en/Option_files.html


You can change the location of mysql.sock a few different ways.

1) Add "socket=/path/to/mysql.sock" without the quotes under the [mysqld]
and [client] sections of your my.cnf file.
2) Specify it when starting the server like
mysqld_safe --socket=/path/to/mysql.sock
3) Reconfigure mysql adding --with-unix-socket-path=/path/to/mysql.sock

Regards,

Jim Grill



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to