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

ubuntu8.04.2ÏÂApache+Resin+Mysql°²×°+ÐéÄâÖ÷»úÅäÖÃ

 Ò» Apache°²×°
# tar zxvf httpd-2.2.14.tar.gz(½âѹ)
# cd httpd-2.2.14(½øÈë½âѹºóµÄĿ¼)
# ./configure --prefix=/usr/local/apache2 --enable-so --enable-mods-shared=all
  (ÃüÁî#./configure --help¿ÉÒԲ鿴configureµÄÅäÖòÎÊý
  --prefix=°²×°Â·¾¶
  --enable-so //´ò¿ª DSO Ö§³ÖµÄ apache ºËÐÄÄ£¿é
  --enable-mods-shared=all //½«È«²¿µÄÄ£°å±àÒë³ÉDSO£¬¶ÔÓÚ²»ÐèÒªÎÒÃÇ¿ÉÒÔÔÚhttpd.confÈ¥µô
  )
# make
# make install
configureʱ³öÏÖ±àÒë´íÎóÌáʾΪûC±àÒ빤¾ß£¬½â¾ö·½·¨£º
°²×°GCC
#sudo apt-get install build-essential
³öÏÖ¹ØÓÚzlibµÄ´íÎó£¬Ô­ÒòÊÇȱÉÙzlib
linuxϱàÒë°²×°zlib
zlib¹Ù·½ÍøÕ¾£º
http://www.zlib.net
ÉÏÏÂÔØÔ´ÂëÀ´°²×°zlibÈí¼þ°ü¡£
Ä¿Ç°×îа汾zlibÊÇzlib1.2.3£¬°²×°¿ªÊ¼£»
# wget http://www.zlib.net/zlib-1.2.3.tar.gz
# tar -xvzf zlib-1.2.3.tar.gz
# cd zlib-1.2.3.tar.gz
# ./configure
# make
# sudo make install
Æô¶¯Apache(rootÓû§²ÅÄÜ)
# /usr/local/apache2/bin/apachectl start
²é¿´±àÒë½øapacheµÄÄ£¿é
# /usr/local/apache2/bin/httpd -l
¿ª»úÆô¶¯Apache
# cp /usr/local/apache2/bin/apachectl /etc/init.d/apachectl
# sysvconfig(ÊÇͼÐνçÃ棬½«apachectlÑ¡ÖÐ)
=======================================================================================================================
¶þ Mysql°²×°
# tar zvxf mysql-5.1.39.tar.gz
# cd mysql-5.1.39
# ./configure --prefix=/usr/local/mysql --with-charset=utf8 --with-collation=utf8_bin --with-extra-charsets=big5,ascii,gb2312,gbk,utf8,latin1
          //ĬÈϵÄ×Ö·û¼¯È±Ê¡Îªlatin1¡£
          //ÆäÖУ¬utf8¶ÔÓ¦¿ÉÓõÄcollationֵΪ£ºutf8_bin¡¢utf8_general_ci¡¢utf8_unicode_ci
          //extraÖ§³ÖÒ²¿ÉÒÔʹÓà "--with-extra-charsets=all"¡£
          //ĬÈÏconfigure²ÎÊýϲ»»á°²×°gbk±àÂë
ÅäÖóɹ¦»áÌáʾ£º
MySQL has a Web site at [URL="http://www.mysql.com/"][COLOR=#000000]http://www.mysql.com/[/COLOR][/URL] whic


Ïà¹ØÎĵµ£º

mysql Ô´Âë±àÒë°²×°

»·¾³ rhel5.4
×°ºÃgcc ºÍÏàÓ¦µÄ¿â¡£ÎÒÕâ±ßÓöµ½curses¡£DebianϵͳµÄ»°Ðè°²×°apt-get install libncurses5-dev¡£
ÏÂÔØmysqlÔ´Âë°ü£¬ÎÒ×Ô¼ºÔÚmyslq¹Ù·½ÍøÕ¾ÉÏÏÂÁËÒ»¸ö“mysql-5.0.87.tar.gz”
cd /usr/local/src/
½â°ü tar zxvf mysql-5.0.87.tar.gz
cd mysql-5.0.87
./configure --prefix=/usr/local/servic ......

MySQL£¨asp.net£© ÊÂÎñ

 try
        {
            string _conStr = "Driver={MySQL ODBC 3.51
Driver};server=localhost;database=test;uid=test;password=1;option=3";
          & ......

¸ã¶¨MySQLÊý¾Ý¿âÖÐÎÄÄ£ºý¼ìË÷ÎÊÌâ

ÔÚ MySQLÏ£¬ÔÚ½øÐÐÖÐÎÄÄ£ºý¼ìË÷ʱ£¬¾­³£»á·µ»ØһЩÓëÖ®²»Ïà¹ØµÄ¼Ç¼£¬Èç²éÕÒ "%a%" ʱ£¬·µ»ØµÄ¿ÉÄÜÓÐÖÐÎÄ×Ö·û£¬È´Ã»ÓÐa×Ö·û´æÔÚ¡£±¾ÈËÒÔÇ°Ò²ÔøÓöµ½¹ýÀàËÆÎÊÌ⣬¾­ÏêϸÔĶÁMySQLµÄManual£¬·¢ÏÖ¿ÉÒÔÓÐÒ»ÖÖ·½·¨ºÜ·½±ãµÄ½â¾ö²¢µÃµ½ÂúÒâµÄ½á¹û¡£
¡¡¡¡Àý×Ó£º
¡¡¡¡Ï£Íûͨ¹ý“±êÌ┶ÔÐÂÎÅ¿â½øÐмìË÷£¬¹Ø¼ü×Ö¿ÉÄÜ°üº¬Ê ......

¡¾×ª¡¿MySQLÓÅ»¯²½Öè¼°my.cnf»º´æÓÅ»¯

1¡¢¿´»úÆ÷ÅäÖã¬Ö¸Èý´ó¼þ£ºcpu¡¢ÄÚ´æ¡¢Ó²ÅÌ
2¡¢¿´mysqlÅäÖòÎÊý
3¡¢²éϵmysqlÐÐ״̬£¬¿ÉÒÔÓÃmysqlreport¹¤¾ßÀ´²é¿´
4¡¢²é¿´mysqlµÄÂý²éѯ
ÒÀ´Î½â¾öÁËÒÔÉÏÎÊÌâÖ®ºó£¬ÔÙÀ´²éÕÒ³ÌÐò·½ÃæµÄÎÊÌâ
my.cnf»º´æÓÅ»¯
ÔÚ my.cnf ÖÐÌí¼Ó/ÐÞ¸ÄÒÔÏÂÑ¡Ïî:
#È¡ÏûÎļþϵͳµÄÍⲿËø
 skip-locking
 #²»½øÐÐÓòÃû·´½âÎö,×¢Òâ ......

ÊÕ¼¯Ò»Ð©mysqlʹÓ÷½·¨

1.linuxÏÂÆô¶¯mysqlµÄÃüÁ
  mysqladmin start
/ect/init.d/mysql start (Ç°ÃæΪmysqlµÄ°²×°Â·¾¶)
2.linuxÏÂÖØÆômysqlµÄÃüÁ
  mysqladmin restart
/ect/init.d/mysql restart (Ç°ÃæΪmysqlµÄ°²×°Â·¾¶)
3.linuxϹرÕmysqlµÄÃüÁ
  mysqladmin shutdown
  /ect/init.d/mysql&nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ