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:    [EMAIL PROTECTED] (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
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




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

Reply via email to