new to mysql, 4.0 install
 

I've never installed MySQL before, but i wanted to try it, and its giving me problems. i'm following the directions here: http://dev.mysql.com/doc/mysql/en/Quick_install.html -- i unzup the tar.gz, then move it all to /usr/local/mysql so i can install it there, instead of where i unzipped it to... although i guess i could have just unzipped it there... whatever. So the ./configure --prefix=/usr/local/mysql command gives throws an error after preparing some tables, the ouput line that says Installing all prepared tables is the last line of normal execution, then it throws an
"Asked for 196608 thread stack, but got 126976"
"./bin/mysqld: Shutdown Complete"

And then it continues with how to start the server, remembering to set a root user password, etc. my hostname.err file contains this:

041009 15:59:57 mysqld started
041009 15:59:57 Warning: Asked for 196608 thread stack, but got 126976
041009 15:59:57 InnoDB: Operating system error number 13 in a file operation.
InnoDB: See http://www.innodb.com/ibman.php for installation help.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
041009 15:59:57 mysqld ended

Hope i gave enough description, i'm thinking its permissions i didnt set, cause of the access rights line in there, but i dont know what to set on what file where etc. Anyone know a solution? Thanks a ton.

Peace.

the directions that are pretty typical should be this

shell> groupadd mysql
shell> useradd -g mysql mysql
shell> gunzip < mysql-VERSION.tar.gz | tar -xvf -
shell> cd mysql-VERSION
shell> ./configure --prefix=/usr/local/mysql
shell> make
shell> make install
shell> cp support-files/my-medium.cnf /etc/my.cnf
shell> cd /usr/local/mysql
shell> bin/mysql_install_db --user=mysql
shell> chown -R root .
shell> chown -R mysql var
shell> chgrp -R mysql .
shell> bin/mysqld_safe --user=mysql &

all of this is important but make sure you do not skip

shell> bin/mysql_install_db --user=mysql

without this done there will be no databases for mysql to work with and you will get some of the errors that you got.

also make sure that you have a ./ibdata1 you will need to find out were this is suppose to be located and make sure it is there with mysql as the owner and group with -rwx permissions

Hope this helps

You can also look here

http://m3.femorg.com/0804-17/3.mpg

not sure if you are interested - your underlying reasons for wanting to try mysql, but I've had some better success with Firebird

http://firebird.sourceforge.net/

I have both mysql, informix, and firebird running and now leaning towards going with firebird.