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

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 &


Ïà¹ØÎĵµ£º

mysql¸÷ÒýÇæÓÅÊÆÐ¡¼Ç


¡¡¡¡Ñ¡ÔñÄãµÄÒýÇæ
¡¡¡¡ÄãÄÜÓõÄÊý¾Ý¿âÒýÇæÈ¡¾öÓÚMySQLÔÚ°²×°µÄʱºòÊÇÈçºÎ±»±àÒëµÄ¡£ÒªÌí¼ÓÒ»¸öеÄÒýÇæ£¬¾Í±ØÐëÖØÐ±àÒëMySQL¡£½ö½öΪÁËÌí¼ÓÒ»¸öÌØÐÔ¶ø±àÒë
Ó¦ÓóÌÐòµÄ¸ÅÄî¶ÔÓÚWindowsµÄ¿ª·¢ÈËÔ±À´Ëµ¿ÉÄÜºÜÆæ¹Ö£¬µ«ÊÇÔÚUnixÊÀ½çÀÕâÒѾ­³ÉΪÁ˱ê×¼¡£ÔÚȱʡÇé¿öÏ£¬MySQLÖ§³ÖÈý¸öÒý
Çæ£ºISAM¡¢MyISAMºÍHEAP¡£ÁíÍâÁ½ÖÖ ......

MySQL Êý¾Ý¿â³£ÓÃÃüÁî


1¡¢MySQL³£ÓÃÃüÁî
create database name; ´´½¨Êý¾Ý¿â
use databasename; Ñ¡ÔñÊý¾Ý¿â
drop database name Ö±½Óɾ³ýÊý¾Ý¿â£¬²»ÌáÐÑ
show tables; ÏÔʾ±í
describe tablename; ±íµÄÏêϸÃèÊö
select ÖмÓÉÏdistinctÈ¥³ýÖØ¸´×Ö¶Î
mysqladmin drop databasename ɾ³ýÊý¾Ý¿âǰ£¬ÓÐÌáʾ¡£
ÏÔʾµ±Ç°mysql°æ±¾ºÍµ±Ç°ÈÕÆÚ
s ......

MySqlÖеÄÄ£ºý²éѯ

ÔÚMySqlÖеÄÄ£ºý²éѯºÍÔÚMSSQLÖеIJ¶à£¬±¾¼Ç¼Ö÷ÒªÊÇ˵ÔÚJDBCÖÐʹÓÃPreparedStatementÀ´¹¹ÔìÒ»¸öÄ£ºý²éѯµÄÓï¾ä¡£
Ä£ºý²éѯSQLÓï¾ä£ºSELECT * from tableA WHERE colA LIKE '%ҪƥÅäµÄÄÚÈÝ%'
¹¹ÔìPreparedStatement£º
String sql = "SELECT * from tableA WHERE colA LIKE [-ÕâÀïÌîÊ²Ã´ÄØ£¿-]";
PreparedS ......

¶Áºó¸Ð2 linuxѧϰ

¹ûÈ»ÊǹýÁ˺þã¬Õâ´ÎÓÖ×¼±¸¿ªÊ¼Ñ§Ï°linuxÁË¡£ÏµÍ³µÄѧϰºÍÔÚÍøÉÏÕÒµãÖ»ÑÔÆ¬ÓïµÄÁ˽â¹ûÈ»ÊDz»Ò»ÑùµÄ¡£¿´ÍêÕâµãÕ½ڣ¬×Ô¼º¾ÍÔÙ×ö×ö×ܽá°É¡£
ÎÒ´ó¸ÅÁ˽âÏÂÀ´ÊÇÕâÑùµÄ¡£¶ÔÓÚlinuxµÄÎļþϵͳÀ´Ëµ£¬ÏÂÃæÓкܶà“Îļþ”£¬ÕâЩ“Îļþ”°üÀ¨ÁËÉ豸¡¢´ÅÅÌÇý¶¯Æ÷µÈµÈ¡£±ÈÈç"\"±íʾ¸ùĿ¼£¬¶ø\userÊÇÓÃÀ´×°Õû¸ö²Ù ......

UNIX/Linux ϵͳ´ÅÅÌ ¿Õ¼ä¼à¿Ø ×Ô¶¯»¯½Å±¾ ʾÀý

UNIX/Linux ϵͳ´ÅÅÌ ¿Õ¼ä¼à¿Ø ×Ô¶¯»¯½Å±¾ ʾÀý
1. ·ÖÇø¼à¿Ø /root/disktab ÎļþʾÀý
2. checkdisk ½Å±¾³õʼ»¯²¿·Ö
3. checkdisk ½Å±¾·ÖÎö /root/disktab Îļþ²¿·Ö
4.ÖеĽű¾ÊµÏÖÁËʵʱ¼à¿Ø²¢¼ì²â·ÖÇø×´¿ö£¬Í¨¹ýÇ°Ãæ»ñµÃµÄÓû§¶¨ÒåµÄãÐÖµºÍ df ÃüÁîµÄÊä³ö½øÐбȽϣ¬Èç¹û df ÏÔʾµÄij¸ö·ÖÇøµÄ¿Õ¼äÕ¼Óó¬¹ýÁËÓû§¶¨ÒåµÄã ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ