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 ÃüÁîÐÐ
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈ ......
ÓÉÓÚ×î½üÒ»Ö±ÔÚÁ˽âmysql¡£¸÷ÖÖ±íÀàÐ͵ÄÊý¾Ý´æ´¢ÒÔ¼°Ïà¹ØÏÞÖƾÍÊDZØÐëÁ˽âµÄ·½ÃæÁË¡£
×Ô¼ºµÄ·þÎñÆ÷»·¾³£ºOS Cent OS ext3£¬memory 4G£¬ disk 2T block size 4K¡£
¾µ÷²é£¬linuxÏÂÎļþ×î´óÊÇ´æÔÚÏÞÖƵġ£È¥googleÉÏËÑÁËËÑ£¬´ó¼Ò˵·¨²»Ò»£¬×îÖÕ×Ô¼º»¹ÊÇÕÒµ½±È½Ï¹Ù·½µÄ˵¡£Ïê¼ûhttp://en.wikipedia.org/wiki/Ext3 ËùÒÔ× ......
ÍêÕûµÄʵÏÖÁËPHP½«Í¼Æ¬´æÈëMYSQL
Ç°Ì᣺
1 Ê×ÏȱØÐëÓµÓÐPHPµÄÔËÐл·¾³£¬ÁíÍ⻹µÃÓÐMYSQLÊý¾Ý¿â
2 Èç¹ûÎļþ²»ÄÜÉÏ´«³É¹¦Çë¼ì²épicsÊÇ·ñÊÇ¿ÉдµÄȨÏÞ
Ê×ÏÈÏÈ°Ñpic2db.rarÎļþ½âѹµ½PHP¿ÉÒÔÔËÐÐĿ¼Ï¡£
Æä´ÎÔÚMYSQLÖн¨Á¢Ò»¸öÊý¾Ý¿â:pic2db,È»ºóÔÚ¸ÃÊý¾Ý¿âϽ¨Á¢Ò»¸ö±í£¬±í½á¹¹Îª£º
CREATE TABLE `pi ......
Class.forName("com.mySQL.jdbc.Driver");
String strUrl="jdbc:mysql://localhost:3306/stu?useUnicode=true&characterEncoding=GB2312";
String strUser="nuey";
String strPassword="password";
Connection conn=DriverManager.getCon ......