Hello.


Specify the correct value for datadir when you start mysqld_safe. 

For these purposes I normally use configuration file, and launch 

mysqld_safe with --defaults-file=/path/to/my/file command line option.

See:

  http://dev.mysql.com/doc/mysql/en/program-options.html





James Cooper <[EMAIL PROTECTED]> wrote:

> mysqld fails with permision denied (/var); runing as a user

> 

>>Description:

>        mysql configures for runing in user space; makes; and installs; tests

>        wor, but mysqld wont run

> 

>        

>>How-To-Repeat:

> I built mysql-4.1.14-nightly-20050808 from source, using

>   ./configure 
> '--prefix=/usr/staff/tango/jc/src/fedora/mysql-4.1.14-nightly-20050808/local' 
> '--with-mysqld-user=jc'

> 

> then make

> then make install

> Then I initialize with  

> bin/mysql_install_db --datadir=local --user=jc

> 

> this responds with: 

> You can start the MySQL daemon with:

> cd /usr/staff/tango/jc/src/fedora/mysql-4.1.14-nightly-20050808/local ; 
> /usr/staff/tango/jc/src/fedora/mysql-4.1.14-nightly-20050808/local/bin/mysqld_safe
>  &

> 

> This command fails with the following erros:

> 

> mkdir: cannot create directory `/var/lib/mysql': Permission denied

> chown: cannot access `/var/lib/mysql': No such file or directory

> Starting mysqld daemon with databases from /var/lib/mysql

> /usr/staff/tango/jc/src/fedora/mysql-4.1.14-nightly-20050808/local/bin/mysqld_safe:
>  line 329: /var/log/mysqld.log: No such file or directory

> /usr/staff/tango/jc/src/fedora/mysql-4.1.14-nightly-20050808/local/bin/mysqld_safe:
>  line 337: /var/log/mysqld.log: No such file or directory

> STOPPING server from pid file /var/run/mysqld/mysqld.pid

> tee: /var/log/mysqld.log: Permission denied

> 050812 12:13:16  mysqld ended

> tee: /var/log/mysqld.log: Permission denied

> 

>        

>>Fix:

>        

> 

>>Submitter-Id:  <submitter ID>

>>Originator:    

>>Organization:

>  James Cooper                ,-_|\  E-mail: [EMAIL PROTECTED]

>  Curtin University          /     \ Phone:  +61 8 9266 2948

>  GPO Box U1987, PERTH       $_,-._/ Fax:    +61 8 9266 2819

>  WA 6845, Australia              v  CRICOS provider code: 00301J

>>

>>MySQL support: none

>>Synopsis:      mysql installs; tests work, but mysqld won't run.

>>Severity:      critical

>>Priority:      low

>>Category:      mysql

>>Class:          sw-bug 

>>Release:       mysql-4.1.14-nightly-20050808 (Source distribution)

> 

>>C compiler:    gcc (GCC) 3.4.4 20050721 (Red Hat 3.4.4-2)

>>C++ compiler:  g++ (GCC) 3.4.4 20050721 (Red Hat 3.4.4-2)

>>Environment:

>        

> System: Linux ladybird 2.6.10-csck #5 SMP Fri May 6 16:49:29 WST 2005 i686 
> i686 i386 GNU/Linux

> Architecture: i686

> 

> Some paths:  /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc 
> /usr/bin/cc

> GCC: Reading specs from /usr/lib/gcc/i386-redhat-linux/3.4.4/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 
> --disable-libunwind-exceptions --enable-java-awt=gtk --host=i386-redhat-linux

> Thread model: posix

> gcc version 3.4.4 20050721 (Red Hat 3.4.4-2)

> Compilation info: CC='gcc'  CFLAGS=''  CXX='g++'  CXXFLAGS=''  LDFLAGS=''  
> ASFLAGS=''

> LIBC: 

> lrwxrwxrwx  1 root root 13 May  6 17:04 /lib/libc.so.6 -> libc-2.3.5.so

> -rwxr-xr-x  1 root root 1505808 Apr  7 18:58 /lib/libc-2.3.5.so

> -rw-r--r--  1 root root 2409956 Apr  7 18:03 /usr/lib/libc.a

> -rw-r--r--  1 root root 204 Apr  7 17:29 /usr/lib/libc.so

> Configure command: ./configure 
> '--prefix=/usr/staff/tango/jc/src/fedora/mysql-4.1.14-nightly-20050808/local' 
> '--with-mysqld-user=jc'

> 

> 

> 



-- 
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