Dear Sir/Madam, I install mysql on my computer but it did not work. after installing the rpms, I use gnorpm to verify the installtion, and it's OK. but I couldn't start my server, after I ran "mysql_install_db" and "safe_mysqld &" commands. I list the relevant information and I use the "mysqlbug" script to collect the relevant information .
mysql's version : mysql-3.23.22-6.i386.rpm mysql-server-3.23.22-6.i386.rpm mysql-devel-3.23.22-6.i386.rpm my computer: AMD Athlon Processor cpu: 1.2GHz mem:256M operating system: red hat linux 7.0 kernel : 2.2.16-22 after intalling the above packages, I run the following command: [root@localhost rpm]# mysql_install_db Creating db table Creating host table Creating user table Creating func table Creating tables_priv table Creating columns_priv table 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: /usr/bin/mysqladmin -u root -p password 'new-password' /usr/bin/mysqladmin -u root -h localhost.localdomain -p password 'new-password' See the manual for more instructions. Please report any problems with the /usr/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 http://www.mysql.com/license.htmy. then I run the following command: [root@localhost rpm]# safe_mysqld & [1] 1284 [root@localhost rpm]# Starting mysqld daemon with databases from /var/lib/mysql 020216 16:16:33 mysqld ended while I find some information from /var/lib/mysql/localhost.localdomain.err, the file localhost.localdomain.err's contents: 020215 17:31:02 mysqld started 020215 17:31:02 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020215 17:31:02 mysqld ended but I find the 'host.frm' file is in the directory: /var/lib/mysql/mysql in my /etc directory, there is only a configure file named: my.conf and the file's length is zero. there is no file named : my.cnf or mf.cnf. I tried to copy one of the config file my-medium.cnf to the /etc directory and renamed to both my.cnf and mf.cnf, it still did not work. mysqlbug's information SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: root To: [EMAIL PROTECTED] Subject: [50 character or so descriptive subject here (for reference)] >Description: <precise description of the problem (multiple lines)> >How-To-Repeat: <code/input/activities to reproduce the problem (multiple lines)> >Fix: <how to correct or work around the problem, if known (multiple lines)> >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.22-beta (Source distribution) >Environment: <machine, os, target, libraries (multiple lines)> System: Linux localhost.localdomain 2.2.16-22 #1 Tue Aug 22 16:49:06 EDT 2000 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/i386-redhat-linux/2.96/specs gcc version 2.96 20000731 (Red Hat Linux 7.0) Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686' CXX='c++' CXXFLAGS='-O2 -march=i386 -mcpu=i686' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 14 Jan 30 01:12 /lib/libc.so.6 -> libc-2.1.92.so -rwxr-xr-x 1 root root 4776568 Aug 31 2000 /lib/libc-2.1.92.so -rw-r--r-- 1 root root 22607104 Aug 31 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Aug 31 2000 /usr/lib/libc.so Configure command: ./configure i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --without-debug --without-readline --enable-shared --with-extra-charsets=complex --without-bench --localstatedir=/var/lib/mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --enable-assembler --with-mysqld-user=mysql Best regards; Leon _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com --------------------------------------------------------------------- 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