solaris mysql_Solaris mysql 数据库

Solaris 10 已內置安裝了 MySQL。安裝者要用 Root 身份登入。以下的安裝可以在 /usr/sfw/src/mysql/Docs 目录中找到。1. 1. 用 root 身份 login 到 Console mode 中# /usr/sfw/bin/mysql_install_dbPreparing db tablePreparing host tablePreparing user tablePreparing func tablePreparing tables_priv tablePreparing columns_priv tableInstalling all prepared tables060118 21:24:03 /usr/sfw/sbin/mysqld: Shutdown Complete2. 2. 建立 mysql user 和 group 。# groupadd mysql# useradd -g mysql mysql# chgrp -R mysql /var/mysql# chmod -R 770 /var/mysql# installf SUNWmysqlr /var/mysql d 770 root mysql3. 3. 预设 MySQL 设定档案位置 /var/mysql/my.cnf 4. 4. 复制 MySQL 设定档案# cp /usr/sfw/share/mysql/my-medium.cnf /var/mysql/my.cnf5. 5. 启动 mysql# /usr/sfw/sbin/mysqld_safe --user=mysql &6. 6. 设定 MySQL 的 root user密码 ( 下文中的 new-password 为你想要密码，如520 ) # cd /usr/sfw/bin# ./mysqladmin -u root password 520# ./mysqladmin -u root -h `hostname` password 5207. 7. 测试 MySQL Server# ./mysqlshow -pEnter password: 520+-----------+| Databases |+-----------+| mysql     || test      |+-----------+# ./mysql -u root -pEnter password: 520Welcome to the MySQL monitor. Commands end with ; or /g.Your MySQL connection id is 3 to server version: 4.0.20-standardType 'help;' or '/h' for help. Type '/c' to clear the buffer.mysql> show databases;+-----------+| Databases |+-----------+| mysql     || test      |+-----------+2 rows in set (0.00 sec)mysql> quit;Bye8. 8.设定 Solaris Server 在启动和关机时自动启动和停止MySQL Server。# 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/K00mysql9. 9. 然后，试试重启 Solaris ，看一看 MySQL 是否自动启动。预设的 MySQL 档案位置为 /var/mysql/my.cnf 。