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

LinuxÖв鿴ºÍÉèÖÃMySQLÊý¾Ý¿â×Ö·û¼¯(ת)

6
¡¢ÐÞ¸ÄÊý¾Ý¿âµÄ×Ö·û¼¯
mysql>use mydb
mysql>alter database mydb character set utf-8;
 
6
¡¢´´½¨Êý¾Ý¿âÖ¸¶¨Êý¾Ý¿âµÄ×Ö·û¼¯
mysql>create database mydb character set utf-8;
ͨ¹ýÅäÖÃÎļþÉèÖô´½¨Êý¾Ý¿âʱ×Ö·û¼¯:
#vi /var/lib/mysql/mydb/db.opt
default-character-set=latin1
default-collation=latin1_swedish_ci
Ϊdefault-character-set=utf8
default-collation=utf8_general_ci
ÖØÆðMySQL:
# /usr/share/mysql/mysqladmin –uroot –p shutdown
# /usr/share/mysql/bin/mysqld_safe &
 
7
¡¢Í¨¹ýMySQL
ÃüÁîÐÐÐÞ¸Ä:
mysql> set character_set_client=utf8;
Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_connection=utf8;
Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_database=utf8;
Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_results=utf8;
Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_server=utf8;
Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_system=utf8;
Query OK, 0 rows affected (0.01 sec)
mysql> set collation_connection=utf8;
Query OK, 0 rows affected (0.01 sec)
mysql> set collation_database=utf8;
Query OK, 0 rows affected (0.01 sec)
mysql> set collation_server=utf8;
Query OK, 0 rows affected (0.01 sec)
²é¿´:
mysql> show variables like 'character_set_%';
                             
+--------------------------+----------------------------+
| Variable_name           
| Value            
|
           
                  
+--------------------------+----------------------------+
| character_set_client &n


Ïà¹ØÎĵµ£º

MySQLÁ¬½Óʱ¿ìʱÂýµÄÎÊÌâ½â¾ö

 my.iniÀïµÄÄǸötmp_table_sizeµÄÖµ.Ô­À´tmp_table_size=16M.ÎÒ¸ÄΪ32M
È»ºóÖØÆôMYSQL»¹ÊÇû½â¾öÎÊÌâ.
Ö»ºÃÖØÆô·þÎñÆ÷ÊÔÊÔÁË,½á¹ûÖØÆôºóCPUÕý³£ÁË.²»¹ý»¹ÊÇûÕÒ³öÊÇʲôԭÒòµ¼ÖÂMYSQLÕ¼ÓÃÄÇô¶àCPU×ÊÔ´.
=====================================
ÐÞ¸ÄhostsÎļþ£¬¼ÓÈëÒ»ÐР  
172.16.59.12   & ......

UbuntuÏÂmysqlÐÞ¸Ä×Ö·û¼¯

Ê×ÏÈÍ£Ö¹MySQL·þÎñ£ºsudo /etc/init.d/mysql stop
È»ºó±à¼­MySQLÅäÖÃÎļþ£ºsudo gedit /etc/mysql/my.cnf
ÔÚmy.cnfÎļþÖеÄ[client]¶ÎÏÂÃæ¼ÓÈë
default-character-set=utf8
[mysqld_safe]
default-character-set=utf8
[mysqld]
default-character-set=utf8
[mysql]
default-character-set=utf8
ÖØÐÂÆô¶¯MySQL·þÎñ ......

linuxÏÂechoÃüÁîÏê½â£¨×ª£©

 linuxµÄechoÃüÁî, ÔÚshell±à³ÌÖм«Îª³£ÓÃ, ÔÚÖÕ¶ËÏ´òÓ¡±äÁ¿valueµÄʱºòÒ²Êdz£³£Óõ½µÄ, Òò´ËÓбØÒªÁ˽âÏÂechoµÄÓ÷¨
echoÃüÁîµÄ¹¦ÄÜÊÇÔÚÏÔʾÆ÷ÉÏÏÔʾһ¶ÎÎÄ×Ö£¬Ò»°ãÆðµ½Ò»¸öÌáʾµÄ×÷Óá£
¸ÃÃüÁîµÄÒ»°ã¸ñʽΪ£º echo [ -n ] ×Ö·û´®
ÆäÖÐÑ¡Ïîn±íʾÊä³öÎÄ×Öºó²»»»ÐУ»×Ö·û´®ÄܼÓÒýºÅ£¬Ò²Äܲ»¼ÓÒýºÅ¡£ÓÃechoÃüÁîÊä³ö¼ ......

linux ifÓï¾äÄÚÅжϲÎÊý

shell ±à³ÌÖÐʹÓõ½µÃifÓï¾äÄÚÅжϲÎÊý
–b µ±file´æÔÚ²¢ÇÒÊÇ¿éÎļþʱ·µ»ØÕæ
-c µ±file´æÔÚ²¢ÇÒÊÇ×Ö·ûÎļþʱ·µ»ØÕæ
-d µ±pathname´æÔÚ²¢ÇÒÊÇÒ»¸öĿ¼ʱ·µ»ØÕæ
-e µ±pathnameÖ¸¶¨µÄÎļþ»òĿ¼´æÔÚʱ·µ»ØÕæ
-f µ±file´æÔÚ²¢ÇÒÊÇÕý¹æÎļþʱ·µ»ØÕæ
-g µ±ÓÉpathnameÖ¸¶¨µÄÎļþ»òĿ¼´æÔÚ²¢ÇÒÉèÖÃÁËSGIDλʱ·µ»ØÎ ......

¡¾×ª¡¿LinuxʹÓðïÖú˵Ã÷

Viʹ Óà ˵ Ã÷
Linux×÷Ϊһ¸ö¶àÓû§,¶àÈÎÎñµÄ²Ù×÷ϵͳ,ÓÐ×ÅÇ¿´óµÄ¹¦ÄÜ.±¾ÆªÎÒÃǶÔÕÕDOS½²½âһЩÓëDOS¹¦ÄÜÏàËÆµÄLinuxÖ÷ÒªÃüÁî,Ï£ÍûÎÒÃÇ˳ÀûµÄ½øÈëµ½LinuxÊÀ½ç.¸üÏêϸµÄÃüÁîÔÚÒÔºóµÄƪ·ùÀïÒÔTurboLinuxΪÀý½øÐÐ·ÖÆª½éÉÜ
Ò»,Æô¶¯
LinuxµÄÆô¶¯²Ù×÷¹ý³ÌºÍDOSÏàËÆ(¾¡¹ÜÈç´Ë,µ«×÷Ϊ²Ù×÷ϵͳ±¾Éí,LinuxÔÚÆô¶¯ºÍÍ˳öʱËù×÷µÄ¹ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ