MySQL Installation
 

Hi guys

Recently I downloaded and installed Apache 1.3.20 and after posting a message on this forum have set it up to run from boot, thx again jharris.

I now plan to install MySQL 3.23.39 from source file but I have some questions that somebody hopefully can answer, so here goes.....

The instructions state to do the following...

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> scripts/mysql_install_db
shell> chown -R root /usr/local/mysql
shell> chown -R mysql /usr/local/mysql/var
shell> chgrp -R mysql /usr/local/mysql
shell> cp support-files/my-medium.cnf /etc/my.cnf
shell> /usr/local/mysql/bin/safe_mysqld --user=mysql &

however it also states....

If you are using a recent version of gcc, recent enough to understand -fno-exceptions option, it is VERY IMPORTANT that you use it. Otherwise, you may compile a binary that crashes randomly. We also recommend that you use -felide-contructors and -fno-rtti along with -fno-exceptions. When in doubt, do the following:

CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld-ldflags=-all-static

My question is this...

How do I know if I have a recent enough version, do I just run it and see, or will this cause problems? Also where do I place this line in the above instructions?? I guess I replace it with the 5th line, is this correct???

Second question....

The 1st,2nd,9th,10th and 11th lines setup the owners and groups, what do I need to put in here to be able to setup the database as root but allow other users to access the data???

Third question....

Has anybody used the other two types of tables, one of which is the Inno DB tables, and how do you rate them???

Ok I think thats enough questions for now or i,m gonna get a reputation for being a pain :)

Thx in advance for the replies

RecoilUK

I,ve sorted it thx, no need to reply