我是在fedora的環境底下使用mysql
我想慶問是否有任何的使用"範例"
因為我目前只有安裝mysql
而不知道如何去使用它!!
有的大大們...拜託好心分享一下唷!!

你最好也要裝一下
apache+php+phpmyadmin

這樣要練習就方便多了..

將下列軟件下載到/tmp目錄。
1.mysql-4.0.20.tar.gz 下載地址: http://downloads.mysql.com/ar....0.20.tar.gz
2.apache 下載地址： http://apache.mirrors.hoobly.....0.52.tar.gz
3.php 下載地址： http://www.php.net/get/php-5....p.net/mirror
4.phpMyAdmin-2.6.0-rc3下載地址： http://xj-http.skycn.net:8080...0-rc3.tar.gz
5.pureftpd 下載地址： ftp://ftp.pureftpd.org/pure-....0.20.tar.gz
6.pureftpd_php_manager下載地址： http://www.fuwu.net.cn/soft/u...nager.tar.gz

cd /tmp

1.先安裝mysql

tar zxvf mysql-4.0.20.tar.gz

cd mysql-4.0.20

#./configure --prefix=/usr/local/mysql --localstatedir=/var/mysql/data
#make
#make install
#cd /usr/local/mysql/bin
#./mysql_install_db

#useradd mysql
#chown -R mysql:mysql /usr/local/mysql
#chown -R mysql:mysql /var/mysql
#./mysqld_safe -u root & (啟動mysql)
#./mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 4.0.20

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
如果能看到上面的信息，那麼mysql的安裝就OK了。
# ./mysqladmin -u root password 『123456』 (默認密碼為空自己添加一個吧)

# cp /usr/local/mysql/support-files/mysql.server /etc/rc.d/init.d/mysqld
#chown -R mysql:mysql /etc/rc.d/init.d/mysqld
# chkconfig --add mysqld (將mysql添加進自啟動服務列表裡)
#ntsysv (選中myslqd 則每次系統啟動都能啟動mysql)

2.安裝apache

cd /tmp

tar zxvf httpd-2.0.52.tar.gz

cd httpd-2.0.52

#./configure –enable-so –enable-rewrite
#make
#make install
編譯安裝完成後,啟動apache
#cd /usr/local/apache2/bin
#./apachectl start
這樣就啟動了apache服務器
vi /etc/rc.d/rc.local在裡面添加這麼一行/usr/local/apache2/apachectl start (讓apche隨系統啟動)
mkdir /var/www/html
vi /usr/local/apache2/conf/httpd.conf
308行DocumentRoot "/var/www/html"
333行<Directory "/var/www/html">

3.安裝php5.0

在安裝php之前先把libxml2安裝上,否則安裝php5.0會出錯的。
下載地址：http://www.fuwu.net.cn/soft/uploads...l2-2.6.8.tar.gz (保存在/tmp目錄裡)
cd /tmp
tar zxvf libxml2-2.6.8.tar.gz
cd libxml2-2.6.8
# ./configure
# make
# make install
編譯安裝成功後即可

cd /tmp
tar zxvf php5.0.tar.gz
cd php-5.0.0
#./configure–with-apxs2=/usr/local/apache2/bin/apxs –with-mysql=/usr/local/mysql
# make
# make install
安裝完成後,修改apache的配置文件httpd.conf
在相應的位置加入以下語句:
AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps
AddType application/x-httpd-php .php3
重啟apache即可;
測試PHP
編寫 info.php文件,內容如下:
<?php
echo phpinfo();
?>
將其存放在/var/www/html目錄下,在瀏覽器中輸入:

http://127.0.0....o.php

如果能看到php的配置信息，就表示以上的配置成功！

4.解壓phpMyAdmin-2.6.0-rc3.tar.gz

cd /tmp
tar zxvf phpMyAdmin-2.6.0-rc3.tar.gz
cp -R phpMyAdmin-2.6.0-rc3 /var/www/html/phpmyadmin
cd /var/www/html/phpmyadmin
vi config.inc.php
將83行的config改為http保存退出。
http://你的IP/phpmyadmin/
用戶名：root
密碼:123456 (配置mysql時所設置的)
能看見mysql數據庫信息則表示配置成功！

5.安裝pureftpd-ftpd-1.0.21

cd /tmp

tar zvxf pure-ftpd-1.0.21.tar.gz
cd pure-ftpd-1.0.21
#./configure --prefix=/usr/local/pureftpd --with-mysql=/usr/local/mysql --with-paranoidmsg --with-shadow --with-welcomemsg --with-uploadscript --with-quotas --with-cookie --with-pam --with-virtualhosts --with-virtualroot --with-diraliases --with-sysquotas --with-ratios --with-ftpwho --with-throttling --with-language=simplified-chinese


make
make check
make install
cd configuration-file
chmod u+x pure-config.pl
cp pure-config.pl /usr/local/sbin/
cp pure-ftpd.conf /usr/local/etc/
vi /usr/local/etc/pure-ftpd.conf
按你的需要編輯pure-ftpd.conf

# Cage in every user in his home directory
# 限制每個用戶到自己的根目錄
ChrootEveryone yes
# Disallow anonymous connections. Only allow authenticated users.
# 取消anonymous用戶
NoAnonymous yes
# MySQL configuration file (see README.MySQL)
# pureftpd-mysql.conf文件的位置
MySQLConfigFile /usr/local/etc/pureftpd-mysql.conf
#自己創建用戶目錄
CreateHomeDir yes

#讓pure-ftpd隨系統啟動
#cd ..
# cp ./contrib/redhat.init /etc/init.d/pureftpd
# vi /etc/init.d/pureftpd

#!/bin/bash
#
# Startup script for the pure-ftpd FTP Server $Revision: 1.3 $
#
# chkconfig: 2345 85 15
# description: Pure-FTPd is an FTP server daemon based upon Troll-FTPd
# processname: pure-ftpd
# pidfile: /var/run/pure-ftpd.pid
# config: /usr/local/etc/pure-ftpd.conf

# Source function library.
. /etc/rc.d/init.d/functions
RETVAL=0

# Path to the pure-ftp binaries.
prog=pure-config.pl
fullpath=/usr/local/sbin/$prog
pureftpwho=/usr/local/pureftpd/sbin/pure-ftpwho


start() {
echo -n $"Starting $prog: "
$fullpath /usr/local/etc/pure-ftpd.conf --daemonize
RETVAL=$?
[ $RETVAL = 0 ] && touch /var/lock/subsys/$prog
echo
}
. . . . . . . .
. . . . . . . . . .略

# chmod 755 /etc/init.d/pureftpd
# chown root:root /etc/init.d/pureftpd
# chkconfig --add pureftpd
# chkconfig pureftpd on

6.配置pureftpd_php_manager

cd /tmp

tar zvxf pureftpd_php_manager.tar.gz
cd pureftpd_php_manager
mv pureftpd-mysql.conf.sample /usr/local/etc/pureftpd-mysql.conf
cd ..
cp -R pureftpd_php_manager /var/www/html/pureftpd_php_manager
cd /var/www/html/pureftpd_php_manager
vi pureftp.config.php

按照你的需要修改裡面的設置代碼:

<?php
######################
####### SETUP ########
######################

// Your exactly located mysql config file for pureftpd
$PUREFTP_CONFIG_FILE = '/usr/local/etc/pureftpd-mysql.conf'

// The location where all the Forms directed to. (Mayby no change needed)
$SELF_URL = 'index.php'

// The location of your pure-ftpdwho binary (set this to chmod 4711)
$FTP_WHO = "/usr/local/pureftpd/sbin/pure-ftpwho";

#######################
# DEFAULT NEW-USER PARAMS #
#######################

$DefaultUser = ""; # Default User Logon
$DefaultPass = ""; # Default User Password
$DefaultUid = ""; # Default User ID ( must be a real user acct )
$DefaultGid = "2000"; # Default Group ID ( must be a real group acct )
$DefaultDir = "/home"; # Default User Dir ( use /./ at the end to chroot )
$DefaultUL = "0"; # Default Upload Throttle ( 0 disables it )
$DefaultDL = "0"; # Default Download Throttle ( 0 disables it )
$Defaultip = "*"; # Default IP restrictions ( * = any IP )
$DefaultQS = "50"; # Default Quota Size ( 0 disables it )
$Defaultcmt = ""; # Default Comment for user

// UA
$DefaultQF = "0"; # Default Quota Files ( 0 disables it )
$PWC = "55"; # Vorsatz fuerr Crypt Password
?>

增加用戶組及用戶
#groupadd ftpusers -g 2000
#useradd ftp -u 2000 -g ftpusers -s /sbin/nologin

刪除多餘的東西
rm -f history.txt pureftpd-mysql.conf.sample
如果要投入真實的使用，最好用apache做身份驗證！

因為我們是放到網上執行的﹐所以你肯定不想每個人都跑去看你FTP用戶吧﹗
我一般採用HTPASSWD驗證﹐具體請這樣子做﹐仍用我前面的例子﹕
我的pureftpd_php_manager目錄位於 /var/www/html/pureftpd_php_manager目錄﹐
修改httpd.conf在apache的虛擬主機那一小節添加如下內容﹕

<Directory "/var/www/html/pureftpd_php_manager">
deny from all
Options None
AllowOverride AuthConfig
Order deny,allow
</Directory>

這樣﹐若有人想進入該目錄﹐必須通過apache驗證﹐保證我們的安全（不是絕對安全）
cd /var/www/html/pureftpd_php_manager
再進入pureftpd_php_manager的目錄﹐使用vi建立一個.htaccess的認證文件﹕
vi .htaccess
內容如下﹕
AuthType Basic
AuthUserFile /usr/local/apache2/bin/pureftpd.passwd
AuthName pureftpd
require valid-user
satisfy any
存盤退出後﹐我們就可以使用htpasswd命令添加允許進入的該目錄的用戶了﹗
cd /usr/local/apache2/bin/
進入該目錄
./htpasswd -bc pureftpd.passwd ftp 123456
這樣將會在你的當前目錄﹐創建一個pureftpd.passwd的身份驗證文件﹐用戶名是ftp﹐密碼是123654﹐你可以

改為你自己需要。

http://你的ip/phpmyadmin/ 用戶名：root 密碼:123456
新建一個用戶
用戶名為pureftpd
密碼為123456
再次登錄http://你的ip/phpmyadmin/ 用戶名：pureftpd 密碼:123456
新建一個pureftpd數據庫
在數據庫pureftpd運行SQL查詢 --內容如下：

DROP TABLE IF EXISTS ftpd;
CREATE TABLE ftpd (
User varchar(16) NOT NULL default '',
status enum(Ɔ',Ƈ') NOT NULL default Ɔ',
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 Ɔ',
DLBandwidth smallint(5) NOT NULL default Ɔ',
comment tinytext NOT NULL,
ipaccess varchar(15) NOT NULL default '*',
QuotaSize smallint(5) NOT NULL default Ɔ',
QuotaFiles int(11) NOT NULL default 0,
PRIMARY KEY (User),
UNIQUE KEY User (User)
) TYPE=MyISAM;


編輯/usr/local/etc/pureftpd-mysql.conf

vi /usr/local/etc/pureftpd-mysql.conf

# If you want to use the Socket connect methode comment out the
# Lines with MMYSQLServer and MYSQLPort.
# If you want to use the Port methode comment out the MYSQLSocket line
MYSQLSocket /tmp/mysql.sock
MYSQLServer localhost
MYSQLPort 3306
MYSQLUser pureftpd (數據庫用戶名)
MYSQLPassword 123456 (數據庫用戶的密碼)
MYSQLDatabase pureftpd (FTP數據數據庫)
MYSQLCrypt cleartext (密碼加密方式"cleartext", "crypt", "md5" and "password" cleartext 明文，crypt，md5,password是Backend password(『your-passwd』)函數（MYSQL數據庫所使用的 )
MYSQLGetPW SELECT Password FROM ftpd WHERE User="\L" AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MYSQLGetUID SELECT Uid FROM ftpd WHERE User="\L" AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MYSQLGetGID SELECT Gid FROM ftpd WHERE User="\L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MYSQLGetDir SELECT Dir FROM ftpd WHERE User="\L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MySQLGetBandwidthUL SELECT ULBandwidth FROM ftpd WHERE User="\L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MySQLGetBandwidthDL SELECT DLBandwidth FROM ftpd WHERE User="\L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MySQLGetQTASZ SELECT QuotaSize FROM ftpd WHERE User="\L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MySQLGetQTAFS SELECT QuotaFiles FROM ftpd WHERE User="\L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")


手動啟動pureftpd
#/usr/local/sbin/pure-config.pl /usr/local/etc/pure-ftpd.conf

http://你的ip/pureftpd_php_manager/index.php
用戶名: ftp
密 碼 : 123456
新建一個ftp用戶
點擊ADD USR

Status Active (激活狀態)
Username test (ftp用戶名)
Password 888888 (ftp用戶密碼)
UID 2001 (用戶ID)
GID 2000 (組ID)
DIR /home/test (ftp用戶根目錄)
UL Throttle kb/s 0 (上傳帶寬，0為不限制)
DL Throttle kb/s 0 (下載帶寬，0為不限制)
IP ACCESS * (ip訪問，*所有IP)
QuotaSize in MB 50 (限制空間)
QuotaFiles Anzahl 0 (限制文件個數，0為不限制)
COMMENT .....

別忘了Save

好了，在客戶端測試一下吧！

轉載自 http://www.chinalinuxpub.com/b....php?t=41042