Hi, everybody, I have trouble, installing mysql on a Linux-machine running SuSE-Linux 6.3. I managed to compile it from source (3.23.32) and I managed to install everything, but I am unable to create the initial databases and to start the mysqld. Here is, what I did, and what happened: I configured mysql with this command: ---------------------------------------- root@quark:/usr/src/mysql-3.23.32 # ./configure \ --with-mysqld-user=mysql \ --prefix=/opt/mysql && make && make install ---------------------------------------- Everything seems to run smooth until I try to install the databases. When running the mysql_install_db-script I get this: ---------------------------------------- root@quark:/usr/src/mysql-3.23.32 # scripts/mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ERROR: 1030 Got error -1 from table handler ERROR: 1030 Got error -1 from table handler ERROR: 1030 Got error -1 from table handler ERROR: 1030 Got error -1 from table handler ERROR: 1030 Got error -1 from table handler ERROR: 1030 Got error -1 from table handler ERROR: 1030 Got error -1 from table handler ERROR: 1030 Got error -1 from table handler ---------------------------------------- Ignoring these messages and changing ownership and group of the /opt/mysql-directory to mysql.mysql, this is, what my /opt/mysql/var/mysql-directory looks like: ---------------------------------------- -rw-rw---- 1 mysql mysql 0 Jan 29 13:36 columns_priv.MYD -rw-rw---- 1 mysql mysql 1024 Jan 29 13:36 columns_priv.MYI -rw-rw---- 1 mysql mysql 8778 Jan 29 13:36 columns_priv.frm -rw-rw---- 1 mysql mysql 0 Jan 29 13:36 db.MYD -rw-rw---- 1 mysql mysql 1024 Jan 29 13:36 db.MYI -rw-rw---- 1 mysql mysql 8982 Jan 29 13:36 db.frm -rw-rw---- 1 mysql mysql 0 Jan 29 13:36 func.MYD -rw-rw---- 1 mysql mysql 1024 Jan 29 13:36 func.MYI -rw-rw---- 1 mysql mysql 8641 Jan 29 13:36 func.frm -rw-rw---- 1 mysql mysql 0 Jan 29 13:36 host.MYD -rw-rw---- 1 mysql mysql 1024 Jan 29 13:36 host.MYI -rw-rw---- 1 mysql mysql 8958 Jan 29 13:36 host.frm -rw-rw---- 1 mysql mysql 0 Jan 29 13:36 tables_priv.MYD -rw-rw---- 1 mysql mysql 1024 Jan 29 13:36 tables_priv.MYI -rw-rw---- 1 mysql mysql 8877 Jan 29 13:36 tables_priv.frm -rw-rw---- 1 mysql mysql 0 Jan 29 13:36 user.MYD -rw-rw---- 1 mysql mysql 1024 Jan 29 13:36 user.MYI -rw-rw---- 1 mysql mysql 9148 Jan 29 13:36 user.frm ---------------------------------------- Of course, when trying to start the mysqld with this command: ---------------------------------------- root@quark:/opt/mysql # bin/safe_mysqld --user=mysql Starting mysqld daemon with databases from /opt/mysql/var 010129 14:33:01 mysqld ended ---------------------------------------- it stops immediately, complaining about being unable to open the user.MYD: ---------------------------------------- root@quark:/opt/mysql # tail var/quark.err 010129 14:39:07 mysqld started 010129 14:39:07 /opt/mysql/libexec/mysqld: Can't open file: 'user.MYD'. (errno: 126) 010129 14:39:07 010129 14:39:07 mysqld ended ---------------------------------------- Did anybody encounter this problem before? Does anybody have a clue what I can do about it? Thanks in advance, Wolfgang By the way: The user 'mysql' exists as a member of the 'mysql'-group. I compiled using gcc2.95.2 ---------------------------------------- root@quark:/usr/src/mysql-3.23.32 # gcc --version 2.95.2 ---------------------------------------- my glibc's version is: ---------------------------------------- root@quark:/usr/src/mysql-3.23.32 # strings /lib/libc* | grep "release version" GNU C Library stable release version 2.1.2, by Roland McGrath et al. ---------------------------------------- Wolfgang Arendt Vodafone TeleCommerce GmbH SW Test & Config. Management Wolfgang Arendt Daniel-Goldbach-Str. 17-19 40880 Ratingen Tel. +49 (0) 21 02 / 97 2492 Fax +49 (0) 21 02 / 97 2453 mailto:[EMAIL PROTECTED] www.vodafone-telecommerce.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