LinuxÏÂmysqlÖÐÎÄÂÒÂë½â¾ö·½·¨
ÉÏ´ÎÔÚÅöµ½ÕâÎÊÌ⣬ÔÚÍøÉÏÕÒÁ˽â¾ö·½·¨£¬¿ÉÊÇû¼ÇÏÂÀ´¡£ÕâÐÇÆÚÒª»»»úÆ÷£¬Òª°ÑÔÀ´linuxϵÄmysqlÊý¾Ý¿âÒÆµ½Áíһ̨·þÎñÆ÷ÉÏ¡£°²×°suseϵͳ¡¢ÔÙÅäÖÃtelnet¡¢ftp·þÎñ¡¢°²×°java JDK²¢ÅäÖá¢ÔÙ°²×°eclipseºÍmysql,ÓÖ»¨ÁËÒ»ÌìµÄʱ¼ä¡£¸Ð¾õ»¹ÊDz»ÊìÁ·£¬ÅäÖ÷À»ðǽÀÏÊDz»Äܽ«telnetºÍftp·þÎñÅÅÍâ¡£mysqlÓÖÅöµ½ÁËÖÐÎÄÂÒÂëÎÊÌ⣬ÓÖÔÚÍøÉÏÕÒÒ»ÕÒ£¬ÏÖÔڰѽâ¾ö·½·¨ÏȼÇÏÂÀ´°É¡£
ϵͳ»·¾³:suse linux server 10,mysql 5.0
°²×°mysqlºó£¬Ä¬ÈϵÄ×Ö·û¼¯ÊÇlatin1¡£ÔÚlinuxϰ²×°mysql²»ÏñÔÚwindowsÉϰ²×°ÄÇÏñ£¬¿ÉÒÔÑ¡Ôñ×Ö·û¼¯(¼´Ê¹µ±Ê±Ê¹ÓÃÁËĬÈϵÄ×Ö·û¼¯£¬°²×°ºóÒ²¿ÉÒÔÔÚ°²×°Ä¿Â¼ÏÂÐÞ¸Ämy.iniÎļþ£©£¬µ«ÊÇÔÚlinux¾Í²»Ì«Ò»ÑùÁË¡£
ÔÚshellÊäÈëmysqlµÇ½ºó:
mysql>show variables like '%char%';
»Ø³µºóÏÔʾ:
+---------------------£+-----££--------------
| Variable_name | Value
+-----------------------+-££------------------
| character_set_client | latin1
| character_set_connection | latin1
| character_set_database | latin1
| character_set_filesystem | binary
| character_set_results | latin1
| character_set_server | latin1
| character_set_system | utf8
| character_sets_dir | /usr/share/mysql/charsets/
+---------------------+£££-------------------
Õâ¾ÍÊÇËüĬÈϵÄÉèÖá£
½ÓÏÂÀ´µ½/usr/share/mysql/Ŀ¼Ï£¬½«my-medium.cnfÎļþ(ʹÓÃÆäËüʵÀýÅäÖÃÎļþÒ²ÐÐ)¿½±´µ½/etcĿ¼Ï£º
pds:~# cp /usr/share/mysql/my-medium.cnf /etc/my.cnf
pds:~# vi /etc/my.cnf
·Ö±ðÔÚÈçϼ¸ÏîÖÐÌí¼Ó×Ö·û¼¯£º
[client]
default-character-set=gb2312
[mysqld_safe]
default-character-set=gb2312
[mysqld]
default-character-set=gb2312
#default-table-type=innodb
[mysql]
default-character-set=gb2312
ÔÙÖØÆômysqlÈÃÅäÖÃÉúЧ:
pds:~# service mysql restart
Shutting down MySQL done
Starting MySQL done
Ôٴεǽmysqlºó£¬²é¿´±äÁ¿£º
mysql>show variables like '%char%';
+---------------------£+-----££--------------
| Variable_name | Value
+-----------------------+-££------------------
| character_set_client | gb2312
| character_set_connection | gb2312
| character_set_database | gb2312
| character_set_filesystem | binary
| character_set_results | gb2
Ïà¹ØÎĵµ£º
ÄÚ´æ¹ÜÀíµÄÄ¿±êÊÇÌṩһÖÖ·½·¨£¬ÎªÊµÏÖ¸÷ÖÖÄ¿µÄ¶øÔÚ¸÷¸öÓû§Ö®¼äʵÏÖÄÚ´æ¹²Ïí¡£ÄÚ´æ¹ÜÀí·½·¨Ó¦¸ÃʵÏÖÒÔÏÂÁ½¸ö¹¦ÄÜ£ºÒ»ÊÇ×îС»¯¹ÜÀíÄÚ´æËùÐèµÄʱ¼ä£»¶þÊÇ×î´ó»¯ÓÃÓÚÒ»°ãÓ¦ÓõĿÉÓÃÄڴ棨×îС»¯¹ÜÀí¿ªÏú£©¡£ÄÚ´æ¹ÜÀíʵ¼ÊÉÏÊÇÒ»ÖÖ¹ØÓÚȨºâµÄÁãºÍÓÎÏ·¡£Äú¿ÉÒÔ¿ª·¢Ò»ÖÖʹÓÃÉÙÁ¿ÄÚ´æ½øÐйÜÀíµÄËã· ......
Á¬Ðø¼¸Ìì°²×°ÅäÖúÍÁ¬½ÓMysqlÊý¾Ý¿â£¬½ñÌìÖÕÓڳɹ¦ÁË£¬»ØÏëÕ⼸Ìì£¬ÕæµÄÊÇÌðËá¿àÀ±¶¼ÓУ¬µ¥mysql¾Í֨װÁ˲»ÏÂ10´Î£¬¶øÔÚeclipseÉϱàдµÄÁ¬½ÓÊý¾Ý¿âµÄ³ÌÐò×ÜÊDZ¨´í£®ÎÒ¶¼ÒѾdownÁËoracal×¼±¸·ÅÆúmysqlÁË£¬²»¹ý£®£®£®¾ÍÏóµçÊÓ¾çÑݵÄÄÇÑù£¬×ª»ú×ÜÊÇÔÚÕâ¸öʱºò³öÏÖ£¬ÏÈÊÇ¿´µ½ÁËsaulzy¹ØÓÚmysql4.1.11°æ±¾µÄ°²×°½éÉÜ£¬½Ó×ÅÓÖÕ ......
mysqlµÄÊý¾Ý´¢´æÄ¿Â¼ÔÚmysqlµÄÅäÖÃÎļþmy.iniÎļþÉèÖ㬸ñʽÈçÏ£º
# Uncomment the following rows if you move the MySQL distribution to another
# location
basedir = d:/cyoa/mysql_cy/
datadir = d:/cyoa/mysql_cy/data/
ÆäÖÐdatadirĿ¼¶¨ÒåÁËmysqlµÄÊý¾Ý´æ´¢Î»Öã¬MySQLµÄÿ¸ ......
1.ÔÚORACLEÖÐÓÃselect * from all_usersÏÔʾËùÓеÄÓû§£¬¶øÔÚMYSQLÖÐÏÔʾËùÓÐÊý¾Ý¿âµÄÃüÁîÊÇshow
databases¡£¶ÔÓÚÎÒµÄÀí½â£¬ORACLEÏîÄ¿À´ËµÒ»¸öÏîÄ¿¾ÍÓ¦¸ÃÓÐÒ»¸öÓû§ºÍÆä¶ÔÓ¦µÄ±í¿Õ¼ä£¬¶øMYSQLÏîÄ¿ÖÐÒ²Ó¦¸ÃÓиöÓû§ºÍÒ»¸ö¿â¡£ÔÚ
ORACLE(db2Ò²Ò»Ñù)Öбí¿Õ¼äÊÇÎļþϵͳÖеÄÎïÀíÈÝÆ÷µÄÂß¼±íʾ£¬ÊÓͼ¡¢´¥·¢Æ÷ºÍ´æ´¢¹ý³ÌÒ²¿É ......