Linux°²×°apache¡¢phpºÍmysql·½·¨
apacheµÄÔ´Âë°²×°
½«Ñ¹Ëõ°ü½âѹ֮ºó½øÈëÏàÓ¦µÄĿ¼
./configure \ #--------------------Ô¤±àÒëÃüÁî
"--prefix=/usr/local/apache" \ #--------------------°²×°Â·¾¶Îª“/usr/local/apache”
"--with-included-apr" \
"--enable-so" \ #--------------------¿ªÆôÏàÓ¦µÄÀ©Õ¹Ä£¿éÖ§³Ö
"--enable-deflate=shared" \
"--enable-expires=shared" \
"--enable-rewrite=shared" \
"--enable-static-support" \
"--disable-userdir"
make #--------------------±àÒë
make install #--------------------±àÒë°²×°
phpµÄÔ´Âë°²×°
½«Ñ¹Ëõ°ü½âѹ֮ºó½øÈëÏàÓ¦µÄĿ¼
./configure \ #--------------------Ô¤±àÒëÃüÁî
"--prefix=/usr/local/php" \ #--------------------°²×°Â·¾¶Îª“/usr/local/apache”
"--with-apxs2=/usr/local/apache/bin/apxs" \
"--with-config-file-path=/usr/local/php/etc" \
"--with-mysql=/usr/local/mysql" \
"--with-libxml-dir=/usr/local/libxml2" \
"--with-gd=/usr/local/gd2" \
"--with-jpeg-dir" \
"--with-png-dir" \
"--with-bz2" \
"--with-iconv-dir" \
"--with-zlib-dir " \
"--with-mcrypt=/usr/local/libmcrypt" \
"--enable-soap" \ #--------------------¿ªÆôÏàÓ¦µÄÀ©Õ¹Ä£¿éÖ§³Ö
"--enable-gd-native-ttf" \
"--enable-memory-limit" \
"--enable-ftp" \
"--enable-mbstring" \
"--enable-exif" \
"--disable-ipv6" \
"--disable-cgi" \
"--disable-cli"
mysqlµÄ°²×°
Ê×ÏÈΪmysql½¨Á¢ÏàÓ¦µÄÓû§ºÍ×é
groupadd mysql
useradd -g mysql -s /sbin/nologin mysql
ÕÒµ½mysql_install_db½Å±¾²¢Ö´ÐÐmysql_install_db --user=mysql£¨ÆäÖпÉÒÔÀàËÆµÄ¼ÓÏàÓ¦µÄ²ÎÊý
Mysql_install_db --defaults-file=/test/Mysql/my.cnf --user=Mysql Èô²»¼Ó²ÎÊý£¬°²×°Ê±Ä¬È϶ÁÈ¡/etc/my.cnf£©
ΪÕû¸ömysqlĿ¼¸³777ȨÏÞ£¬ÇÒÆäÖеÄdataĿ¼Óû§ºÍ×é¾ùΪmysql
chown -R root .
chown -R mysql data
chgrp -R mysql .
×îºóÆô¶¯Êý¾Ý¿â¼´¿É
bin/mysqld_safe --user=mysql &
Ïà¹ØÎĵµ£º
1. ¿ªÊ¼->¿ØÖÆÃæ°å->Ìí¼Ó»òɾ³ý³ÌÐò->Ð¶ÔØmysql
2. ¼ÙÉè֮ǰmysqlµÄ°²×°Ä¿Â¼ÊÇC:\Program Files\MySQL\MySQL Server 5.1/, ÄÇôÕâ¸öÏÂÃæ»¹±£ÁôÁËһЩ¶«Î÷£¬´ò¿ªmy.ini
3. ÕÒµ½#Path to the database root£¬ È»ºó°´ÕÕÕâ¸öPathÕÒµ½mysql,ɾµô
4. °ÑC:\Program Files\MySQLҲɾµô
5. ¿ªÊ¼->ÔËÐÐ ÊäÈër ......
¡¡¡¡Ñ¡ÔñÄãµÄÒýÇæ
¡¡¡¡ÄãÄÜÓõÄÊý¾Ý¿âÒýÇæÈ¡¾öÓÚMySQLÔÚ°²×°µÄʱºòÊÇÈçºÎ±»±àÒëµÄ¡£ÒªÌí¼ÓÒ»¸öеÄÒýÇæ£¬¾Í±ØÐëÖØÐ±àÒëMySQL¡£½ö½öΪÁËÌí¼ÓÒ»¸öÌØÐÔ¶ø±àÒë
Ó¦ÓóÌÐòµÄ¸ÅÄî¶ÔÓÚWindowsµÄ¿ª·¢ÈËÔ±À´Ëµ¿ÉÄÜºÜÆæ¹Ö£¬µ«ÊÇÔÚUnixÊÀ½çÀÕâÒѾ³ÉΪÁ˱ê×¼¡£ÔÚȱʡÇé¿öÏ£¬MySQLÖ§³ÖÈý¸öÒý
Çæ£ºISAM¡¢MyISAMºÍHEAP¡£ÁíÍâÁ½ÖÖ ......
ÔÚMySqlÖеÄÄ£ºý²éѯºÍÔÚMSSQLÖеIJ¶à£¬±¾¼Ç¼Ö÷ÒªÊÇ˵ÔÚJDBCÖÐʹÓÃPreparedStatementÀ´¹¹ÔìÒ»¸öÄ£ºý²éѯµÄÓï¾ä¡£
Ä£ºý²éѯSQLÓï¾ä£ºSELECT * from tableA WHERE colA LIKE '%ҪƥÅäµÄÄÚÈÝ%'
¹¹ÔìPreparedStatement£º
String sql = "SELECT * from tableA WHERE colA LIKE [-ÕâÀïÌîÊ²Ã´ÄØ£¿-]";
PreparedS ......
Ö¸ÁîÃû³Æ : chmod
ʹÓÃȨÏÞ : ËùÓÐʹÓÃÕß
ʹÓ÷½Ê½ : chmod [-cfvR] [--help] [--version] mode file...
˵Ã÷ : Linux/Unix µÄµµ°¸µ÷ÓÃȨÏÞ·ÖΪÈý¼¶ : µµ°¸ÓµÓÐÕß¡¢Èº×é¡¢ÆäËû¡£ÀûÓà chmod ¿ÉÒÔ½åÒÔ¿ØÖƵµ°¸ÈçºÎ±»ËûÈËËùµ÷Óá£
²ÎÊý :
mode : ȨÏÞÉ趨×Ö´®£¬¸ñʽÈçÏ : [ugoa...][[+-=][rwxX]...][,...]£¬ÆäÖÐ
......
#find ... -exec rm {} \;
#find ... | xargs rm -rf
Á½Õß¶¼¿ÉÒÔ°ÑfindÃüÁî²éÕÒµ½µÄ½á¹ûɾ³ý£¬ÆäÇø±ð¼òµ¥µÄ˵ÊÇǰÕßÊǰÑfind·¢ÏֵĽá¹ûÒ»´ÎÐÔ´«¸øexecÑ¡ÏÕâÑùµ±ÎļþÊýÁ¿½Ï¶àµÄʱºò£¬¾Í¿ÉÄÜ»á³öÏÖ“²ÎÊýÌ«¶à”Ö®ÀàµÄ´íÎó£¬Ïà±È½Ï¶øÑÔ£¬ºóÕ߾ͿÉÒÔ±ÜÃâÕâ¸ö´íÎó£¬ÒòΪxargsÃüÁî»á·ÖÅú´ÎµÄ´¦Àí½á¹û¡£ÕâÑù¿´À´£ ......