3.啟動 MySQL Server，並設定開機自動啟動
# service mysqld start
# chkconfig mysqld on
4.啟動 httpd Server，並設定開機自動啟動
# service httpd start
# chkconfig httpd on
5.登入MySQL Server，設定 root 密碼
# mysql mysql
mysql> use mysql
Database changed
mysql> update user set password=password(“新密碼“) where user=”root”;
Query OK, 3 rows affected (0.00 sec)
Rows matched: 3 Changed: 3 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
6.安裝 PureFTPd
# yum install pure-ftpd
.
.
Dependency Installed: postgresql-libs.i386 0:8.3.3-2.fc9
Complete!
7.新增一組ftpuser跟ftpgroup給FTP登入時的系統身份使用。
# groupadd -g 2001 ftpgroup
# useradd -u 2001 -s /bin/false -d /bin/null -c “pureftpd user” -g ftpgroup ftpuser
8.在 MySQL 中建立 pureftpd database，這個資料庫會存放所有使用者的帳號、密碼及其他控管資訊，這裡會新增一個管理pureftpd database 的使用者 pureftpd，使用者 pureftpd 的密碼設定請自行取代 ftppassword
# mysql -u root -p
Enter password: ← 輸入剛剛建立的新密碼
mysql> CREATE DATABASE pureftpd;
Query OK, 1 row affected (0.07 sec)
mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON pureftpd.* TO ‘pureftpd’@’localhost’ IDENTIFIED BY ‘ftppassword‘;
Query OK, 0 rows affected (0.19 sec)
mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON pureftpd.* TO ‘pureftpd’@’localhost.localdomain’ IDENTIFIED BY ‘ftppassword‘;
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
// 接著我們要在這個 pureftpd database 建立一個 ftpd table
mysql> USE pureftpd;
Database changed
mysql> CREATE TABLE ftpd (
-> User varchar(16) NOT NULL default ”,
-> status enum(‘0′,’1’) NOT NULL default ‘0’,
-> Password varchar(64) NOT NULL default ”,
-> Uid varchar(11) NOT NULL default ‘-1’,
-> Gid varchar(11) NOT NULL default ‘-1’,
-> Dir varchar(128) NOT NULL default ”,
-> ULBandwidth smallint(5) NOT NULL default ‘0’,
-> DLBandwidth smallint(5) NOT NULL default ‘0’,
-> comment tinytext NOT NULL,
-> ipaccess varchar(15) NOT NULL default ‘*’,
-> QuotaSize smallint(5) NOT NULL default ‘0’,
-> QuotaFiles int(11) NOT NULL default 0,
-> PRIMARY KEY (User),
-> UNIQUE KEY User (User)
-> ) TYPE=MyISAM;
Query OK, 0 rows affected, 1 warning (0.20 sec)
mysql> quit;
Bye
9.接著我們來測試一下 phpMyAdmin 的管理頁面
http://192.168.1.249/phpMyAdmin/
如果沒有成功，請關掉防火牆，或者開啟 port 80 連線
# service iptable stop ← 關閉防火牆
或
# vi /etc/sysconfig/iptables
-A INPUT -m state –state NEW -m tcp -p tcp –dport 80 -j ACCEPT ← 新增一行
# service iptables restart