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

mysql°²×°Í¼½â½Ì³Ì 5.1(ת)

mysql°²×°Í¼½â½Ì³Ì 5.1
2009Äê03ÔÂ01ÈÕ ÐÇÆÚÈÕ 23:51
תÔØÇë×¢Ã÷³ö´¦:http://hi.baidu.com/herdff/blog/item/6e6b4bcf6132f90b93457e14.html
±¾½Ì³ÌÒÔMysql 5.1°æ±¾ÎªÀý£¬¸ü¸ß°æ±¾°²×°¹ý³ÌÓë´ËÀàËÆ¡£ÔĶÁÇ°£¬ÇëÏÂÔØ5.1£¬ÏÂÔصØÖ·£ºwww.mysql.com
°²×°¹ý³ÌÓëÆäËüWindows°²×°³ÌÐòÒ»Ñù£¬Ê×ÏȳöÏÖµÄÊÇ°²×°Ïòµ¼»¶Ó­½çÃæ
Ö±½Óµã»÷“Next”£¬¼ÌÐø£¬Ñ¡Ôñ°²×°ÀàÐÍ
ÕâÀïÓÐ3¸öÀàÐÍ£ºTypical£¨µäÐÍ£©¡¢Complete£¨ÍêÈ«£©¡¢Custom£¨×Ô¶¨Ò壩¡£Ñ¡Ôñ“×Ô¶¨Ò唣¨Custom£©°²×°£¬È»ºóµã“Next”ÏÂÒ»²½£¬³öÏÖ×Ô¶¨Òå°²×°½çÃæ
ÎÒÃÇÕâÀï¾Í°´ÕÕĬÈϵÄÕâ¸ö·¾¶¡£µã»÷“NEXT” ×¼±¸¿ªÊ¼°²×°
µã“Install”¿ªÊ¼°²×°
°²×°Íêºó³öÏÖ ½â˵»­Ã棬һֱÏÂÒ»²½
×¢Ò⣬ÕâÀïÓиöÅäÖÃÏòµ¼µÄÑ¡ÏConfigure the MySQL Server now£©£¬½¨Òé¹´Ñ¡Á¢¼´ÅäÖÃÄãµÄMySQL¡£Ðí¶à˵°²×°ÍêMySQLºóÎÞ·¨Æô¶¯£¬Ô­Òò¾ÍÔÚÓÚûÓÐÅäÖÃMySQL¡£µã»÷“Finish”Íê³É°²×°£¬²¢¿ªÊ¼ÅäÖÃMySQL
µã“Next”£¬½øÈëÅäÖÃÀàÐÍÑ¡ÔñÒ³Ã档ѡ“Detailed configuration”£¨ÏêϸÅäÖã©£¬
µã“Next”£¬½øÈë·þÎñÀàÐÍÑ¡ÔñÒ³Ã档ѡ“Developer Machine”£¨¿ª·¢Õß»úÆ÷£©£¬ÕâÑùÕ¼ÓÃϵͳµÄ×ÊÔ´²»»áºÜ¶à
µã“Next”ºó£¬½øÈëÊý¾Ý¿âÓ÷¨Ñ¡ÔñÒ³Ã档ѡÔñ“Multifunctional Database“
µã“Next”£¬½øÈëÑ¡ÔñInnoDBÊý¾Ý´æ·ÅλÖÃÒ³Ãæ
²»Óøü¸ÄÉèÖã¬Ö±½Ó·ÅÔÚInstallation Path°²×°Ä¿Â¼Àï¼´¿É£¬È»ºóµã“Next”£¬Ñ¡ÔñMySQLµÄͬʱÁª½ÓÊý
Ñ¡Ôñ“Manual Setting”£¬ÉèÖÃΪ100£¨¸ù¾Ý×Ô¼ºÐèÒª£¬×ÃÇéÉèÖã©£¬µã“Next”£¬ÅäÖÃMySQLÔÚTCP/IPͨѶ»·¾³ÖеĶ˿Ú
Ñ¡ÔñĬÈϵÄ3306¶Ë¿Ú¼´¿É¡£µã“Next”£¬Ñ¡ÔñMySQLÖеÄ×Ö·ûÉèÖÃ
×¢Ò⣬ÕâÀïµÄÑ¡Ôñ½«»áÓ°ÏìÄãÊÇ·ñÄÜÔÚMySQLÖÐʹÓÃÖÐÎÄ¡£ÎÒÃÇÑ¡ÔñGBKÖ§³ÖµÄ×Ö·û¼¯¶àһЩ¡£µã“Next”£¬ÉèÖÃWindows·þÎñÑ¡Ïî
×¢Ò⣬ÕâÀïµÄÑ¡ÔñºÜ¹Ø¼ü¡£“Install As Windows Service”Ò»¶¨Òª¹´Ñ¡£¬ÕâÊǽ«MySQL×÷ΪWindowsµÄ·þÎñÔËÐС£“Service Name”¾ÍÓÃĬÈϵēMySQL”»òÕßÄãϲ»¶µÄ·þÎñÃû£¨ÍƼöÓÃĬÈϵēMySQL”£©¡£ÏÂÃæµÄ“Launch the MySQL Server automatically”Ò»¶¨Òª¹´Ñ¡£¬ÕâÑùWindowsÆô¶¯Ê±£¬MySQL¾Í»á×Ô¶¯Æô¶¯·þÎñ£¬Òª²»È»¾ÍÒªÊÖ¹¤Æô¶¯MySQL¡£Ðí¶àÈË˵°²×°MyS


Ïà¹ØÎĵµ£º

Mysql½ø»¯ÂÛ2


MysqlËùÖ§³ÖµÄÒýÇæÄ¿Ç°ÓÐÒÔϼ¸ÖÖ£º
MyISAM,InnoDB,MERGE,MEMORY(HEAR),BDB(BerkeleyDB),EXAMPLE,FEDERATED,ARCHIVE,CSV,BLACKHOLE.
ΪʲôҪÓÐÕâô¶àÒýÇ棿Ö÷ÒªÊÇMysqlÊÇÒ»¿î¼«ÎªÇ¿´óµÄÊý¾Ý¿â£¬ËüÊÊÓ¦ºÜ¶à²»Í¬µÄÔËÐл·¾³£¬ÎªÁËÂú×ã¸÷ÖÖ²»Í¬µÄÔËÐл·¾³Óë´æ´¢·½°¸µÄÐèÒª£¬ÕâЩËÑË÷ÒýÇæÒ²¾ÍÓ¦Ô˶øÉú£¨²»¹âÊÇΪÁËÅäºÏMysql ......

ʹÓà MySQL Workbench ¿ÉÊÓ»¯µÄÉè¼Æ MySQL Êý¾Ý¿â

MySQL Workbench ÊÇ MySQL ×î½üÊͷŵĿÉÊÓÊý¾Ý¿âÉè¼Æ¹¤¾ß¡£Õâ¸ö¹¤¾ßÊÇÉè¼Æ MySQL Êý¾Ý¿âµÄרÓù¤¾ß¡£
ÄãÔÚ MySQL Workbench Öн¨Á¢µÄ±»³Æ֮ΪÎïÀíÊý¾ÝÄ£ÐÍ¡£Ò»¸öÎïÀíÊý¾ÝÄ£ÐÍÊÇÕë¶ÔÒ»¸öÌض¨ RDBMS ²úÆ·µÄÊý¾ÝÄ£ÐÍ£»±¾ÎÄÖеÄÄ£Ðͽ«¾ßÓÐһЩ MySQL µÄ¶ÀÌع淶¡£ÎÒÃÇ¿ÉÒÔʹÓÃËüÉú³É£¨forward-engineer£©Êý¾Ý¿â¶ÔÏ󣬳ýÁË°üº¬± ......

mysqlÎļþµ¼ÈëÂÒÂëÎÊÌâµÄ½â¾ö£º

mysqlÎļþµ¼ÈëÂÒÂëÎÊÌâµÄ½â¾ö£º
1 ÃüÁî²ì¿´×Ö·ûÉèÖá£
mysql> show   variables   like   "%char%";
2 ½«²»ÊÇutf-8µÄ¶¼¸Ä³Éutf8¡£Ö»ÓÐfilesystem²»±ä;
| Variable_name            | Value
   &nb ......

mysqlÍâ¼üµÄʹÓÃ

ÏñMySQLÕâÑùµÄ¹ØϵÐÍÊý¾Ý¿â¹ÜÀíϵͳ£¬ËüÃǵĻù´¡ÊÇÔÚÊý¾Ý¿âµÄ±íÖ®¼ä´´½¨¹ØϵµÄÄÜÁ¦¡£Í¨¹ý·½±ãµØÔÚ²»Í¬±íÖн¨Á¢¼Ç¼µ½¼Ç¼µÄÁªÏµ£¬RDBMS¿ÉÒÔÀûÓò»Í¬µÄ·½·¨·ÖÎöÊý¾Ý£¬Í¬Ê±±£³ÖÊý¾Ý¿âÒÔϵͳµÄ·½Ê½¡¢×îСµÄÈßÓà½øÐÐ×éÖ¯¡£
¼òµ¥ÃèÊö£º
ÕâЩ¹Øϵ»ù±¾ÉÏÒÀ¿¿Íâ¼ü½øÐйÜÀí£¬ÔÚ¹ØϵÖÐËùÓбíÖоßÓÐÏàͬº¬ÒåµÄ×Ö¶Î×÷Ϊ¹«¹²²¿·ÖÀ´Á¬½Ó ......

MysqlÓÅ»¯·½°¸Ö®Ë÷ÒýµÄʹÓÃ

 
Ë÷ÒýÓÃÓÚ¿ìËÙÕÒ³öÔÚij¸öÁÐÖÐÓÐÒ»Ìض¨ÖµµÄÐС£²»Ê¹ÓÃË÷Òý£¬MySQL±ØÐë´ÓµÚ1Ìõ¼Ç¼¿ªÊ¼È»ºó¶ÁÍêÕû¸ö±íÖ±µ½ÕÒ³öÏà¹ØµÄÐС£±íÔ½´ó£¬»¨·ÑµÄʱ¼äÔ½¶à¡£Èç¹û±íÖвéѯµÄÁÐÓÐÒ»¸öË÷Òý£¬MySQLÄÜ¿ìËÙµ½´ïÒ»¸öλÖÃÈ¥ËÑÑ°µ½Êý¾ÝÎļþµÄÖм䣬ûÓбØÒª¿´ËùÓÐÊý¾Ý¡£Èç¹ûÒ»¸ö±íÓÐ1000ÐУ¬Õâ±È˳Ðò¶ÁÈ¡ÖÁÉÙ¿ì100±¶¡£×¢ÒâÈç¹ûÄãÐèÒª·ÃÎÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ