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µÄ°²×°Îļþ¿ÉÒÔÖ±½Óµ½ http://www.mysql.com ÏÂÔØ£¬»ñµÃfor win32µÄ.zip°ü£¬½¨ÒéÑ¡Ôñ4.0.20d°æ±¾¡£
¡¡¡¡ÏÂÔØ»ñµÃMysqlµÄfor win32°²×°°üºó£¬ÓÃwinzip½âѹËõ£¬Ö±½ÓÔËÐÐsetup.exe£¬ÐèҪעÒâµÄÊÇÑ¡ÔñÒ»¸ö°²×°Â·¾¶£¬µ±È»£¬°²×°Â·¾¶¿ÉÒÔÈÎÒ⣬½¨ÒéÑ¡ÔñC:\MySQLĿ¼¡£°²×°Íê³ÉºóMySQLÒ²¾ÍÍê³ÉÁË¡£Ä¬ÈϵÄÓû§ÃûÊÇroot£¬ÃÜÂë ......
MySQL ÃüÁîÐÐ
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö² ......
½â¾öÂÒÂë×îºÃµÄ·½·¨ÊÇÔÚÏîÄ¿Éè¼ÆÖ®³õ£¬Í³Ò»ËùÓеÄ×Ö·û¼¯£¬ÀýÈçÒ³Ãæ¡¢request¶ÔÏóÒÔ¼°Êý¾Ý¿âµÈµÈ¡£
Ò»¡¢ ¼¸ÖÖ³£¼ûµÄÂÒÂëÏÖÏó£º
1¡¢Ò³ÃæÂÒÂë
µ¥´¿µÄÒ³ÃæÂÒÂëÊǺܺýâ¾öµÄ£¬Ö»ÒªÐÞ¸ÄÍ·²¿ÊʺϵÄ×Ö·û¼¯¼´¿É£¬Èç¹ûÒ³ÃæÖÐÎÄÏÔʾÂÒÂ룬Äã¿ÉÒÔ°Ñ×Ö·û¼¯ÐÞ¸ÄΪ£ºgb2312»ògbk¡£
2¡¢Ò³ÃæÖ®¼ä´«µÝµÄ²ÎÊýÊÇÂÒÂë ......
À´Ô´£ºccidnet.com ×÷ÕߣºSabine¡¡ ʱ¼ä£º2006-10-09
ÔÚÊý¾Ý¿â±í¶ªÊ§»òË𻵵ÄÇé¿öÏ£¬±¸·ÝÄãµÄÊý¾Ý¿âÊǺÜÖØÒªµÄ¡£Èç¹û·¢Éúϵͳ±ÀÀ££¬Äã¿Ï¶¨ÏëÄܹ»½«ÄãµÄ±í¾¡¿ÉÄܶªÊ§×îÉÙµÄÊý¾Ý»Ö¸´µ½±ÀÀ£·¢ÉúʱµÄ״̬¡£ÓÐʱ£¬ÕýÊÇMySQL¹ÜÀíÔ±Ôì³ÉÆÆ»µ¡£¹ÜÀíÔ±ÒѾ֪µÀ±íÒÑÆÆ»µ£¬ÓÃÖîÈçvi»òEmacsµÈ±à¼Æ÷ÊÔͼֱ½Ó±à¼ËüÃÇ£¬Õâ¶Ô±í¾ø¶Ô²»ÊǼ ......