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
