Ubuntu 8.04 vsftpd mysql pamµÄftp·þÎñÆ÷¶ËÎÞ´íÅäÖÃ
ÅäÖû·¾³:UUbuntu 8.04
1.°²×°vsftpd
sudo apt-get install vsftpd
2.´´½¨guestÓû§
vsftpd°²×°µÄʱºò»á×Ô¶¯°²×ªÒ»¸öftpÓû§£¬ÔÚpasswdÖÐɾ³ý
sudo useradd virtual
ÉèÖÃvirtualµÄÃÜÂëΪwebftp
sudo passwd virtual
±à¼virtualÓû§µÄÖ÷Ŀ¼²¢ÉèÖÃshell
sudo vim /etc/passwd
ÎÒÉèÖõÄÊÇvirtual:x:1001:1001::/var/www:/bin/false
/var/www virtualµÄÖ÷Ŀ¼
/bin/false ½ûÖ¹virtualÓû§Öն˵ǽ
3.ÉèÖÃmysqlÊý¾Ý¿âºÍÓû§È¨ÏÞ
ÔÚphpmyadminÖн¨Á¢vsftpÊý¾Ý¿â vsftpÓû§
½¨Á¢Óû§±í
create table users(name char(16) binary,passwd char(16) binary);
²¢ÊÚȨvistualÓû§users±íµÄselectȨÏÞ£¬²¢ÉèÖÃÃÜÂë¡£
4.ÉèÖÃMySQLµÄPAMÑéÖ¤
°²×°libpam-mysql
sudo apt-get install libpam-mysql
ÒªÉèÖÃvsftpdµÄPAMÑéÖ¤Îļþ
sudo cp /usr/share/doc/vsftpd/EXAMPLE/VIRTUAL_USERS/vsftpd.pam /etc/pam.d/vsftpd
°ÑÄÚÈÝÌ滻ΪÈçÏ£º
auth required/lib/security/pam_mysql.so user=virtual passwd=webftp host=localhostdb=vsftp table=users usercolumn=name passwdcolumn=passwd crypt=2
account required/lib/security/pam_mysql.so user=virtual passwd=webftp host=localhostdb=vsftp table=users usercolumn=name passwdcolumn=passwd crypt=2
5.ÉèÖÃvsftpd.conf
guest_enable=YES
guest_username=virtual
ÕâÁ½Ïî±ØÐë´ò¿ª£¬ÆäËûÅäÖÃÇë²éÔÄvsftpd.confµÄÅäÖÃÊÖ²á
6.ÐéÄâÓû§Ä¿Â¼µÄȨÏÞ¸ÄΪֻÄÜÓÉvirtual²Ù×÷£º
sudo chown virtual.virtual /var/www
sudo chmod 755 /var/www
virtual»ñµÃwwwÎļþ¼ÐµÄȨÏÞ£¬²¢ÉèÖÃwwwÎļþ¼ÐȨÏÞΪ755
ÖÁ´Ë£¬×î»ù±¾µÄÐéÄâÓû§ÒѾÍê³É¡£
sudo /etc/init.d/vsftpd restart
ÖØÆôvsftpd·þÎñºó¼´¿ÉÒÔÓÃusers±íÖÐÉèÖõÄÓû§ÃûÃÜÂë½øÐÐwwwÎļþ¼ÐµÄ·ÃÎÊÁË¡£
Ïà¹ØÎĵµ£º
MySQL³£ÓòÙ×÷»ù±¾²Ù×÷£¬ÒÔ϶¼ÊÇMySQL5.0ϲâÊÔͨ¹ýÊ×ÏÈ˵Ã÷Ï£¬¼ÇסÔÚÿ¸öÃüÁî½áÊøʱ¼ÓÉÏ£»£¨·ÖºÅ£©
1.µ¼³öÕû¸öÊý¾Ý¿â
mysqldump -u Óû§Ãû -p --default-character-set=latin1 Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû(Êý¾Ý¿âĬÈϱàÂëÊÇlatin1)
mysqldump -u wcnc -p smgp_apps_wcnc > wcnc.sql
2.µ¼³öÒ»¸ö±í
mysqldump -u Ó ......
¼ÙÉèÄãÊÇÒ»¸öAccess¿ª·¢ÈËÔ±£¬¶øÄãÏëÒÆÖ²Ò»¸öAccessºǫ́µ½Ò»¸ö±¾µØµÄMySQL ·þÎñÆ÷ÓÃÓÚ¿ª·¢ºÍ²âÊÔ¡£Ä㽫ά»¤Äã×Ô¼ºµÄ½â¾ö·½°¸²¢ÀÖÓÚʹÓÃCommunity Server
¡¡¡¡µÚÒ»²½——°²×°MySQL
¡¡¡¡µ½http://dev.mysql.com/downloads/ ÏÂÔØÕâ¸ö·þÎñÆ÷¡¢MySQL GUI¹¤¾ßºÍMySQL ODBCÇý¶¯¡£Äã¿ÉÒÔÑ¡ÔñµÄ·þÎñÆ÷ÓУº5.0, 5.1»ò6.0 ......
ÓкܶàÓ¦ÓÃÏîÄ¿, ¸ÕÆð²½µÄʱºòÓÃMYSQLÊý¾Ý¿â»ù±¾ÉÏÄÜʵÏÖ¸÷ÖÖ¹¦ÄÜÐèÇó£¬Ëæ×ÅÓ¦ÓÃÓû§µÄÔö¶à£¬Êý¾ÝÁ¿µÄÔö¼Ó£¬MYSQL½¥½¥µØ³öÏÖ²»¿°ÖظºµÄÇé¿ö£º
Á¬½ÓºÜÂýÉõÖÁå´»ú£¬ÓÚÊǾÍÓаÑÊý¾Ý´ÓMYSQLǨµ½ORACLEµÄÐèÇó£¬Ó¦ÓóÌÐòÒ²ÒªÏàÓ¦×öһЩÐ޸ġ£±¾ÈË×ܽá³öÒÔϼ¸µã×¢ÒâÊÂÏϣÍû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
1£® ×Ô¶¯Ôö³¤µÄÊý¾ÝÀàÐ ......
1. ÔÚʹÓÃNavicat 8 for MySQL¿Í»§¶Ë´´½¨Êý¾Ý¿âʱ£¬±àÂëµÄÉèÖÃÈçÏÂͼ£º
2. ½«°²×°Ä¿Â¼F:\MySQL\MySQL Server 5.1Ï£¬my.iniÎļþÉèÖñäÁ¿Öµdefault-character-set=gbk £¨°üº¬Á½´¦£¬¿É²éÕÒdefault-character-set£©£¬È»ºóÖØÆôMYSQL·þÎñ¡£ ......
½ñÌ죬ҪÓÃexplain²é¿´mysqlµÄÖ´Ðй滮£¬µ«ÊǺÍPostgreSQL²»Í¬µÄÊÇ£¬Ö±½ÓÔÚmysqlÀïÃæÖ´ÐеĽá¹û¿É¶ÁÐÔ²»ÊǺܺã¬ÉÏÍøËÑÁËһȦ£¬·¢ÏÖÁËÒ»¸ö¹¤¾ßmaatkit£¬¿ÉÒÔ½²explainµÄ½á¹ûת»¯ÎªÊ÷×´½á¹¹²é¿´£¬ºÇºÇ£¬·½±ãÁ˺ܶà
°²×°°ì·¨£º
1. sudo yum install mysql
2. sudo yum install mysql-server
3. wget http://maatkit.googl ......