mysql°²×°ÎÊÌâ
mysqlÖØÐ°²×°ÎÞ·¨°²×°Íê³É
°´ÕÕÍøÉϵĽéÉÜɾÁËwindowsϵÄmy.iniºÍ×¢²á±íÖеÄÏà¹ØÐÅÏ¢£¬µ«ÊÇ»¹ÊÇÔÚ×îºó°²×°µÄʱºò±»´ò¶Ï
ÓÐÄÄλ´óϺָ½ÌÒ»ÏÂ
лл
1. ÄãµÄ winodws °æ±¾¡£
2. ÄãÊÇÈçºÎ°²×°µÄ£¬°²×°µ½ÄÄÒ»²½³ö´í£¿´íÎóÌáʾÊÇʲô£¿
×î¼òµ¥µÄ·½·¨£¬Ö±½Óϸö ZIP°æÈ»ºóÖ±½ÓUNZIP¾Í¿ÉÒÔÓÃÁË¡£
¿´É¾³ýÁËÒÅÁôµÄÊý¾ÝÎļþûÓС£
Windows°æ±¾ÊÇ2003°æµÄ£¬°²×°µ½¸´ÖÆÐÂÎļþµÄʱºò¾ÍÌáʾ±»´ò¶ÏÁË
ÎÒ°´ÕÕÍøÉϵķ½·¨É¾ÁËwindowsÎļþ¼ÐÀïµÄÎļþ£¬ÓÖɾÁË×¢²á±í£¬µ«ÊÇ»¹ÊÇÎÞ·¨Íê³É
лл¸÷λÁË£¬½â¾öÁË£¬×°Á˸öа汾µÄ
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£
mysqlÃüÁîÐÐģʽÏÂ: ......
ÎÒ¿ª·¢ASP.netʱ
²åÈëÍâÎÄÂÒÂë
SHOW VARIABLES LIKE 'character%';
Õâ¸öʱºò
character_set_client utf8
character_set_connection utf8
character_set_database utf8
ch ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......