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
Ïà¹ØÎĵµ£º
ÕâÀ½éÉÜÒ»ÏÂCentOSÏÂMySQLÊý¾Ý¿â·þÎñÆ÷µÄ¹¹½¨·½·¨¡£
°²×°MySQL¼°Ïà¹Ø×é¼þ
¡¡¡¡Ê×ÏÈ£¬°²×°MySQL¡£
[root@sample ~]#
yum
-y install mysql-server
¡¡ ← °²×°MySQL
Setting up Install Process
Setting up repositories
dag 100% |=========================| 1.1 kB 00:00
update ......
ÓÉÓÚ×î½üÒ»Ö±ÔÚÁ˽âmysql¡£¸÷ÖÖ±íÀàÐ͵ÄÊý¾Ý´æ´¢ÒÔ¼°Ïà¹ØÏÞÖƾÍÊDZØÐëÁ˽âµÄ·½ÃæÁË¡£
×Ô¼ºµÄ·þÎñÆ÷»·¾³£ºOS Cent OS ext3£¬memory 4G£¬ disk 2T block size 4K¡£
¾µ÷²é£¬linuxÏÂÎļþ×î´óÊÇ´æÔÚÏÞÖƵġ£È¥googleÉÏËÑÁËËÑ£¬´ó¼Ò˵·¨²»Ò»£¬×îÖÕ×Ô¼º»¹ÊÇÕÒµ½±È½Ï¹Ù·½µÄ˵¡£Ïê¼ûhttp://en.wikipedia.org/wiki/Ext3 ËùÒÔ× ......
Ò».ÏÈ¿´Ò»Ð©×î¼òµ¥µÄÀý×Ó
Àý×Ó
Table A
aid adate
1 a1
2 a2
3 a3
TableB
bid bdate
1 b1
2 b2
4 b4
Á½¸ö±ía,bÏàÁ¬½Ó,Ҫȡ ......
mysql Êý¾Ý¿âĬÈϵÄÁ¬½ÓÖ»ÄÜÔÚ±¾»úÁ¬½Ó£¬Ô¶³ÌÁ¬½Ó±ØÐëÊÚȨ¡£
´úÂë: È«Ñ¡
¡¡GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%'IDENTIFIED
BY 'mypassword' WITH GRANT
OPTION;Èç¹ûÄãÏëÔÊÐíÓû§myuser´ÓipΪ192.168.1.6µÄÖ÷»úÁ¬½Óµ½mysql·þÎñÆ÷£¬²¢Ê¹ÓÃ
mypassword×÷ΪÃÜÂë
´úÂë: GRANT ALL PR ......