ÀûÓÃmysqlµÄ×¢ÉäµãµÃµ½¸ü¶àmysqlµÄÐÅÏ¢
µ±×¢Éämysql¿âµÄÊäÈëµãµÄʱºò,ÎÒÃÇ¿ÉÒÔͨ¹ýversion()/user()/database()/password()µÈÄÚÖú¯ÊýÀ´µÃµ½mysqlµÄÏà¹ØÐÅÏ¢,ÆäʵÎÒÃÇÔÚ×¢ÉäµÄʱºò¿ÉÒÔÀûÓÃmysqlÄÚÖõıäÁ¿À´µÃµ½¸ü¶àµÄmysqlÐÅÏ¢
ÆäÖÐversion()¿ÉÒÔд³É@@versionÀ´°Ñversionµ±×ö±äÁ¿À´¶ÁÈ¡,ÕâÑùÒ»Ñù¿ÉÒԵõ½,ÆäËûµÄÄÚÖÃÊDz»¿ÉÒÔд³É±äÁ¿µÄÐÎʽ.
´ó¼Ò¶¼Ó¦¸ÃÓùýÀûÓÃpangolinÀ´×¢Èëmysql¿âµÄ×¢Éäµã,ÈÏÕæµÄÅóÓѶ¼Ó¦¸ÃÖªµÀ¿ÉÒԵĵõ½basedirºÍdatadirÕâÁ½¸ö±äÁ¿µÄÐÅÏ¢,Æäʵ»¹Óиü¶àµÄ±äÁ¿ÔÚ×¢ÉäµÄʱºò¿ÉÒÔÀûÓÃ
ÎÒÕûÀíÁ˼¸¸öÔÚ×¢ÉäµÄʱºò¿ÉÒÔÀûÓõ½,ÊÕ¼¯¸ü¶à¹ØÓÚmysqlµÄÅäÖÃÐÅÏ¢
@@have_openssl Èç¹ûmysqldÖ§³Ö¿Í»§¶Ë/·þÎñÆ÷ÐÒéµÄSSL(¼ÓÃÜ)ÔòΪYES
@@version_compile_os ÅжÏϵͳÀàÐÍ
@@max_allowed_packet °ü»òÈκÎÉú³ÉµÄ/Öмä×Ö·û´®µÄ×î´ó´óС
@@max_user_connections MySQLÕË»§ÔÊÐíµÄ×î´óͬʱÁ¬½ÓÊý,0±íʾûÏÞÖÆ
@@skip_networking Èç¹û·þÎñÆ÷Ö»ÔÊÐí±¾µØ(·ÇTCP/IP)Á¬½Ó£¬¸ÃֵΪON
@@table_type ĬÈϱíÀàÐÍ(´æ´¢ÒýÇæ)
@@basedir MySQL°²×°»ù׼Ŀ¼
@@character_set_database ĬÈÏÊý¾Ý¿âʹÓõÄ×Ö·û¼¯
@@datadir Êý¾Ý¿â´æ´¢µÄµØ·½
@@expire_logs_days ¶þ½øÖÆÈÕÖ¾×Ô¶¯É¾³ýµÄÌìÊý,ĬÈÏÊÇ0,±íʾ"ûÓÐ×Ô¶¯É¾³ý"
@@group_concat_max_len ÔÊÐígroup_concat()º¯Êý½á¹ûµÄ×î´ó³¤¶È
@@log_error &nb
Ïà¹ØÎĵµ£º
ÐÞ¸Ä /etc/mysql/my.cnf Îļþ£¬
ÔÚ £Ûclient£Ý ϼÓÈë default-character-set=utf8,
ÔÚ [mysqld] ϼÓÈë default-character-set=utf8,
ÔòÔÚviÀï¿ÉÒÔÕýÈ·µÄÏÔʾÖÐÎÄÁË£¨Ç°ÌáÊÇviҲʹÓÃutf8£©¡£
²»¹ýÔÚ²éѯµÄʱºò£¬½á¹ûÀïµÄÖÐÎÄÈ´»áÏÔʾ³É "?"£¬Õâ¸öÎÊÌâ±È½Ï¼òµ¥µÄ·½·¨Óм¸ÖÖ£¬·Ö±ðÊÇ£º
1.ÔÚ´´½¨Ê ......
Äã¿ÉÒÔ´´½¨Ò»¸öÎı¾Îļþ“pet.txt”£¬Ã¿Ðаüº¬Ò»¸ö¼Ç¼£¬Óö¨Î»·û(tab)°ÑÖµ·Ö¿ª£¬²¢ÇÒÒÔCREATE TABLEÓï¾äÖÐÁгöµÄÁдÎÐò¸ø³ö¡£¶ÔÓÚ¶ªÊ§µÄÖµ(ÀýÈçδ֪µÄÐԱ𣬻òÈÔÈ»»î×ŵ͝ÎïµÄËÀÍöÈÕÆÚ)£¬Äã¿ÉÒÔʹÓÃNULLÖµ¡£ÎªÁËÔÚÄãµÄÎı¾ÎļþÖбíʾÕâЩÄÚÈÝ£¬
ʹÓÃ\N£¨·´Ð±Ïߣ¬×ÖĸN£©¡£ÀýÈ磬WhistlerÄñµÄ¼Ç¼ӦΪ(ÕâÀïÖµÖ® ......
×¼±¸£ºÏÂÔØMysql5.1<mysql-essential-5.1.41-win32.msi>
°²×°£ºstep by step
²âÊÔ£º1.MySQL²âÊÔ
µã¿ªMySQL Command Line Client, ÊäÈ밲װʱ½¨Á¢µÄÃÜÂë¡£
mysql>show databases;
mysql>use <<database name>>;
mysql>show tables;
mysql>select * from <<table name>>;
......