ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£
win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£
µ±È»Äã×îºÃÑ¡Ôñ½Ïеİ汾
Èç¹ûÄã×Ô¼ºÔÚ×Ô¼ºµÄWindows 7ϵͳϱàÒ룬¼æÈÝÐÔÎÊÌâÓ¦¸ÃûÎÊÌâ¡£
Èç¹ûÄãÓÃWin ......
mySql5.1µÄ mysql command line clientÃüÁî´°¿Úÿ´ÎÒ»µãËü,Ëü¾ÍÒ»ÉÁ¶ø¹ý,²»»áÏÔʾÁË.ÕâÊÇʲôÎÊÌâ?
ÔÚÄãµÄWINDOWSÉÏ£¬ÏȰ´ [¿ªÊ¼], È»ºó [ÔËÐÐ] ,ÊäÈë cmd È»ºó»Ø³µ
È»ºóÔÙÔÚÕâ¸öDOS´°ÌåÖУ¬ cd C:\Program Files\MySQL\MySQL Server 5.1\bin (»Ø³µ) ×¢Òâºì×־Ͳ»Òª´ò³Éºº×ÖÁË£¬ÊÇÈÃÄã°´»Ø³µ¼ü£¬Èç¹û²»ÖªµÀ»Ø ......
Á¬½ÓÊý¾Ý¿âʱÔõô³öÏÖÕâÑùµÄ´íÎó£º[localhost] ERROR 1045: Access denied for user 'root'@'localhost' (using password: YES)
ÔΣ¬Óï¾äÌùÀ´¿´¿´
ÄãÃÜÂëÄØ
ÃÜÂë´íÁ˰ɡ£
¸Õѧmysql,ÕÕ×ÅÊéÉÏѧµÄ£¬ÊéÉÏÓõÄMySQL Control Center,¸Õ°²×°µÄʱºò£¬»¹¿ÉÒÔÁ¬½Ó£¬½ñÌìµã»÷localhostϵÄconnect¾Í³öÏÖÁË ......
ÏÖÔÚÎÒÓöµ½Ò»¸ö¹ØÓÚmysqlÊý¾Ý±¸·ÝµÄÎÊÌ⣬ÈçÏÂ
1.¸ù¾ÝһЩÌõ¼þÑ¡ÔñÐèÒª±¸·ÝµÄij¸ö±íÖеÄijЩÊý¾Ý£¬¿ÉÄÜÊÇÒ»ÕÅ±í£¬Ò²¿ÉÄÜÊǶàÕÅ±í¹ØÁª¡£¡£¿ÉÄÜÊDZíÖÐËùÓÐÊý¾Ý£¬Ò²¿ÉÄÜÊÇ·ûºÏÌõ¼þµÄÒ»²¿·ÖÊý¾Ý¡£
2.Òª¶ÔÕâЩÊý¾Ý½øÐл¹Ô£¬¿ÉÄÜÊDZ¾»úÊý¾Ý¿â£¬Ò²¿ÉÄÜÊÇÆäËû·þÎñÆ÷Êý¾Ý¿â¡£µ«ÊÇÔÚÆäËû·þÎñÆ÷ÉÏ» ......
ÎÒ½¨ÁËÁ½¸ö±í£¬Ò»¸ö±íÃ÷user£¬Ò»¸ö±íanswer
±íuserµÄ½á¹¹{id,username,password}
±íanswerµÄ½á¹¹{A_id,question,answer,U_id}
Çë½Ì´ó¼ÒÎÒÔõôÉèÖòÅÄÜÔÚ±íuser²åÈëÊý¾Ýʱ£¬±íanswer¶ÔÓ¦µÄU_id×Ô¶¯¸üжÔÓ¦±íuserµÄid ¡£
ÄÇλ´óÏÀ£¬¸øÐ´Ï´úÂë¿ÉÒÔÂ𣿣¿£¿
Èç¹ûÓÃPHPºÜÈÝÒ×½â¾ö£¬
Èç¹ûÓÃMYSQL¿ÉÒÔÓô¥·¢Æ÷½â ......
ÎÒÏëÔÚmysqlÖн«t_flow_card_detail±íÖеÄclient_id×ֶθÄΪÍâ¼ü£¬ÒýÓÃt_client±íÖеÄclient_id×ֶΣº
ÎÒµÄsqlÓï¾äÊÇ£º alter table t_flow_card_detail add constraint FK_flowcard_client foreign key (client_id) references t_client(client_id);
¿É×ÜÊDZ¨´í£ºERROR 1005 (HY000): Can' ......