ÈçºÎÔÚ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µÄ·þÎñÖ
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ£¬ÎÒÔÚ´´½¨Ë÷Òýʱ£¬³öÏÖ´íÎóÌáʾ£¬´úÂëÈçÏ£º create uique index stu_cou_index on student_info.results (student_id, course_id); show index from student_info.results; ±£´æÎªindex.s ......
ÎÒÔÚ×¢²áÒ³ÃæÐ´ÈëÁËÈçÏ´úÂ룺 <?php $conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error()); & ......
ÈÕIPÊýǧ ÒÔºó»áÉÏÍò Ò²ÊÇflex+javaÓÎÏ·ÀàÐ͵ÄÍøÕ¾ ¼¯ÖÐÔڸ߷åÆÚÍíÉÏ ÇëÎÊÊý¾Ý¿â·þÎñÆ÷µÄ»úÆ÷ÓÃÊ²Ã´Æ·ÅÆºÃ£¿ÍƼöÒ»¸öÅäÖã¿ ÏÖÔÚÊý¾Ý¿âÊÇʹÓÃmysql5.0 ÊDz»ÊÇÊʺϣ¿ ¸Ã²»¸Ã»»³ÉOralce(ÏÖÔÚ»»»¹ ......
ѯÎÊ mysqlµÄÊý¾Ý¿â ¿âÃû³ÆÈçºÎ¸ü¸Ä £¨±íÃûÊǺܼòµ¥µÄ£© ³¢ÊÔһϱäͨµÄ·½·¨£º ´´½¨Ò»¸öеÄÊý¾Ý¿âÃû³Æ ±¸·ÝÒªÐ޸ĵÄÊý¾Ý¿â£¬°Ñ±¸·ÝµÄÊý¾Ý»¹Ôµ½Ð½¨µÄÊý¾Ý¿âÖÐ ²»¹ýÕâ¸öʵʱÐÔ²»ºÃ£¬½¨ÒéÔÚÊý¾ ......
±í½á¹¹ mysqlÊý¾Ý ÍøÒ³ÏÔʾµÄÊý¾Ý ÏÖÔÚÎÊÌâ¾ÍÊÇ£¬³ýÁËÖ÷¼üÓÐÖµÍ⣬ÆäËü×Ö¶ÎÈ«²¿Îª¿Õ¡£ ÕâÀïºÍÈÕÎÄÓйØÏµ£¬Ï£ÍûÓÐÄÜÓÐÄãµÄ°ïÖú¡£Ð»Ð» ÓÐʱºòһˢеÄʱºò£¬»¹³öÏÖÕâÖÖÎ ......