# /usr/sfw/bin/mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 060118 21:24:03 /usr/sfw/sbin/mysqld: Shutdown Complete <snip...>2.建立 mysql user 和 group ，并且更改數據目錄的群組。
# groupadd mysql # useradd -g mysql mysql # chgrp -R mysql /var/mysql # chmod -R 770 /var/mysql # installf SUNWmysqlr /var/mysql d 770 root mysql3.預設 MySQL 設定文件位置為 /var/mysql/my.cnf 4.復制 MySQL 設定文件到預設位置
# cp /usr/sfw/share/mysql/my-medium.cnf /var/mysql/my.cnf5.手動啟動 mysql
# cd /usr/sfw/bin # ./mysqladmin -u root password 'new-password' # ./mysqladmin -u root -h `hostname` password 'new-password'7.測試 MySQL Server
# ./mysqlshow -p Enter password: new-password
+-----------+ | Databases | +-----------+ | mysql | | test | +-----------+
# ./mysql -u root -p Enter password: new-password
Welcome to the MySQL monitor. Commands end with ; or /g. Your MySQL connection id is 3 to server version: 4.0.20-standard Type 'help;' or '/h' for help. Type '/c' to clear the buffer.
mysql> show databases; +-----------+ | Databases | +-----------+ | mysql | | test | +-----------+ 2 rows in set (0.00 sec)
mysql> quit; Bye8.設定 Solaris Server 在啟動和關機時，自動運行和停止MySQL Server。
root:/# mkdir /usr/local/src root:/# cd /usr/local/src root:/usr/local/src# wget http://www.blastwave.org/pkg_get.pkg root:/usr/local/src# cp pkg_get.pkg .. root:/usr/local/src# pkgadd -d pkg_get.pkg all
You may use and copy this software without charge, as you see fit. The software is copyright (C) Philip Brown, Nov 2002
Dont forget to update /opt/csw/etc/pkg-get.conf with your nearest archive site. The selected base directory </opt/csw> must exist before installation is attempted.
Do you want this directory created now [y,n,?,q] y Using </opt/csw> as the package base directory. ## Processing package information. ## Processing system information. 2 package pathnames are already properly installed. ## Verifying disk space requirements. ## Checking for conflicts with packages already installed. ## Checking for setuid/setgid programs.
This package contains scripts which will be executed with super-user permission during the process of installing this package.
Do you want to continue with the installation of <CSWpkgget> [y,n,?] y
Installing pkg_get - CSW version of automated package download tool as <CSWpkgget>
## Installing part 1 of 1. /opt/csw/bin/pkg-get /opt/csw/etc/pkg-get.conf.csw /opt/csw/share/man/man1m/pkg-get.1m /var/pkg-get/admin-fullauto [ verifying class <none> ] ## Executing postinstall script.
Installing /opt/csw/etc/pkg-get.conf.csw to pkg-get.conf Installation of <CSWpkgget> was successful.
root:/usr/local/src# cd / root:/#4.檢查是否安裝好 pkg-get 和 wget的位置
root:/# which pkg-get /opt/csw/bin/pkg-get
root:/# which wget /usr/sfw/bin/wget5.安裝完整的 wget 軟件
root:/# which wget /opt/csw/bin/wget8.檢查 GNU Autoconf 的版本是否為 2.59 或以上
root:/# which autoconf && autoconf --version | head -2 /opt/csw/bin/autoconf autoconf (GNU Autoconf) 2.59 Written by David J. MacKenzie and Akim Demaille.
如果不是為 2.59 或以上版本或根本沒有這個程序，執行以下指令：
root:/# pkg-get -i autoconf9.檢查 GNU automake 的版本是否為 1.8.3 或以上
root:/# which automake && automake --version | head -2 /opt/csw/bin/automake automake (GNU automake) 1.8.3 Written by Tom Tromey <[email protected]>.
如果不是為1.8.3 或以上版本或根本沒有這個程序，執行以下指令：
root:/# pkg-get -i automake10.檢查 GNU sed version 的版本是否為 4.1.4 或以上
root:/# which gsed && gsed --version | head -2 /opt/csw/bin/gsed GNU sed version 4.1.4 Copyright (C) 2003 Free Software Foundation, Inc.
如果不是為 4.1.4 或以上版本或根本沒有這個程序，執行以下指令：
root:/# pkg-get -i gsed11.檢查 gcc 的版本是否為 3.4.3 或以上
root:/# which gcc && gcc --version | head -2 /usr/sfw/bin/gcc gcc (GCC) 3.4.3 (csl-sol210-3_4-branch+sol_rpath) Copyright (C) 2004 Free Software Foundation, Inc.
如果不是為 3.4.3 或以上版本或根本沒有這個程序，執行以下指令：
root:/# pkg-get -i gcc 12.檢查 GNU Make 的版本是否為 3.80 或以上
root:/# which gmake && gmake --version | head -2 /usr/sfw/bin/gmake GNU Make 3.80 Copyright (C) 2002 Free Software Foundation, Inc.
如果不是為 3.80 或以上版本或根本沒有這個程序，執行以下指令：
root:/# pkg-get -i gmake 13.檢查 flex version 的版本是否為 2.5.4 或以上
root:/# which flex && flex --version | head -2 /usr/sfw/bin/flex flex version 2.5.4
如果不是為 2.5.4 或以上版本或根本沒有這個程序，執行以下指令：
root:/# pkg-get -i flex 14.檢查 GNU Bison 的版本是否為 1.875 或以上
root:/# which bison && bison --version | head -2 /usr/sfw/bin/bison bison (GNU Bison) 1.875 Written by Robert Corbett and Richard Stallman.
如果不是為 1.875 或以上版本或根本沒有這個程序，執行以下指令：
root:/# pkg-get -i bison 15.檢查 GNU M4 的版本是否為 1.4.3 或以上
root:/# which gm4 && gm4 --version | head -2 /opt/csw/bin/gm4 GNU M4 1.4.3 Written by Rene' Seindal.
如果不是為 1.4.3 或以上版本或根本沒有這個程序，執行以下指令：
root:/# pkg-get -i gm4 16.檢查 Perl 的版本是否為 5.8 或以上
root:/# which perl && perl -v | head -2 /usr/bin/perl
This is perl, v5.8.4 built for i86pc-solaris-64int
如果不是為 5.8 或以上版本或根本沒有這個程序，執行以下指令：
root:/# pkg-get -i perl 17.檢查 GNU zip 的版本是否為 1.3.3 或以上
root:/# which gunzip && gunzip -V | head -2 /usr/bin/gunzip gunzip 1.3.3-patch.1 (2002-03-08)
如果不是為 1.3.3 或以上版本或根本沒有這個程序，執行以下指令：
root:/# pkg-get -i gunzip 18.檢查 GNU tar 的版本是否為 1.14 或以上
root:/# which gtar && gtar --version | head -2 /usr/sfw/bin/gtar tar (GNU tar) 1.14 Copyright (C) 2004 Free Software Foundation, Inc.
