%
cat /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 /var/mysql
#
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
#
reboot
%
mysql <- 정상 동작 확인
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.0.15-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>