Linux + Apache2.0 + Mysql + PHP + phpBB3.0
Linux + Apache2.0 + Mysql + PHP + phpBB3.0
1.°²°ü£º
Apache2.0
#tar -zxf httpd-***.tar.gz -C /usr/local/src/
#cd /usr/local/src/httpd-***
#./configure --prefix=/usr/local/apache2 --enable-so --enable-rewrite
#make
#make install
Mysql
#groupadd -g 200 mysql
#useradd -u 200 -g mysql -d /usr/local/mysql/data -M mysql
#tar -zxf mysql-***.tar.gz -C /usr/local/
#cd /usr/local
#ln -s mysql-***/ mysql
#mkdir /var/lib/mysql
#chown -R mysql:mysql /var/lib/mysql
#chown -R root:mysql /usr/local/mysql-***
#chown -R mysql:mysql /usr/local/mysql/data
#cd /usr/local/mysql
#cp support-files/my-medium.cnf /etc/my.cnf
#./scripts/mysql_install_db
#chown -R mysql:mysql /var/lib/mysql
#chown -R mysql:mysql /usr/local/mysql/data
#/usr/local/mysql/bin/safe_mysqld --user=mysql &
#/usr/local/mysql/bin/mysqladmin -u root password 'myrootpw'
#/usr/local/mysql/bin/mysql -u root -p
Enter password: myrootpw
&nb
Ïà¹ØÎĵµ£º
1¡¢°²×°Ä¿Â¼:
½«my.iniÖÐ:
datadirµÄÖµ¸ü¸ÄΪ£º"sql/data/"
basedirµÄÖµ¸ü¸ÄΪ£º"sql"
2¡¢½øÈësql/data/"£¬É¾³ýÎļþ¼ÐÍâµÄËùÓÐÎļþ¡£
net start mysql»Ø³µ……
×¢ÒâбÏß/
ÐÞ¸Äpswd
·½·¨1£ºmysqladmin -u root -p "old password" "new password" (´ËÃüÁîÎÞ·¨°ÑÃØÃÜÇå¿Õ)
·½·¨2£º ......
È¡µÃÎÄÕ¹ؼü×ÖΪkeywords
±ínewsµÄ¹Ø¼ü×Ö×Ö¶ÎΪkeyword
keywords=keywords.replace(',','|');
String sql="SELECT * from news WHERE keyword REGEXP '"+keywords+"' ORDER BY id ";
ÓÉÓÚijЩÔÒò£¬ÓÐʱºòÎÒÃÇûÓа´ÕÕ·¶Ê½µÄÉè¼Æ×¼Ôò¶ø°ÑһЩÊôÐԷŵ½Í¬Ò»¸ö×Ö·û´®×Ö¶ÎÖС£±ÈÈç¸öÈËÐËȤ£¬ÓÐʱºòÎÒÃÇÉè¼Æ±íΪ
cr ......
±¾ÎÄÁгöÁ˴󲿷ֳ£¼ûµÄLinuxϵͳµ÷Ó㬲¢¸½ÓмòÒªÖÐÎÄ˵Ã÷¡£ ÒÔÏÂÊÇLinuxϵͳµ÷ÓõÄÒ»¸öÁÐ±í£¬°üº¬Á˴󲿷ֳ£ÓÃϵͳµ÷ÓúÍÓÉϵͳµ÷ÓÃÅÉÉú³öµÄµÄº¯Êý¡£Õâ¿ÉÄÜÊÇÄãÔÚ»¥ÁªÍøÉÏËùÄÜ¿´µ½µÄΨһһƪÖÐÎÄ×¢Ê͵ÄLinuxϵͳµ÷ÓÃÁÐ±í£¬¼´Ê¹ÊǼòµ¥µÄ×ÖĸÐòÓ¢ÎÄÁÐ±í£¬ÄÜ×öµ½ÕâôÍêȫҲÊǺܺ±¼ûµÄ¡£ °´ÕÕ¹ßÀý£¬Õâ¸öÁбíÒÔman pagesµÚ2½ ......