Solaris 10 x86 平台 MySQL 5.0 源碼安裝與配置手冊

安裝步驟

# 解壓
gunzip mysql-5.0.90-solaris10-x86_64.tar.gz
cd /usr/local
tar -xvf /userdata/software/mysql-5.0.90-solaris10-x86_64.tar
ls -ld mysql*
ln -s mysql-5.0.90-solaris10-x86_64 mysql
cd mysql-5.0.90-solaris10-x86_64
./configure

啟動服務

cp /usr/sfw/share/mysql/my-medium.cnf /etc/my.cnf
vi /etc/my.cnf
# 關鍵配置
[mysqld]
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock

[mysql.server]
user=mysql
basedir=/usr/local/mysql

[client]
socket=/tmp/mysql.sock

# 後台啟動
/usr/local/mysql/bin/mysqld_safe &

設置 root 密碼

./mysqladmin -u root password 'imc168'

創建業務庫並恢復數據

./mysql -u root -p
CREATE DATABASE jtrac;
USE jtrac;
SOURCE /userdata/backup20100607.sql;
SHOW TABLES;
EXIT;

修改 root 密碼（SQL 方式）

./mysql -u root -p
USE mysql;
UPDATE user SET Password=PASSWORD('imc@3*it') WHERE User='root';
FLUSH PRIVILEGES;
EXIT;

開啟遠程訪問授權

GRANT ALL PRIVILEGES ON *.* TO 'jtrac'@'109.14.6.230' IDENTIFIED BY 'jtrac' WITH GRANT OPTION;
-- 允許 jtrac 用戶從 109.14.6.230 連接，密碼 jtrac

關閉服務

mysqladmin -u root --password='imc@3*it' shutdown

字符集配置與驗證

在 [client] 和 [mysqld] 添加：

default_character_set=utf8

驗證：

SHOW VARIABLES LIKE 'character%';
-- 期望 database/server/system 為 utf8，client/connection/results 視應用需求