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: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >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: 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-x1 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 -
RE:Mysqld always shuts down after running mysqld-problem solved thx
--- 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: > >Originator: root > >Organization: > > >MySQL support: [none | licence | email support | extended email support ] > >Synopsis: > >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: > > 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-x1 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--
