반응형
솔라리스에서 번들로 설치되어있는 mysql의 설정.
/etc/sfw/mysql/README.solaris.mysql 에 설정하는 방법이 있다.To use mysql a number of post-install procedures need to be made by root.
The following steps are derived from the mysql manual (manual.ps, manual.txt or
manual_toc.html) found in the /usr/sfw/src/mysql/Docs directory.
Initialise the database tables.
# /usr/sfw/bin/mysql_install_db
Create mysql user and group and change data directory group.
# groupadd mysql
# useradd -g mysql mysql
# chgrp -R mysql /var/mysql
# chmod -R 770
# installf SUNWmysqlr /var/mysql d 770 root mysql
MySQL reads configuration files from different places in the following order.
Filename Purpose
--------- ---------
/etc/my.cnf Global options
DATADIR/my.cnf Server-specific options
To use mysql a number of post-install procedures need to be made by root.
The following steps are derived from the mysql manual (manual.ps, manual.txt or
manual_toc.html) found in the /usr/sfw/src/mysql/Docs directory.
Initialise the database tables.
# /usr/sfw/bin/mysql_install_db
Create mysql user and group and change data directory group.
# groupadd mysql
# useradd -g mysql mysql
# chgrp -R mysql /var/mysql
# chmod -R 770
# installf SUNWmysqlr /var/mysql d 770 root mysql
MySQL reads configuration files from different places in the following order.
Filename Purpose
--------- ---------
/etc/my.cnf Global options
DATADIR/my.cnf Server-specific options
defaults-extra-file The file specified with
--defaults-extra-file=path
~/.my.cnf User-specific options
Optionally copy a mysql daemon configuration file to configuration directory.
Note there are other configuration profiles available.
For default solaris installation DATADIR is /var/mysql.
# cp /usr/sfw/share/mysql/my-medium.cnf /var/mysql/my.cnf
Start mysql daemon by hand
# /usr/sfw/sbin/mysqld_safe --user=mysql &
Optionally perform the following steps for automatic start and stop of
mysql daemon at boot and shutdown.
Link boot time start up script from rc3.d and rc[012S].d
# ln /etc/sfw/mysql/mysql.server /etc/rc3.d/S99mysql
# ln /etc/sfw/mysql/mysql.server /etc/rc0.d/K00mysql
# ln /etc/sfw/mysql/mysql.server /etc/rc1.d/K00mysql
# ln /etc/sfw/mysql/mysql.server /etc/rc2.d/K00mysql
# ln /etc/sfw/mysql/mysql.server /etc/rcS.d/K00mysql
반응형
'Solaris' 카테고리의 다른 글
| Solaris 10 에서 mysql SMF 설정하기 (0) | 2008.09.23 |
|---|---|
| Solaris 10에서 아파치2 SMF 세팅하기 (2) | 2008.06.10 |
| Solaris update 시 수동 업데이트가 필요한 경우 (0) | 2008.05.05 |
| Solaris Sun Studio patch (0) | 2006.12.02 |
| vsftpd 에서 fxp 가능하게 설정하기 (2) | 2006.11.28 |
