¼òµ¥ÅäÖÃapache + mysql + discuz +php
°²×°apache + mysql + discuz +php
apache http://www.apache.org/
mysql http://dev.mysql.com/downloads/
MySQL GUI Tools http://dev.mysql.com/downloads/gui-tools/5.0.html
php http://www.php.net/
discuz http://www.comsenz.com/index.php
1.°²×°apache,ÐÞ¸Äconf\httpd.conf
LoadModule php5_module "D:/Work/php/php5apache2_2.dll" //PHPµÄphp5apache2_2.dll·¾¶
PHPiniDir "D:/Work/php" //PHP·¾¶
DirectoryIndex index.
php
index.html
2.°²×°PHP,ÐÞ¸Äphp.ini-distΪphp.ini
ÆôÓÃ extension=php_mysql.dll
extension_dir = “./” ¸ÄΪ extension_dir = “X:/php
/ext/
” //extµÄÎļþλÖÃ
3.°²×°MySQL
Ŀ¼ÖÐн¨Ò»¸ömy.iniÎļþ(²Î¿¼Ä¿Â¼ÖеÄÅäÖÃ)
4.°²×°MySQL GUI Tools
ÅäÖÃMySQLµÄ·þÎñ
6.°ÑDiscuz°²×°µ½apache\htdocsµÄÍøÒ³Ä¿Â¼ÖÐ
7.ä¯ÀÀÆ÷ÖÐÖ±½Ó°²×°Discuz localhost/dz/install.php
Ïà¹ØÎĵµ£º
mysqldump -u[user] -p[password] [databasename] > [dump_name]
ÔÚ½« dump_name Õâ¸öµµ°¸¸´ÖƵ½Áíһ̨¼ÆËã»úÉÏ
Áíһ̨¼ÆËã»úÉÏÏȽøÈëmysql
½¨Á¢Ò»¸ö database ÔÙÖ´ÐÐÏÂÁÐÖ¸Áî
mysql -u[user] -p[password] [database_name] < [dump_name]
MYSQL¼¸ÖÖ±¸·Ý·½·¨¸ÅÊö
MysqlÊý¾Ý
¿â±¸·ÝÖ÷ÒªÓÐ4Ö ......
ÔÚ½²MySQLµÄJoinÓ﷨ǰ»¹ÊÇÏȻعËÒ»ÏÂÁª½áµÄÓï·¨£¬ºÇºÇ£¬ÆäʵÁ¬ÎÒ×Ô¼º¶¼ÍüµÃ²î²»¶àÁË£¬ÄǾʹó¼ÒÒ»ÆðÎÂϰ°É£¨Èç¹ûÄÚÈÝÓдíÎó»òÓÐÒÉÎÊ£¬¹úÄÚ¹ØÓÚMySQLÁª½á²éѯµÄ×ÊÁÏÊ®·ÖÉÙ£¬ÏàÐÅ´ó¼ÒÔÚ¿´Á˱¾Îĺó»á¶ÔMySQLÁª½áÓï·¨ÓÐÏ൱ÇåÎúµÄÁ˽⣬Ҳ²»»á±»OracleµÄÍâÁª½áµÄ£¨“£«”ºÅ£©ÅªµÃºýÍ¿ÁË¡£
ÔÚSQL±ê×¼Öй滮µÄ£¨ ......
QT DataBase SQL Explorer
1¡¢°²×°MySQLµ½¹Ù·½ÍøÕ¾ÏÂÔØMySQLÊý¾Ý¿â£¬·Ç°²×°°æ£¬Ö±½ÓÔËÐÐmysqld½ø³Ìǰ̨µÄ
2¡¢Ìí¼Óϵͳ»·¾³±äÁ¿£¬Path+=':\mysql\bin'µÄpath£¬ÔÙÔÚ¿ªÊ¼ÔËÐУ¬CMD->mysql -uroot µÇ¼µ½mySQLÊý¾Ý¿â
Default passwordûÓеģ¬Óеϰ mysql -uroot -pÊäÈëÃÜÂë£»ÍøÂçµÇ¼£ºmysql -h ip ......
1¡¢²é¿´µ±Ç°ËùÓÐÁ¬½ÓµÄÏêϸ×ÊÁÏ:
mysqladmin -uroot -proot processlist
D:\MySQL\bin>mysqladmin -uroot -proot processlist
+-----+------+----------------+---------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+------+---------- ......
#!/usr/bin/env python
# -*-coding:UTF-8-*-#ÕâÒ»¾ä¸æËßpythonÓÃUTF-8±àÂë
#=========================================================================
#
# NAME: Python MySQL test
#
# AUTHOR: benyur
# DATE : 2004-12-28
#
# COMMENT: ÕâÊÇÒ»¸öpythonÁ¬½ÓmysqlµÄÀý×Ó
#
#================ ......