MySql Install

* 移除內建 mysql 4.x
# pkginfo | grep -i mysql
# pkgrm SUNWmysqlr
# pkgrm SUNWmysqlt
# pkgrm SUNWmysqlu

* 以原始碼編譯安裝
# cd /Downloads
# wget ftp://ftp.sunfreeware.com/pub/freew...l-5.0.67.tar.gz
# gunzip -cd mysql-5.0.67.tar.gz | gtar xvpf -
# cd mysql-5.0.67
# CC=gcc CFLAGS="-O3 -fomit-frame-pointer -DHAVE_CURSES_H" \
> CXX=gcc \
> CXXFLAGS="-O3 -fomit-frame-pointer -felide-constructors \
> -fno-exceptions -fno-rtti -DHAVE_CURSES_H" \
> ./configure --prefix=/usr/local/mysql --sysconfdir=/etc --localstatedir=/usr/local/mysql/data --enable-assembler --with-mysqld-ldflags=-all-static --with-charset=utf8 --with-extra-charsets=all
# gmake
# gmake install

* 以套裝程式安裝
# cd /Downloads
# wget ftp://ftp.sunfreeware.com/pub/freew...10-x86-local.gz
# gunzip mysql-5.0.67-sol10-x86-local.gz
# pkgadd -d mysql-5.0.67-sol10-x86-local
複製 hostname 文件
# ln -s /usr/bin/hostname /usr/local/bin/hostname

* 配置檔設定
# cp /usr/local/mysql/share/mysql/my-medium.cnf /etc/my.cnf
修改/etc/my.cnf內容
[mysqld]下面加入
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data

* 設置權限
# mkdir /usr/local/mysql/data
# groupadd mysql
# useradd -g mysql mysql
# chgrp -R mysql /usr/local/mysql
# chown -R root /usr/local/mysql
# chown -R mysql /usr/local/mysql/data
# chmod -R 770 /usr/local/mysql

* 設定 Solaris Server 在啟動和關機時 自動運行和停止MySQL Server
# ln /usr/local/mysql/share/mysql/mysql.server /etc/rc3.d/S99mysql
# ln /usr/local/mysql/share/mysql/mysql.server /etc/rc0.d/K00mysql
# ln /usr/local/mysql/share/mysql/mysql.server /etc/rc1.d/K00mysql
# ln /usr/local/mysql/share/mysql/mysql.server /etc/rc2.d/K00mysql
# ln /usr/local/mysql/share/mysql/mysql.server /etc/rcS.d/K00mysql

* 初始化資料庫
# /usr/local/mysql/bin/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql

* 啟動 MySQL
# /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data --user=mysql &
如無法啟動Mysql 重新啟動系統 再直接進行下一步設定密碼 因為開機時會自動啟動

* 設定 root/mysql 密碼
初次安裝必須設定
# /usr/local/mysql/bin/mysqladmin -u root password 'root使用者密碼'
# /usr/local/mysql/bin/mysqladmin -u root -h `hostname` password 'MySql登入密碼'

* 測試 MySQL Server
# /usr/local/mysql/bin/mysqlshow -p
Enter password: 輸入MySQL密碼

* 連接 MySQL
# /usr/local/mysql/bin/mysql -u root -p
Enter password: 輸入MySQL密碼

顯示資料庫
mysql> show databases;
退出
mysql> quit;

[起動]
# /usr/local/mysql/bin/mysqld_safe --user=mysql &
[停止]
# /usr/local/mysql/bin/mysqld_safe shutdown

* 原始碼編譯安裝參數