Visit Jeremy's Blog.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 10-09-2004, 05:29 PM   #1
LQ Newbie
Registered: Jun 2003
Location: MN, USA
Distribution: Debian
Posts: 15

Rep: Reputation: 0
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: -- 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 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.

Old 10-11-2004, 02:33 AM   #2
Registered: Nov 2001
Location: Near Chicago
Distribution: FC5, Solaris 10, WinXP
Posts: 152

Rep: Reputation: 30
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
Old 10-11-2004, 02:37 AM   #3
Registered: Nov 2001
Location: Near Chicago
Distribution: FC5, Solaris 10, WinXP
Posts: 152

Rep: Reputation: 30
You can also look here
Old 10-11-2004, 09:30 AM   #4
LQ Newbie
Registered: Oct 2004
Location: Bermuda
Distribution: Ubuntu 5.10 (Suse convert)
Posts: 14

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

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


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Bugzilla - MySQL - perl - DBD::mysql install problem Runningonair Linux - Software 8 10-12-2007 01:42 AM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 09:44 AM
DBD::MySQL + MySQL install problems. Elleroth Linux - Software 4 03-24-2006 07:53 AM
MySQL 4 on Fedora can't install php-mysql kennyg Linux - Software 8 09-21-2004 07:54 PM
MySQL mysql-3.23.56-1.9, rpm install problem jacsmith510 Linux - Newbie 3 09-19-2003 03:02 PM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 06:36 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration