Re: [cobalt-users] Installation of MYSQL

[Jay Summers <jay@xxxxxxxxxxxxxxxxxxxxx>]

> I would like to install MySql onto my Qube 2 and have found the necessary
> rpms etc that I need via this link but it does not show how to go about
> installing this. Please could someone detail what I would need to do in
> order to accomplish this.
> 
> 
> http://cobalt-knowledge.sun.com/cgi-bin/kbase.cfg/php/enduser/std_adp.php?p_
> refno=010608-002159&p_created=992013163

I recommend that you install the latest source tarball for MySQL unless you
want that old outdated version for a specific reason.

This should get you going, but I recommend that you read the INSTALL file
that comes along with the source tarball and the docs at the MySQL website.

SSH into your machine as admin.

[1] Download MySQL:
    wget http://mysql.he.net/Downloads/MySQL-3.23/mysql-3.23.47.tar.gz

[2] Uncompress MySQL and delete the tarball:
    tar xzvf mysql-3.23.47.tar.gz
    rm mysql-3.23.47.tar.gz

[3] Install mysql:

Switch to root
    
    su -
    <enter password>

    groupadd mysql
    useradd -g mysql mysql

    cd mysql-3.23.47/
    ./configure --with-low-memory \
    --with-mysqld-user=mysql \
    --prefix=/home/mysql \
    --disable-assembler \
    --disable-shared \
    --with-mysqld-ldflags="-all-static" \
    --with-client-ldflags="-all-static" \
    mipsel-unknown-linux-gnu

    make
    make install

[4] Run the MySQL install script
    ./scripts/mysql_install_db
    
[5] Copy the MySQL start script:
     cp ./support-files/mysql.server /etc/rc.d/init.d/mysql
     chmod a+x /etc/rc.d/init.d/mysql
     
[6] Modify rc.local to start the MySQL server automatically:
     vi /etc/rc.d/rc.local
    
     put "/etc/rc.d/init.d/mysql start" at the very end.
     
[7] Start MySQL:
     /etc/rc.d/init.d/mysql start
     
[8] Give the root account a password:
     /home/mysql/bin/mysqladmin -u root password 'new-password-goes-here'

Goodluck,
j
-- 
http://www.bizmanuals.com