Re: INSTALLATION QUESTION on Cobalt Raq3

2001-01-23 Thread Derek Sivers

Don't use RPM.
The RPMs for the Cobalt RaQ3 suck.

I have 8 different Cobalt RaQ3's and here's the way I've used to install:
I've installed it this way successfully each time.
Sounds like a bit of a pain, but puts you in much better control of MySQL.


 INSTALLATION INSTRUCTIONS

#1 - download the newest MySQL *source* tarball from mysql.com or its mirrors.

Do all the following stuff as "root" user:


##  UNTAR IT
tar -xvfz mysql-#.#.tar.gz


## - FIRST: TO MAKE A USER NAME 'mysql' GROUP NAME 'mysql' TO SAFELY RUN 
MYSQL UNDER
/usr/sbin/groupadd mysql
/usr/sbin/useradd mysql -g mysql


./configure  --prefix=/usr/local/mysql --with-mysqld-user=mysql --with-lz
make
make install


## - SET THE DATA DIRECTORY TO BE /VAR/DB - MAKE A SYMLINK FOR IT HERE IN 
THE MYSQL FOLDER
cd mysql
ln -s /var/db var


## - INSTALL THE BASIC DATABASE NEEDED TO RUN
bin/mysql_install_db
## - if there's a problem, do the next step then come back and do this step 
again.


## - GO SET PERMISSIONS FOR THE DATA DIRECTORY
cd /var
chown mysql:mysql -R db
chmod 700 -R db


## - COPY THE STARTUP/INIT/CONFIG FILES TO THE RIGHT PLACE
cd share/mysql
cp mysql.server /etc/rc.d/init.d/
cp my-small.cnf /var/db/my.cnf

## - PUT STARTUP FILES IN EVERY STARTUP FOLDER - so if they reboot the 
server, MySQL starts!
cd /etc/rc.d/init.d/
chmod 755 mysql.server
cd ../rc3.d
ln -s ../init.d/mysql.server S88mysql
cd ../rc4.d
ln -s ../init.d/mysql.server S88mysql
cd ../rc6.d
ln -s ../init.d/mysql.server K18mysql
cd ../rc0.d
ln -s ../init.d/mysql.server K18mysql


## - SYMLINK THE COMMANDS INTO THE PATH SO WE CAN JUST TYPE "mysql" FROM 
ANYWHERE
cd /usr/bin
ln -s /usr/local/mysql/bin/* ./
cd /usr/sbin
ln -s /usr/local/mysql/bin/* ./


## - START IT!
safe_mysqld 
mysqladmin -u root -p password 'somesecretpassword'
mysql -u root -p
use mysql;
delete from user where user='';
exit;

from now on, connect to mysql with 'mysql -u root -p' then type the magic 
password afterwards.

Voila!


-
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 mysql-unsubscribe-##L=##[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: INSTALLATION QUESTION on Cobalt Raq3

2001-01-22 Thread Vivek Khera

 "l" == lkeeton  [EMAIL PROTECTED] writes:

l First does anybody know the website address for that searchable
l site that allows you to search on mysql archive emails. I would
l appreciate if I could get that. I also am looking for opinions on

Does anyone read the footers on the messages they get from the mailing
list or are they just wasting electrons on my box?

-
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