将权限限制在家里--加入
vi /etc/vsftpd/chroot_list
认证
然后，创建用户密码文本 vi /etc/vsftpd/vuser_passwd.txt ，注意奇行是用户名，偶行是密码
test 123456
接着，生成虚拟用户认证的db文件
db_load -T -t hash -f /etc/vsftpd/vuser_passwd.txt /etc/vsftpd/vuser_passwd.db
重启
service vsftpd restart
重启网卡：使用命令: service network restart
export LANG=en_US
在MySQL中建立用户口令数据库
[root@CentOS5 /]#mysql –u root –p
Enter password：我的密码
mysql> create database wwwwhyccn; #建立虚拟用户数据库，库名vftpuser
mysql> use wwwwhyccn; #进入vftpuser数据库
mysql> show tables;#展示数据表
mysql> show databases;#展示数据库
/etc/init.d/iptables status
GRANT alter,create,index,select,insert,update,drop,delete on wwwwhyccn.* TO wwwwhyccn@localhost IDENTIFIED BY "5mA5v1Z8107Ff3lJ"
GRANT alter,create,index,select,insert,update,drop,delete on adminwhyccn.* TO adminwhyccn@localhost IDENTIFIED BY "QsgYUtiWNLc7jDpq"
GRANT alter,create,index,select,insert,update,drop,delete on testwhyccn.* TO testwhyccn@localhost IDENTIFIED BY "hfQzDin8ZD7Iae4g"
备案转移网站
GRANT alter,create,index,select,insert,update,drop,delete on jznkw.* TO jznkw@localhost IDENTIFIED BY "k5n6cnR4ayQ9qsEF"
GRANT alter,create,index,select,insert,update,drop,delete on 0716gc.* TO 0716gc@localhost IDENTIFIED BY "DfOwAsB6el2L56ag"
GRANT alter,create,index,select,insert,update,drop,delete on 0716yy.* TO 0716yy@localhost IDENTIFIED BY "gSiVj83nMh3myNOZ"
GRANT alter,create,index,select,insert,update,drop,delete on xglryy.* TO xglryy@localhost IDENTIFIED BY "GtAPsdATTaD00kqK"
ip58lu
GRANT alter,create,index,select,insert,update,drop,delete on ip58lu.* TO ip58lu@localhost IDENTIFIED BY "5mAip58lu07Ff3lJ"
