ÈçºÎÔÚwindows µÄmysql°ÑÊý¾Ý¿â·Åµ½dÅÌ
windows ϰ²×°Ò»¸ömysql £¬×°ÔÚcÅÌ ÏÖÔÚcÅ̿ռä»ù±¾¿ìûÓÐÁË £¨ºÜ¶àÈí¼þĬÈÏÊÇ×°ÔÚcÅÌ£© ÏëÖªµÀÈçºÎÔÚwindows µÄmysql ϰÑÊý¾Ý¿â·Åµ½dÅÌ £¨linux»áµÄ £¬²»ÖªµÀwinodwsÈçºÎ×÷£©
Ö±½Ó¸´ÖƹýÈ¥¡£È»ºó¸ÄÒ»ÏÂÄãµÄ my.ini ÎļþÖеÄÏà¹ØÂ·¾¶£¬±ÈÈçdatadir, basedir µÈ£¬ÄãÔÚÎļþÖÐËÑË÷һϠC: £¬Ïà¹ØµÄ»»µô¡£ È»ºóµ½×¢²á±íÖÐÈ¥ÐÞ¸ÄһϠmysql µÄ·þÎñÏîÖÐµÄ Ö´ÐÐÎļþ·¾¶¡£ µ±È»Èç¹ûÄãÊÇÖ±½ÓÊÖ¹¤Æô¶¯µÄÕâ¸öÔò²»ÐèÒª¡£ linux»áµÄ»° window¸üûÎÊÌâÁË Í¬ÑùÖ¸¶¨Â·¾¶ºÍĿ¼¾Í¿ÉÒÔÁË Ò»¶¨ÒªÕÒµ½datadir Ëü´æ´¢Êý¾Ý¿âÊý¾Ý °ÑÊý¾Ý¿â·Åµ½dÅÌ ÐÞ¸Ämy.ini ºÍ ×¢²á±í ÖØÆôÊý¾Ý¿â ½á¹û·¢ÏÖ Òì³£ÖÕÖ¹£¿£¿£¿£¿ ERROR woo3(HY000) can 't to mysql server on 'loclahost ' (10061) ¿ØÖÆÃæ°å Æô¶¯ mysql·¢ÏÖ ÔÚ±¾µØ¼ÆËã»úÎÞ·¨Æô¶¯ mysql·þÎñ ´íÎó 1067 ½ø³ÌÒâÍâÖÕÖ¹ Í£Ö¹·þÎñ£¬°ÑÊý¾ÝÎļþ¿½±´¹ýÈ¥ºó£¬È»ºóÐÞ¸Ämy.iniÕâÑùÅäÖÃÎļþϵÄdatadir¡£ ÐèÌØ±ð×¢ÒâµÄ£¬Èç¹ûÄãÁ¬my.iniÔÚÄÚµÄÕû¸öĿ¼¶¼¿½±´¹ýÈ¥Á˵ϰ£¬ÒòΪmy.iniÅäÖÃÎļþµÄ·¾¶¸ü¸ÄÁË£¬ËùÒÔ£¬µÃ°Ñmysql·þÎñÀïÃæµÄ--defaults-file¸ü¸ÄÁ˲ÅÄÜÕý³£Æô¶¯·þÎñ¡£ÒýÓà ¿ØÖÆÃæ°å Æô¶¯ mysql·¢ÏÖ ÔÚ±¾µØ¼ÆËã»úÎÞ·¨Æô¶¯ mysql·þÎñ ´íÎó 1067 ½ø³ÌÒâÍâÖÕÖ¹ Õâ¸ö¹À¼Æ¿ÉÄÜÊÇÄãµÄmy.iniÀïÃæµÄdatadirÖ®ÀàµÄ²ÎÊýûÐ޸Ķԣ»Ò²ÓпÉÄÜÄãÁ¬my.iniÅäÖÃÎļþÒ²Ò»ÆðÇ¨ÒÆÁË£¬¶ømysqlµÄ·þÎñÖ
Ïà¹ØÎÊ´ð£º
Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓᣠÊý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......
ÎÒÊÇÓÃmysql×Ô´øµÄC API if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0)) { AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
´ó¼ÒºÃ£¬ÎÒÔÚ´´½¨Ë÷Òýʱ£¬³öÏÖ´íÎóÌáʾ£¬´úÂëÈçÏ£º create uique index stu_cou_index on student_info.results (student_id, course_id); show index from student_info.results; ±£´æÎªindex.s ......
SQL code: UPDATE `footballmatch`.`promote` SET `pr_ballhype` = http://ballhype.com/post/url/?url=http%3A//www.allfootballtv.com/%3Fp%3D369&league=8 WHERE `promote`.`fm_post_id` =369 ÒÔÉ ......
Ö÷ÒªÇé¿öÈçÏ£º ÏÖÓÐÒ»Îı¾Êý¾ÝÎļþ£¬ÀïÃæµÄÊý¾ÝÈçÏ£º abc 123 def 223 2 wwww uuu 456 5 xxx ¡¡ Êý¾ÝÓм¸wÌõ Ò»ÐÐ×î¶à4ÁÐ µ« ......