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

mysql×Ö·û¼¯Ð£Ñé¹æÔò

                                                                       mysql×Ö·û¼¯Ð£Ñé¹æÔò 
    mysql ²»Í¬ÓÚÆäËûÊý¾Ý¿â£¨Èçoracle£©£¬Ëü¿ÉÒÔÔÚ¶à¸ö¼¶±ðÉèÖÃ×Ö·û¼¯ºÍУÑé¹æÔò£¬Èçserver¼¶±ð¡¢database¼¶±ð¡¢table¼¶±ðºÍcolumn¼¶±ð¡£Êµ¼ÊÉÏ£¬ÎÒÃÇÉõÖÁ»¹¿ÉÒÔµ¥¶À¶ÔÒ»´®×Ö·û´®É趨Æä×Ö·û¼¯ºÍУÑé¹æÔò£¬»¹¿ÉÒÔÔÚÁ¬½ÓÖÐÉèÖÃÆä×Ö·û¼¯ºÍУÑé¹æÔò£¬ÏÂÃæÀ´¼òµ¥µÄÌÖÂÛÏÂÇ°4ÖÖ¼¶±ðµÄ×Ö·û¼¯ºÍУÑé¹æÔòµÄÉèÖá£
server
    ÔÚÆô¶¯mysql·þÎñµÄʱºò£¬¿ÉÒÔÖ¸¶¨mysql serverµÄ×Ö·û¼¯ºÍУÑé¹æÔò£¬Í¨¹ýÈçÏ·½Ê½£º
mysqld --character-set-server=latin1 --collation-server=latin1_swedish_ci
    Èç¹û²»Ç××ÔÖ¸¶¨ËüÃÇ£¬ÄÇômysql¾Í»áʹÓÃĬÈÏÖµ¡£Ò»°ãÊÇlatin1ºÍlatin1_swedish_ci¡£µ±È»Õâ¸öĬÈÏÖµÊÇ¿ÉÒÔÐ޸ĵģ¬µ«ÊÇ·½·¨Ö»ÓÐÒ»ÖÖ£¬ÄǾÍÊÇÖرàÒëÔ´´úÂë¡£²ÉÓÃÈçÏ·½Ê½£º
./configure --with-charset=gbk  --with-collation=gbk_bin
    ÈçºÎ²éѯµ±Ç°µÄserverµÄ×Ö·û¼¯ºÍУÑé¹æÔòµÄÖµ£¬¿ÉÒԲ鿴ϵͳ²ÎÊýcharacter_set_serverºÍcollation_server£º
mysql> show variables like 'character_set_server%';
+----------------------+--------+
| Variable_name        | Value  |
+----------------------+--------+
| character_set_server | latin1 |
+----------------------+--------+
1 row in set (0.00 sec)
mysql> show variables like 'collation_server%';
+------------------+-------------------+
| Variable_name    | Value             |
+------------------+-------------------+
| collation_server | latin1_swedish_ci |
+------------------+-------------------+
1 row in set (0.00 sec)
   
    serverµÄ×Ö


Ïà¹ØÎĵµ£º

MysqlµÄ°²×°

MysqlµÄ°²×°Îļþ¿ÉÒÔÖ±½Óµ½ http://www.mysql.com ÏÂÔØ£¬»ñµÃfor win32µÄ.zip°ü£¬½¨ÒéÑ¡Ôñ4.0.20d°æ±¾¡£
¡¡¡¡ÏÂÔØ»ñµÃMysqlµÄfor win32°²×°°üºó£¬ÓÃwinzip½âѹËõ£¬Ö±½ÓÔËÐÐsetup.exe£¬ÐèҪעÒâµÄÊÇÑ¡ÔñÒ»¸ö°²×°Â·¾¶£¬µ±È»£¬°²×°Â·¾¶¿ÉÒÔÈÎÒ⣬½¨ÒéÑ¡ÔñC:\MySQLĿ¼¡£°²×°Íê³ÉºóMySQLÒ²¾ÍÍê³ÉÁË¡£Ä¬ÈϵÄÓû§ÃûÊÇroot£¬ÃÜÂë ......

mysql ³£ÓÃÃüÁî

MySQL ÃüÁîÐÐ
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö² ......

MySQLÊý¾Ý¿â²Ù×÷ÖÐÎÄÂÒÂë

½â¾öÂÒÂë×îºÃµÄ·½·¨ÊÇÔÚÏîÄ¿Éè¼ÆÖ®³õ£¬Í³Ò»ËùÓеÄ×Ö·û¼¯£¬ÀýÈçÒ³Ãæ¡¢request¶ÔÏóÒÔ¼°Êý¾Ý¿âµÈµÈ¡£
Ò»¡¢ ¼¸ÖÖ³£¼ûµÄÂÒÂëÏÖÏó£º
1¡¢Ò³ÃæÂÒÂë
    µ¥´¿µÄÒ³ÃæÂÒÂëÊǺܺýâ¾öµÄ£¬Ö»ÒªÐÞ¸ÄÍ·²¿ÊʺϵÄ×Ö·û¼¯¼´¿É£¬Èç¹ûÒ³ÃæÖÐÎÄÏÔʾÂÒÂ룬Äã¿ÉÒÔ°Ñ×Ö·û¼¯ÐÞ¸ÄΪ£ºgb2312»ògbk¡£
2¡¢Ò³ÃæÖ®¼ä´«µÝµÄ²ÎÊýÊÇÂÒÂë ......

MySQLƽ̨Êý¾Ý¿â±¸·Ý·½°¸Ïêϸ˵Ã÷

À´Ô´£ºccidnet.com ×÷ÕߣºSabine¡¡ ʱ¼ä£º2006-10-09
ÔÚÊý¾Ý¿â±í¶ªÊ§»òË𻵵ÄÇé¿öÏ£¬±¸·ÝÄãµÄÊý¾Ý¿âÊǺÜÖØÒªµÄ¡£Èç¹û·¢Éúϵͳ±ÀÀ££¬Äã¿Ï¶¨ÏëÄܹ»½«ÄãµÄ±í¾¡¿ÉÄܶªÊ§×îÉÙµÄÊý¾Ý»Ö¸´µ½±ÀÀ£·¢ÉúʱµÄ״̬¡£ÓÐʱ£¬ÕýÊÇMySQL¹ÜÀíÔ±Ôì³ÉÆÆ»µ¡£¹ÜÀíÔ±ÒѾ­ÖªµÀ±íÒÑÆÆ»µ£¬ÓÃÖîÈçvi»òEmacsµÈ±à¼­Æ÷ÊÔͼֱ½Ó±à¼­ËüÃÇ£¬Õâ¶Ô±í¾ø¶Ô²»ÊǼ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ