ubuntuÏÂÅäÖÃApache+Mysql+PHP
½ñÌì¿´µ½Ò»Æª¹ØÓÚubuntuÏÂÅäÖÃApache+Mysql+PHPµÄÎÄÕ£¬¾õµÃºÜÓÐÓ㬼ÓÒÔ×Ô¼ºµÄÀí½âºÍ±àд£¬¼Ç¼ÏÂÀ´¡£
Ò»¡¢ApacheµÄ°²×°
Apache×÷Ϊһ¸ö¹¦ÄÜÇ¿´óµÄWeb³ÌÐò£¬×ÔÈ»ÊǼܽ¨Web·þÎñÆ÷µÄÊ×Ñ¡£¬ºÃÁË£¬ÏÂÃæÎÒÃǾÍÀ´°²×°Apache¡£ÔÚÖÕ¶ËÏÂÊäÈëÏÂÔÚÃæÃüÁ
sudo apt-get install apache2
°²×°Íê±Ïºó£¬½ÓÏÂÀ´¾ÍÒªÆô¶¯ApacheÁË
sudo /etc/init.d/apache2 restart
ÔÚä¯ÀÀÆ÷ÀïÊäÈëhttp://localhost»òÕßÊÇhttp://127.0.0.1£¬Èç¹û¿´µ½ÁË“It works!“£¬ÄǾÍ˵Ã÷Apache¾Í³É¹¦µÄ°²×°ÁË£¬ApacheµÄĬÈÏ°²×°£¬»áÔÚ/varϽ¨Á¢Ò»¸öÃûΪwwwµÄĿ¼£¬Õâ¸ö¾ÍÊÇWebĿ¼ÁË£¬ËùÓÐÒªÄܹýä¯ÀÀÆ÷·ÃÎʵÄWebÎļþ¶¼Òª·Åµ½Õâ¸öĿ¼Àï¡£
¶þ¡¢PHPµÄ°²×°
ÔÚUbuntuÏ°²×°Èí¼þÊÇÒ»¼þ·Ç³£¼òµ¥µÄÊ£¬Ö»ÐèÒªÒ»¸öÃüÁî¾Í¿ÉÒÔÁË£¬ÔÚÖÕ¶ËÏÂÖ´ÐÐÏÂÃæµÄÃüÁ
sudo apt-get install libapache2-mod-php5 php5
°²×°Íêºó£¬ÎÒÃÇÒªÖØÐÂÆô¶¯Apache£¬ÈÃËü¼ÓÔØPHPÄ£¿é£º
sudo /etc/init.d/apache2 restart
½ÓÏÂÀ´£¬ÎÒÃǾÍÔÚWebĿ¼ÏÂÃæн¨Ò»¸öPHPÎļþÀ´²âÊÔPHPÊÇ·ñÄÜÕý³£µÄÔËÐУ¬ÃüÁ
sudo gedit /var/www/phpinfo.php
È»ºóÊäÈë: <?php echo "test"; ?>
½Ó×ű£´æÎļþ,ÔÚä¯ÀÀÆ÷ÀïÊäÈë http://127.0.0.1/phpinfo.php £¬Èç¹û³öÏÖÁËÒ»¸öÏÔʾtestµÄÒ³Ã棬ÄǾÍ˵Ã÷ PHPÒѾÕý³£ÔËÐÐÁË¡£µ«ÊÇÈç¹ûûÓÐÏÔʾ³öÒ³Ã棬¶øÊÇÌáʾÄãÏÂÔØÎļþ£¬Õâ¾Í˵Ã÷ApacehûÓÐÕýÈ·¼ÓÔØPHPÄ£¿é£¬Õâʱ½â¾öµÄ·½·¨ÊÇ£¬ÔÚ/etc /apache2/apache2.conf »ò /etc/apache2/mods-enabled/php5.confÎļþÀï¼ÓÈëÏÂÃæµÄÒ»ÐÐÃüÁ
AddType application/x-httpd-php .php .phtml .php3
ÔÚ¼ÓÈëÉÏÃæµÄÃüÁîºó£¬ÔÙͨ¹ýÏÂÃæµÄÃüÁîÓ¦ÖØÆôApaceh¸Ã¾ÍÄܽâ¾öÎÊÌâÁË:
sudo /etc/init.d/apache2 stop
sudo /etc/init.d/apache2 restart
Èý¡¢MySQLµÄ°²×°
sudo apt-get install mysql-server my
Ïà¹ØÎĵµ£º
PerlÖÐDBI¡¢DBD::mysqlÄ£¿éµÄ°²×°
ʹÓõÄÈí¼þ°æ±¾
DBI-1.604.tar.gz
DBD-mysql-4.006.tar.gz
½¨ÒéʹÓÃÒÔÉÏ°æ±¾´îÅ䣬·ñÔò¿ÉÄÜÁ¬½Ómysql´íÎó
Ò»¡¢DBIµÄ°²×°
wget http://www.cpan.org/modules/by-module/DBD/DBI-1.604.tar.gz
tar -zxvf DBI-1.604.tar.gz
cd DBI-1.604
perl Makefile.PL ......
Ò»ÏîÄ¿¿ª·¢
ÐèÇó·ÖÎö¡¢ÏµÍ³·ÖÎö¡¢ÏµÍ³Éè¼Æ¡¢³ÌÐò¿ª·¢¡¢¼¯³ÉºÍ²âÊÔ
¶þ¡¢ÏîÄ¿·Ö¹¤
³ÌÐòÉè¼Æ¡¢¹²ÓÃ×é¼þÉè¼Æ¡¢Êý¾Ý¿â¡¢ÃÀ¹¤¡¢Îļþ±àд¡¢Êý¾ÝÊäÈë¡¢°²×°Î¬»¤¿Í·þ
Èý¡¢MySQL
Ëٶȿ죬֧³Ö¶àÏß³ÌÓë¶àÓû§Í¬Ê±ÔÚÏߵĹØϵÊý¾Ý¿â¹ÜÀíϵͳ
»ù±¾µÄMySQLÃüÁîµÄ¼ÇÒä
ËÄ¡¢HTML
»ù±¾htmlµÄÓï¾ä ......
ʹÓÃhibernate mysql ²åÈëÖÐÎÄ´íÎó£º
ÔÒòÖ®Ò»ÊÇ£º
mysql µÄ×Ö·û±àÂëºÍhibernate´«µÝµÄ±àÂë²»Ò»Ñù£¬
ÀýÈ磺
mysql ½¨¿âµÄʱºò¿ÉÒÔÉèÖñàÂë:
CREATE DATABASE db DEFAULT CHARACTER SET utf8;
hibernate Á¬½ÓmysqlµÄ±àÂ룺
jdbc:mysql://127.0.0.1:3306/db?useU ......
##/etc/my.cnf:
# [mysql]
# default-character-set=utf8
# [mysqld]
# character-set-server=utf8
# collation-server=utf8_general_ci
# [client]
# default-character-set=utf8
/etc/init.d/mysqld stop
/etc/init.d/mysqld start
# dump db
mysqldump -u dbuser -pdbpass --opt --skip-set-charset --defaul ......
ÔÚMySQL 3.23.44°æ±¾ºó£¬InnoDBÒýÇæÀàÐ͵ıíÖ§³ÖÁËÍâ¼üÔ¼Êø¡£
Íâ¼üµÄʹÓÃÌõ¼þ£º
1.Á½¸ö±í±ØÐëÊÇ
InnoDB±í£¬MyISAM±íÔÝʱ²»Ö§³ÖÍâ¼ü£¨¾Ý˵ÒÔºóµÄ°æ±¾ÓпÉÄÜÖ§³Ö£¬µ«ÖÁÉÙÄ¿Ç°²»Ö§³Ö£©£»
2.Íâ¼üÁбØÐ뽨Á¢ÁËË÷Òý£¬MySQL
4.1.2ÒÔºóµÄ°æ±¾ÔÚ½¨Á¢Íâ¼üʱ»á×Ô¶¯´´½¨Ë÷Òý£¬µ«Èç¹ûÔÚ½ÏÔçµÄ°æ±¾ÔòÐèÒªÏÔʾ½¨Á¢£»
3.Íâ¼ü¹Øϵµ ......