Just a thought look in your my.ini file and make sure the paths are correct. I too had this problem but I was upgrading to a binary from an rpm and that was where my problem was. the my.ini file expected the paths to be in /var instead of /usr/local. Hope this helps
John Coder On Sat, 2002-09-28 at 10:34, [EMAIL PROTECTED] wrote: > --- Weitergeleitete Nachricht / Forwarded Message --- > Date: Fri, 27 Sep 2002 19:52:25 +0200 (MEST) > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Subject: Mysqld always shuts down after running mysqld > > > >Description: > > hi mysql team, > > i am a mysql newbie (my first time i install it) > > i give up, i can't solve the problem without help. > > all the time i try to start the mysqld, it ends up instantly with a > > shutdown > > of mysqld, i cant run the prog: i edited the mysqld.log and tried to > > figure > > out the problem, here it is: > > > > > '/usr/local/mysql/data/kolumbus.pid' (Errcode: 13) > > >020927 18:39:01 /usr/local/mysql/bin/mysqld: Can't find file: > > './mysql/host.frm' (errno: 13) > > >020927 18:39:01 /usr/local/mysql/bin/mysqld: Error on delete of > > >'/usr/local/mysql/data/kolumbus.pid' (Errcode: 13) > > >020927 18:39:01 mysqld ended > > > > i looked for the files kolumbus.pid and didn't found one (find / -name > > kolumbus.pid) > > at the whole system. the host.frm is in the right pass. > > > > in addition the message after runnung mysqld via config module: > > > > >kolumbus:/usr/local/mysql # ./configure --prefix=/usr/local/mysql/ > > >NOTE: This is a MySQL binary distribution. It's ready to run, you don't > > >need to configure it! > > > > >To help you a bit, I am now going to create the needed MySQL databases > > >and start the MySQL server for you. If you run into any trouble, please > > >consult the MySQL manual, that you can find in the Docs directory. > > > > >Installing all prepared tables > > >020927 18:37:29 ./bin/mysqld: Shutdown Complete > > > > > > >To start mysqld at boot time you have to copy support-files/mysql.server > > >to the right place for your system > > > > >PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! > > >This is done with: > > .>/bin/mysqladmin -u root password 'new-password' > > .>/bin/mysqladmin -u root -h kolumbus password 'new-password' > > >See the manual for more instructions. > > > > >NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run > > >the ./bin/mysql_fix_privilege_tables. Otherwise you will not be > > >able to use the new GRANT command! > > > > >You can start the MySQL daemon with: > > >cd . ; ./bin/safe_mysqld & > > > > >You can test the MySQL daemon with the benchmarks in the 'sql-bench' > > directory: > > >cd sql-bench ; run-all-tests > > > > >Please report any problems with the ./bin/mysqlbug script! > > > > >The latest information about MySQL is available on the web at > > >http://www.mysql.com > > >Support MySQL by buying support/licenses at https://order.mysql.com > > > > >Starting the mysqld server. You can test that it is up and running > > >with the command: > > .>/bin/mysqladmin version > > >kolumbus:/usr/local/mysql # Starting mysqld daemon with databases from > > /usr/local/mysql/data > > >020927 18:37:30 mysqld ended > > > > at his point i tried to start mysqld direct but it stopped instantly with > > this err message: > > > > >kolumbus:/usr/local/mysql # mysqld > > >Fatal error: Please read "Security" section of the manual to find out how > > to run mysqld as root! > > >020927 19:40:13 Aborting > > > > >020927 19:40:13 mysqld: Shutdown Complete > > > > so i tried to find a Security section at mysqld and mysql man pages but > > didnt find something > > > > i dont know how to work on that problem, i read the FAQ and the > > installation > > guide, > > also the documentation, but i didnt found something. i added the > > mysqlbug-output to this mail. > > I don't know if this is relevant for you: I tried to install an older > > version before i tried this one, but i didn't realize to start the older > > one so i > > picked this one. I tried to figure out the problem for 3 days now, I asked > > friends and noone could help me, so i hope u can help me. > > > > with best regards > > > > > > joshua bacher > > >Submitter-Id: <submitter ID> > > >Originator: root > > >Organization: > > <organization of PR author (multiple lines)> > > >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-3.23.48 (Source distribution) > > > > >Environment: > > <machine, os, target, libraries (multiple lines)> > > System: Linux kolumbus 2.4.18-4GB #1 Wed Mar 27 13:57:05 UTC 2002 i686 > > unknown > > 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/i486-suse-linux/2.95.3/specs > > gcc version 2.95.3 20010315 (SuSE) > > Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='-O2 > > -march=i486 > > -mcpu=i686 -D_FILE_OFFSET_BITS=64 > -D_LARGEFILE_SOURCE > > -felide-constructors >-fno-exceptions -fno-rtti' LDFLAGS='' > > LIBC: > > -rwxr-xr-x 1 root root 1394238 Mar 23 2002 /lib/libc.so.6 > > -rw-r--r-- 1 root root 25361424 Mar 23 2002 /usr/lib/libc.a > > -rw-r--r-- 1 root root 178 Mar 23 2002 /usr/lib/libc.so > > Configure command: ./configure --disable-shared > > --with-mysqld-ldflags=-static --with-client-ldflags=-static > > --without-berkeley-db --without-innodb > > --enable-assembler --enable-large-files --infodir=/usr/share/info > > --libdir=/usr/lib --libexecdir=/usr/sbin --localstatedir=/var/lib/mysql > > --mandir=/usr/share/man --prefix=/usr --sysconfdir=/etc > > --with-mysqld-user=mysql --without-debug > > --datadir=/usr/share --includedir=/usr/include > > --with-extra-charsets=complex > > --with-unix-socket-path=/var/lib/mysql/mysql.sock --with-libwrap > > > > -- > > Werden Sie mit uns zum "OnlineStar 2002"! Jetzt GMX wählen - > > und tolle Preise absahnen! http://www.onlinestar.de > > > > > > -- > Werden Sie mit uns zum "OnlineStar 2002"! Jetzt GMX wählen - > und tolle Preise absahnen! http://www.onlinestar.de > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php