Solaris 10 已內置安裝了 MySQL。安裝者要用 Root 身份登入。以下的安裝可以在 /usr/sfw/src/mysql/Docs 目录中找到。
1. 1. 用 root 身份 login 到 Console mode 中
# /usr/sfw/bin/mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
060118 21:24:03 /usr/sfw/sbin/mysqld: Shutdown Complete
<snip...>
2. 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 mysql
3. 3. 预设 MySQL 设定档案位置 /var/mysql/my.cnf
4. 4. 复制 MySQL 设定档案
# cp /usr/sfw/share/mysql/my-medium.cnf /var/mysql/my.cnf
5. 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 520
7. 7. 测试 MySQL Server
# ./mysqlshow -p
Enter password: 520
+-----------+
| Databases |
+-----------+
| mysql |
| test |
+-----------+
# ./mysql -u root -p
Enter password: 520
Welcome to the MySQL monitor. Commands end with ; or /g.
Your MySQL connection id is 3 to server version: 4.0.20-standard
Type '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;
Bye
8. 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/K00mysql
9. 9. 然后,试试重启 Solaris ,看一看 MySQL 是否自动启动。预设的 MySQL 档案位置为 /var/mysql/my.cnf 。
1. 1. 用 root 身份 login 到 Console mode 中
# /usr/sfw/bin/mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
060118 21:24:03 /usr/sfw/sbin/mysqld: Shutdown Complete
<snip...>
2. 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 mysql
3. 3. 预设 MySQL 设定档案位置 /var/mysql/my.cnf
4. 4. 复制 MySQL 设定档案
# cp /usr/sfw/share/mysql/my-medium.cnf /var/mysql/my.cnf
5. 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 520
7. 7. 测试 MySQL Server
# ./mysqlshow -p
Enter password: 520
+-----------+
| Databases |
+-----------+
| mysql |
| test |
+-----------+
# ./mysql -u root -p
Enter password: 520
Welcome to the MySQL monitor. Commands end with ; or /g.
Your MySQL connection id is 3 to server version: 4.0.20-standard
Type '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;
Bye
8. 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/K00mysql
9. 9. 然后,试试重启 Solaris ,看一看 MySQL 是否自动启动。预设的 MySQL 档案位置为 /var/mysql/my.cnf 。