如何初始化Solaris自带的mysql数据库
有人不知道Solaris自带的有mysql数据库，即使知道了也可能不知如何初始化，如何部署为系统服务在开机时启动。其实只要参考一个文件并按照上面说的一步一步作就没有任何问题，这个文件就是/etc/sfw/mysql/README.solaris.mysql
下面我把必要的步骤再列举一下：
1. 确认系统按照了mysql
# pkginfo | grep mysql
bash-3.2# pkginfo | grep mysql
system SUNWmysql5r MySQL 5.0.45 - MySQL Database Management System (root component)
system SUNWmysql5test MySQL 5.0.45 - MySQL Database Management System (test component)
system SUNWmysql5u MySQL 5.0.45 - MySQL Database Management System (usr component)
system SUNWmysqlr mysql - MySQL Database Management System (root component)
system SUNWmysqlt mysql - MySQL Database Management System (test component)
system SUNWmysqlu mysql - MySQL Database Management System (usr component)
system SUNWphp524-mysql PHP5 module for MySQL
system SUNWphp524-mysql-root PHP5 module for MySQL(root)
2. 初始化数据库系统表
# /usr/sfw/bin/mysql_install_db
3. 添加mysql用户，mysql组并更改/var/mysql权限
# groupadd mysql
# useradd -g mysql mysql
# chgrp -R mysql /var/mysql
# chmod -R 770 /var/mysql
# installf SUNWmysqlr /var/mysql d 770 root mysql
3. 拷贝配置文件
# cp /usr/sfw/share/mysql/my-medium.cnf /var/mysql/my.cnf
4. 启动mysql数据库daemon进程
# /usr/sfw/sbin/mysqld_safe --user=mysql &
5. 部署为系统服务
# 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
如果出现任何问题，请参考/var/mysql/`hostname`.err的错误输出。可以参考下面的命令来检查系统是否启动正常：
bash-3.2# netstat -f inet -a -P tcp | grep 3306
*.3306 *.* 0 0 49152 0 LISTEN
bash-3.2# pgrep mysql
1255
1274
bash-3.2# pargs 1255
1255: /bin/sh /usr/sfw/sbin/mysqld_safe --user=mysql
argv: /bin/sh
argv: /usr/sfw/sbin/mysqld_safe
argv: --user=mysql
bash-3.2# pargs 1274
1274: /usr/sfw/sbin/mysqld --basedir=/usr/sfw --datadir=/var/mysql --user=mysql --pid
argv: /usr/sfw/sbin/mysqld
argv: --basedir=/usr/sfw
argv: --datadir=/var/mysql
argv: --user=mysql
argv: --pid-file=/var/mysql/snv.pid
argv: --port=3306
argv: --socket=/tmp/mysql.sock
本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u/23177/showart_443454.html
页:
[1]