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

mySqlÓëWampServerͬʱ°²×°Ê±³öÏÖµÄÎÊÌâ


 
½ñÌìÅöµ½ÕâÑùµÄÒ»¸öÎÊÌ⣺
ÎÒµçÄÔÉϰ²×°ÁËwampserver£¬È»ºó´ò¿ªphpMyAdmin½øÐÐÊý¾Ý¿â¹ÜÀí²Ù×÷ʱ£¨´´½¨Êý¾Ý¿â£©£¬´´½¨ÍêÖ®ºó£¬µ½wampserver°²×°Ä¿Â¼µÄmysqlĿ¼Ï²鿴¸Õ´´½¨µÄÊý¾Ý¿â¡£¡£¡£ÔõôÕÒҲûÕÒµ½£¬ÎÒ¾ÍÓôÃÆ£¬È»ºó¾ÍÈ¥²éÕÒÎÊÌâµÄÔ­Òò£¬½á¹ûÊÇÕ⣺ÒòΪÎÒµçÄÔÉϰ²×°WampServer֮ǰÓа²×°¹ýMysql£¬ËùÒÔÖ®ºó¶ÔÊý¾Ý¿â²Ù×÷ʱ¶¼ÊÇÔÚÔ­MysqlĿ¼Ï½øÐеġ£


Ïà¹ØÎĵµ£º

MySQL´æ´¢ÒýÇæ±È½Ï

MySQL³£ÓõĴ洢ÒýÇæÎªMyISAM¡¢InnoDB¡¢MEMORY¡¢MERGE£¬ÆäÖÐInnoDBÌṩÊÂÎñ°²È«±í£¬ÆäËû´æ´¢ÒýÇæ¶¼ÊÇ·ÇÊÂÎñ°²È«±í¡£ 
MyISAMÊÇMySQLµÄĬÈÏ´æ´¢ÒýÇæ¡£MyISAM²»Ö§³ÖÊÂÎñ¡¢Ò²²»Ö§³ÖÍâ¼ü£¬µ«Æä·ÃÎÊËٶȿ죬¶ÔÊÂÎñÍêÕûÐÔûÓÐÒªÇó¡£ 
InnoDB´æ´¢ÒýÇæÌṩÁ˾ßÓÐÌá½»¡¢»Ø¹öºÍ±ÀÀ£»Ö¸´ÄÜÁ¦µÄÊÂÎñ°²È«¡£µ«ÊÇ±ÈÆðMyISAM´æ´ ......

MysqlÂÒÂëÖÕ¼«½â¾ö·½°¸

     MysqlÂÒÂë²úÉúµÄÔ­Òò£º
    ²úÉú´ËÀàÎÊÌâµÄ×î¿ÉÄÜÊÇÄãµÄÊý¾Ý¿âÔÚ°²×°Ê±Ã»ÓÐÑ¡¶Ô×Ö·û¼¯£¬Õâ¸öÊ®·ÖÖØÒª.
    Äã¿ÉÒÔͨ¹ýÈçϵķ½Ê½À´²é¿´£º´ò¿ªMysql´°¿Ú£¬ÔÚ´°¿ÚµÄ×î×óÉϽǵã»÷Êó±êÓÒ¼ü£¬Ñ¡ÔñÊôÐÔ£¬¾Í¿ÉÒÔ¿´µ½ÄãĬÈϵÄ×Ö·û±àÂëÁË£¨ÈçÏÂͼ£©£º
    ......

C# Á¬½ÓMySqlµÄ·½·¨


1.´Óhttp://prdownloads.sourceforge.net/mysqldrivercs/MySQLDriverCS-n-EasyQueryTools-3.0.18.exe?downloadÉÏÏÂÔØMySQLDriverCS. 
2.°ÑMySQLDriverCS.dll.Ìí¼Óµ½.netµÄ×é¼þ 
3.ʹÓ÷½·¨ 
 ÏÂÃæÊÇ´´½¨Ò»¸öÊý¾Ý¿âÁ´½Ó:
ÏÂÃæÊÇ´´½¨Ò»¸öÊý¾Ý¿âÁ´½Ó:
using MySQLDriverCS;
MySQLConnection conn ......

MysqlÖд´½¨Óû§ÕÊ»§µÄ·½·¨

1.CREATE USER
CREATE USER user [IDENTIFIED BY [PASSWORD] 'password']
    [, user [IDENTIFIED BY [PASSWORD] 'password']] ...
CREATE USERÓÃÓÚ´´½¨ÐµÄMySQLÕË»§¡£ÒªÊ¹ÓÃCREATE USER£¬Äú±ØÐëÓµÓÐmysqlÊý¾Ý¿âµÄÈ«¾ÖCREATE USERȨÏÞ£¬»òÓµÓÐINSERTȨÏÞ¡£¶ÔÓÚÿ¸öÕË»§£¬CREATE USER»áÔÚûÓÐȨÏÞµÄmysq ......

VCµ¥ÎļþÁ¬½ÓMYSQLʾÀý£¬¶ªµôlibmysql.dll.

ÍøÉϺܶàVCÁ¬½ÓmysqlµÄÀý×Ó¶¼ÊÇÒª´ø¸ölibmysql.dll²ÅÄÜÕý³£Ê¹Óõġ£
µ«ÓÐʱÎÒÃDz¢²»Ïë¶à´ø¸ölibmysql.dll£¬Ö»Ïëµ¥Îļþ¾ÍÄÜʹÓûòÕßÄãÊÇÒª
·â×°ÔÚÒ»¸ödllÎļþÀÕâʱÄãÒª¾ÍÓõ½mysqlclient.libÕâ¸ö¾²Ì¬¿âÁË¡£
ʾÀý´úÂëÈçÏ£¬ºÜºÜ¼òµ¥£¬¾Í²»¶à˵ÁË¡£
Ïà¹ØµÄmysqlÍ·Îļþ¼°¾²Ì¬¿â£º
http://download.csdn.net/source/1047 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ