任务四：LAMP平台网站搭建－apache
本次实验使用pure-ftpd<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
第一步安装
#sudo apt-get install pure-ftpd-mysql mysql-server
mysql-server已经安装过了
先来为pure-ftpd创建数据库
#mysql -u root -p
>CREATE DATABASE ftpusers;
>GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON ftpusers.* TO ''ftpadmin''@
''localhost'' IDENTIFIED BY ''ftpadminpassword'';
>GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON ftpusers.* TO ''ftpadmin''@
''localhost.localdomain'' IDENTIFIED BY ''ftpadminpassword'';
>flush privileges;
>USE ftpusers;
>CREATE TABLE IF NOT EXISTS ''users'' (
User varchar (16) NOT NULL default '''',
password varchar (32) NOT NULL default '''',
Uid int (11) NOT NULL,
Gid int (11)NOT NULL,
dir varchar (128) NOT NULL default '''',
QuotaFiles int (10) NOT NULL default ''500'',
QuotaSize int (10) NOT NULL default ''30'',
ULBandwidth int (10) NOT NULL default ''80'',
DLBandwidth int (10) NOT NULL default ''80'',
Ipaddress varchar (15) NOT NULL default ''*'',
Comment tinytext,
status enum(''0'',''1'') NOT NULL default ''1'',
ULRatio smallint (5) NOT NULL default ''1'',
DLRatio smallint (5) NOT NULL default ''1'',
PRIMARY KEY (user),
UNIQUE KEY (user)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
OK 这样数据库就弄好了
数据很长命令很辛苦,但是 我是 用phpmyadmin直接10秒钟搞定的
 网吧设有防火墙, 我去了一个朋友家实验,使用putty并成功连接到本计算机 |
