1.下载Solaris版Mysql
2.创建数据库管理用户
# groupadd mysql
# useradd -g mysql mysql
# passwd mysql
# mkdir /export/home/mysql
# chgrp mysql /export/home/mysql
# chown mysql /export/home/mysql
# usermod -d /export/home/mysql mysql
3.mysql安装
# gunzip mysql-standard-4.1.21-pc-solaris2.10-i386.pkg.gz
# pkgadd -d mysql-standard-4.1.21-pc-solaris2.10-i386.pkg
4.数据库初始化
# cp /usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf
# cd /usr/local
# ln -s /opt/mysql/mysql mysql
# cd mysql
# chown -R mysql .
# chgrp -R mysql .
# scripts/mysql_install_db --user=mysql
# chown -R root .
# chown -R mysql data/
5.启动数据库
# mysqld_safe --user=mysql &
6.连接数据库
# mysql --user=root mysql
7.创建数据库,创建数据库用户,赋予本地/远程登录权限
> create database mysqldb;
> INSERT INTO user (Host,User,Password) VALUES('localhost','dbuser',PASSWORD('password'));
> INSERT INTO db (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv, Create_priv,Drop_priv) VALUES ('localhost','mysqldb','dbuser','Y','Y','Y','Y','Y','Y');
> GRANT ALL PRIVILEGES ON *.* TO dbuser@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;
> GRANT ALL PRIVILEGES ON *.* TO dbuser@"%" IDENTIFIED BY 'password' WITH GRANT OPTION;
> FLUSH PRIVILEGES;
注:
数据库名 mysqldb
用户 dbuser
密码 password
8.数据导入
#mysql --user=root mysqldb < schema.dump -p
#mysql --user=root mysqldb < data.dump -p
9.登录服务
# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/
# ln -s /usr/local/mysql/support-files/mysql.server /etc/rc3.d/S99mysql
# ln -s /usr/local/mysql/support-files/mysql.server /etc/rc0.d/K01mysql