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 ......
À´Ô´£ºhttp://www.blogjava.net/Alpha/archive/2007/07/23/131912.html
//Ö÷¼ü549830479
alter table tabelname add new_field_id int(5) unsigned default 0 not null auto_increment ,add primary key (new_field_id);
//Ôö¼ÓÒ»¸öÐÂÁÐ549830479
alter table t2 add d timestamp;
alter table infos add ......
Mysql³£ÓÃÃüÁî½Å±¾
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÊÇ mysql -hÖ÷»ú -uÓû§Ãû -pÃØÃÜ
Àý×ÓÊÇ mysql -hlocalhost -uroot -p123456
Ҫȷ¶¨mysql°²×°Ê±ºò¹´Ñ¡ÁË¿ÉÒÔÔ¶³ÌÁ´½Ó¡£Èç¹ûµÇ½±¾µØ¼ÆËã»ú£¬-h¿ÉÒÔÊ¡ÂÔ£¬¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬 ......
ÏñMySQLÕâÑùµÄ¹ØϵÐÍÊý¾Ý¿â¹ÜÀíϵͳ£¬ËüÃǵĻù´¡ÊÇÔÚÊý¾Ý¿âµÄ±íÖ®¼ä´´½¨¹ØϵµÄÄÜÁ¦¡£Í¨¹ý·½±ãµØÔÚ²»Í¬±íÖн¨Á¢¼Ç¼µ½¼Ç¼µÄÁªÏµ£¬RDBMS¿ÉÒÔÀûÓò»Í¬µÄ·½·¨·ÖÎöÊý¾Ý£¬Í¬Ê±±£³ÖÊý¾Ý¿âÒÔϵͳµÄ·½Ê½¡¢×îСµÄÈßÓà½øÐÐ×éÖ¯¡£
¼òµ¥ÃèÊö£º
ÕâЩ¹Øϵ»ù±¾ÉÏÒÀ¿¿Íâ¼ü½øÐйÜÀí£¬ÔÚ¹ØϵÖÐËùÓбíÖоßÓÐÏàͬº¬ÒåµÄ×Ö¶Î×÷Ϊ¹«¹²²¿·ÖÀ´Á¬½Ó ......
Êý¾Ý¿â²Ù×÷ÀࣺDBCommon.class.php
//---------------------------------------------------------------------
// MySQL Master/SlaveÊý¾Ý¿â¶Áд²Ù×÷Àà
//
// ¿ª·¢×÷Õß: heiyeluren
// °æ±¾ÀúÊ·:
// 2006-09-20 »ù±¾µ¥Êý¾Ý¿â²Ù×÷¹¦ÄÜ, 25 ¸ö½Ó¿Ú
// 2007-07-30 Ö§³Öµ ......