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]