Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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 Reference ManualÖÐÎİæ

MySQL Reference Manual for version 4.1.0-alpha.
¡¡ÒëÕßÐò
¡¡ÁÐÀàÐÍÓ뺯ÊýË÷Òý
6 MySQL ÓïÑԲο¼

6.1 ÓïÑԽṹ

6.1.1 ÎÄ×Ö£ºÔõôд×Ö·û´®ÓëÊý×Ö

6.1.1.1 ×Ö·û´®

 
6.1.1.2 Êý×Ö

 
6.1.1.3 Ê®Áù½øÖÆÖµ
......

mysqlÐÔÄܵļì²éºÍµ÷ÓÅ·½·¨

ÎÒÒ»Ö±ÊÇʹÓÃmysqlÕâ¸öÊý¾Ý¿âÈí¼þ£¬Ëü¹¤×÷±È½ÏÎȶ¨£¬Ð§ÂÊÒ²ºÜ¸ß¡£ÔÚÓöµ½ÑÏÖØÐÔÄÜÎÊÌâʱ£¬Ò»°ã¶¼ÓÐÕâô¼¸ÖÖ¿ÉÄÜ£º
1¡¢Ë÷ÒýûÓн¨ºÃ£»
2¡¢sqlд·¨¹ýÓÚ¸´ÔÓ£»
3¡¢ÅäÖôíÎó£»
4¡¢»úÆ÷ʵÔÚ¸ººÉ²»ÁË£»
1¡¢Ë÷ÒýûÓн¨ºÃ
Èç¹û¿´µ½mysqlÏûºÄµÄcpuºÜ´ó£¬¿ÉÒÔÓÃmysqlµÄclient¹¤¾ßÀ´¼ì²é¡£
ÔÚlinuxÏÂÖ´ÐÐ
/usr/local/mysql/bin/ ......

mysqlÃüÁ½õ

¡¾×¢£º¿ÉÒÔÔÚmysqlÖÐͨ¹ýmysql> SELECT VERSION();À´²é¿´Êý¾Ý¿â°æ±¾¡¿
ÕûÀí£ºleo
Ò»¡¢Á¬½ÓMYSQL¡£
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £­pÓû§ÃÜÂë
1¡¢Á¬½Óµ½±¾»úÉϵÄMYSQL¡£
Ê×ÏÈ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼mysql\bin£¬ÔÙ¼üÈëÃüÁîmysql -u root -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂë.×¢ÒâÓû§Ãûǰ¿ÉÒÔÓпոñÒ²¿ÉÒÔûÓпոñ£¬µ«ÊÇà ......

CentOS ÉÏmysql¶Ë¿Ú3306µÄÎÊÌâ

½ñÌì×°ÁËһ̨Linuxϵͳ£¬ÒÔǰ¶¼ÊÇRedHat£¬ºóÀ´Ìý˵ÓÐFedoraÁË£¬Ò»Ö±Ã»Óùý¡£ÕýºÃÏîÄ¿Àï»·¾³ÒªÓþÍÏëŪһ¸öÀ´ÍæÍ棬½á¹ûÏÖÔÚÈ˼Ò×îеÄÊÇCentOS£¬¾ÍÒ»ÕÅCD£¬ÆäËûµÄ¸ù¾ÝÐèÒª×Ô¼ºÉÏÍøDown£¬£¨ÎÒ²»Ï²»¶ÕâÑù×Ó¾Í×Ô¼ºÏÂÔØDVD°æ£©¡£°²×°ÍêÖ®ºóûÓÐͼÐνçÃæ£¬¶øÇÒûÓÐÌáʾÊäÈërootÃÜÂ룬»¹µÃµ½µ¥Óû§Ä£Ê½ÏÂÐ޸ġ£ºóÀ´ÏÂÔØÁËÒ»¸öͼÐÎ ......

mysql maatkit¹¤¾ß°²×°ºÍʹÓÃ(Ò»)

½ñÌ죬ҪÓÃexplain²é¿´mysqlµÄÖ´Ðй滮£¬µ«ÊǺÍPostgreSQL²»Í¬µÄÊÇ£¬Ö±½ÓÔÚmysqlÀïÃæÖ´ÐеĽá¹û¿É¶ÁÐÔ²»ÊǺܺã¬ÉÏÍøËÑÁËһȦ£¬·¢ÏÖÁËÒ»¸ö¹¤¾ßmaatkit£¬¿ÉÒÔ½²explainµÄ½á¹ûת»¯ÎªÊ÷×´½á¹¹²é¿´£¬ºÇºÇ£¬·½±ãÁ˺ܶà
°²×°°ì·¨£º
1. sudo yum install mysql
2. sudo yum install mysql-server
3. wget http://maatkit.googl ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ