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

¼òµ¥ÅäÖÃ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


Ïà¹ØÎĵµ£º

ÈçºÎ±¸·ÝMysqlÊý¾Ý¿â

 
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ÁªºÏ²éѯ

 ÔÚ½²MySQLµÄJoinÓ﷨ǰ»¹ÊÇÏȻعËÒ»ÏÂÁª½áµÄÓï·¨£¬ºÇºÇ£¬ÆäʵÁ¬ÎÒ×Ô¼º¶¼ÍüµÃ²î²»¶àÁË£¬ÄǾʹó¼ÒÒ»ÆðÎÂϰ°É£¨Èç¹ûÄÚÈÝÓдíÎó»òÓÐÒÉÎÊ£¬¹úÄÚ¹ØÓÚMySQLÁª½á²éѯµÄ×ÊÁÏÊ®·ÖÉÙ£¬ÏàÐÅ´ó¼ÒÔÚ¿´Á˱¾Îĺó»á¶ÔMySQLÁª½áÓï·¨ÓÐÏ൱ÇåÎúµÄÁ˽⣬Ҳ²»»á±»OracleµÄÍâÁª½áµÄ£¨“£«”ºÅ£©ÅªµÃºýÍ¿ÁË¡£
ÔÚSQL±ê×¼Öй滮µÄ£¨ ......

SQL Explorer QT4.5 ÅäÖÃMySQL ODBCºÍMySQLÇý¶¯

 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 ......

²é¿´mysqlµ±Ç°Á¬½ÓÊý

 1¡¢²é¿´µ±Ç°ËùÓÐÁ¬½ÓµÄÏêϸ×ÊÁÏ:
mysqladmin -uroot -proot processlist
D:\MySQL\bin>mysqladmin -uroot -proot processlist
+-----+------+----------------+---------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+------+---------- ......

pythonÈçºÎÁ¬½ÓMySQLÊý¾Ý¿â

 
#!/usr/bin/env python
# -*-coding:UTF-8-*-#ÕâÒ»¾ä¸æËßpythonÓÃUTF-8±àÂë
#=========================================================================
#
# NAME: Python MySQL test
#
# AUTHOR: benyur
# DATE  : 2004-12-28
#
# COMMENT: ÕâÊÇÒ»¸öpythonÁ¬½ÓmysqlµÄÀý×Ó
#
#================ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ