Hello.
> seems to put the socket file in the wrong place- (should be in /tmp)
Your running copy of mysqld has --socket==/var/lib/mysql/mysql.sock
argument. Perhaps mysqld_safe puts it by default or reads from
[mysqld_safe] or [mysqld] sections of configuration file. Specify
the value of socket variable explicitly. See:
http://dev.mysql.com/doc/refman/5.0/en/program-options.html
Dan Gahlinger wrote:
>> Description:
>
> mysql will not create /tmp/mysql.sock
> at first it would not create /var/run/mysql/mysqld.pid - I manually
> created the /var/run/mysql and set permissions, and it works. now i have
> problems with the socket file - it wont create it
>
>> How-To-Repeat:
>
> bin/mysqld_safe --user=mysql &
> ./bin/mysqladmin -u root password 'new-password'
>
> seems to put the socket file in the wrong place- (should be in /tmp)
>
> mysql 29520 0.0 0.6 116700 14372 pts/0 S 11:56 0:00
> /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql
> --datadir=/var/lib/mysql --user=mysql
> --pid-file=/var/run/mysqld/mysqld.pid --skip-locking
> --socket=/var/lib/mysql/mysql.sock
>
>> Submitter-Id: <submitter ID>
>> Originator: dgahling@stripped (root)
>> Organization:
>> MySQL support: [none | licence | email support | extended email support ]
>> Synopsis: <synopsis of the problem (one line)>
>> Severity: <[ non-critical | serious | critical ] (one line)>
>> Priority: <[ low | medium | high ] (one line)>
>> Category: mysql
>> Class: <[ sw-bug | doc-bug | change-request | support ] (one
>> line)>
>> Release: mysql-5.0.16-max (MySQL Community Edition -
>> Experimental (GPL))
>
>
>> C compiler: gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-52)
>> C++ compiler: gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-52)
>> Environment:
>
> <machine, os, target, libraries (multiple lines)>
> System: Linux tidctnsddcdb01 2.4.21-37.ELsmp #1 SMP Wed Sep 7 13:28:55
> EDT 2005 i686 i686 i386 GNU/Linux
> Architecture: i686
>
> Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
> /usr/bin/cc
> GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2.3/specs
> Configured with: ../configure --prefix=/usr --mandir=/usr/share/man
> --infodir=/usr/share/info --enable-shared --enable-threads=posix
> --disable-checking --with-system-zlib --enable-__cxa_atexit
> --host=i386-redhat-linux
> Thread model: posix
> gcc version 3.2.3 20030502 (Red Hat Linux 3.2.3-53)
> Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS=''
> LDFLAGS='' ASFLAGS=''
> LIBC:
> lrwxrwxrwx 1 root root 13 Nov 4 15:12 /lib/libc.so.6
> -> libc-2.3.2.so
> -rwxr-xr-x 1 root root 1569156 Sep 16 19:45 /lib/libc-2.3.2.so
> -rw-r--r-- 1 root root 2469146 Sep 16 18:02 /usr/lib/libc.a
> -rw-r--r-- 1 root root 204 Sep 16 17:43 /usr/lib/libc.so
> Configure command: ./configure '--prefix=/usr/local/mysql'
> '--localstatedir=/usr/local/mysql/data'
> '--libexecdir=/usr/local/mysql/bin' '--with-comment=MySQL Community
> Edition - Experimental (GPL)' '--with-extra-charsets=complex'
> '--with-server-suffix=-max' '--enable-thread-safe-client'
> '--enable-local-infile' '--enable-assembler' '--disable-shared'
> '--with-zlib-dir=bundled' '--with-big-tables' '--with-readline'
> '--with-archive-storage-engine' '--with-blackhole-storage-engine'
> '--with-ndbcluster' '--with-csv-storage-engine'
> '--with-example-storage-engine' '--with-federated-storage-engine'
> '--with-innodb' 'CC=gcc' 'CXX=gcc'
>
> _________________________________________________________________
> Take advantage of powerful junk e-mail filters built on patented
> Microsoft� SmartScreen Technology.
>
> http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines
> Start enjoying all the benefits of MSN� Premium right now and get the
> first two months FREE*.
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
